APPS.PQH_GSP_UTILITY dependencies on DUAL

Line 3760: select 1 from dual where exists (

3756: --
3757: --
3758: Function get_which_rates (p_copy_entity_txn_id in Number) Return Varchar2 is
3759: cursor c1 is
3760: select 1 from dual where exists (
3761: select 1
3762: FROM BEN_COPY_ENTITY_RESULTS
3763: WHERE NVL(INFORMATION104,'PPP') NOT IN ('UNLINK')
3764: AND TABLE_ALIAS ='COP'

Line 3801: select 1 from dual where exists (

3797: l_get_which_rates varchar2(20) := get_which_rates(p_copy_entity_txn_id);
3798: l_icon varchar2(20) := 'NONE';
3799: cnt number := 0;
3800: cursor c1 is
3801: select 1 from dual where exists (
3802: select 1 from ben_copy_entity_results
3803: where copy_entity_txn_id = p_copy_entity_txn_id
3804: and gs_parent_entity_result_id = p_copy_entity_result_id);
3805: l_proc varchar2(72) := g_package||'.get_rates_icon_enabled';