APPS.PQH_SS_UTILITY dependencies on DUAL

Line 37: from dual

33: and sysdate between prg.effective_start_date and prg.effective_end_date;
34: --
35: cursor c_eligible(p_person_id number, p_rptg_grp_id number) is
36: select 'x'
37: from dual
38: where exists
39: (select eper.pl_id
40: from BEN_POPL_RPTG_GRP_F prg, ben_elig_per_f eper
41: where rptg_grp_id = p_rptg_grp_id

Line 52: from dual

48: );
49: --
50: cursor c_ineligible(p_person_id number, p_rptg_grp_id number) is
51: select 'x'
52: from dual
53: where exists
54: (select eper.pl_id
55: from BEN_POPL_RPTG_GRP_F prg, ben_elig_per_f eper
56: where rptg_grp_id = p_rptg_grp_id

Line 147: from dual

143: p_rptg_grp_id number) return boolean is
144: --
145: cursor c1(p_person_id number, p_rptg_grp_id number) is
146: select 'x'
147: from dual
148: where exists
149: (select eper.pl_id
150: from BEN_POPL_RPTG_GRP prg, ben_elig_per_f eper
151: where rptg_grp_id = p_rptg_grp_id

Line 580: execute immediate 'begin select '||p_function||'into pqh_ss_utility.l_description from dual; end;';

576: begin
577: if p_function is null then
578: return null;
579: else
580: execute immediate 'begin select '||p_function||'into pqh_ss_utility.l_description from dual; end;';
581: end if;
582: return pqh_ss_utility.l_description;
583: end get_desc;
584: