---
title: "Comment by Jochen Zehe on \"APEX Popup LOV Deep Dive\" | Hashnode"
description: "Improvement 2: Ability to pass in parameters from the calling page. Jon Dixon You could use Source Type = &quot;Function Returning SQL&quot; instead of a SQL Qu"
url: "https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/648ac49e1c2b5dbd4dc8f5b5"
---

[Discussion](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628)

Comment [APEX Popup LOV Deep Dive](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628)

[Jochen Zehe](https://hashnode.com/@jozzh)

[Jun 15, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/648ac49e1c2b5dbd4dc8f5b5)

Improvement 2: Ability to pass in parameters from the calling page.

[Jon Dixon](https://hashnode.com/@orclapex) You could use Source Type = "Function Returning SQL" instead of a SQL Query.

return lov.get\_emp\_list ('P' || :APP\_PAGE\_ID || '\_DEPT\_ID');"

[Jon Dixon](https://hashnode.com/@orclapex)

[Jun 15, 2023](https://hashnode.com/posts/apex-popup-lov-deep-dive/6388b5636ea8d1f3f4c3c628/comment/648ac49e1c2b5dbd4dc8f5b5#reply-648b0b2858844acb4aefeab1)

Thanks for the idea Jochen. That would work. I was just trying to nudge Oracle into adding the ability to do this declaratively :)
