APPS.PQH_GSP_UTILITY dependencies on DUAL

Line 3641: select 1 from dual where exists (

3637: --
3638: --
3639: Function get_which_rates (p_copy_entity_txn_id in Number) Return Varchar2 is
3640: cursor c1 is
3641: select 1 from dual where exists (
3642: select 1
3643: FROM BEN_COPY_ENTITY_RESULTS
3644: WHERE NVL(INFORMATION104,'PPP') NOT IN ('UNLINK')
3645: AND TABLE_ALIAS ='COP'

Line 3682: select 1 from dual where exists (

3678: l_get_which_rates varchar2(20) := get_which_rates(p_copy_entity_txn_id);
3679: l_icon varchar2(20) := 'NONE';
3680: cnt number := 0;
3681: cursor c1 is
3682: select 1 from dual where exists (
3683: select 1 from ben_copy_entity_results
3684: where copy_entity_txn_id = p_copy_entity_txn_id
3685: and gs_parent_entity_result_id = p_copy_entity_result_id);
3686: l_proc varchar2(72) := g_package||'.get_rates_icon_enabled';