APPS.PQH_SS_UTILITY dependencies on BEN_POPL_RPTG_GRP

Line 29: from BEN_POPL_RPTG_GRP_F prg

25: --
26: cursor c_run(p_person_id number, p_rptg_grp_id number,
27: p_business_group_id number) is
28: select 'x'
29: from BEN_POPL_RPTG_GRP_F prg
30: where rptg_grp_id = p_rptg_grp_id
31: and business_group_id = p_business_group_id
32: and prg.pgm_id is null
33: and sysdate between prg.effective_start_date and prg.effective_end_date;

Line 40: from BEN_POPL_RPTG_GRP_F prg, ben_elig_per_f eper

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
42: and person_id = p_person_id
43: and prg.pl_id = eper.pl_id
44: and eper.pgm_id is null

Line 55: from BEN_POPL_RPTG_GRP_F prg, ben_elig_per_f eper

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
57: and person_id = p_person_id
58: and prg.pl_id = eper.pl_id
59: and eper.pgm_id is null

Line 150: from BEN_POPL_RPTG_GRP prg, ben_elig_per_f eper

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
152: and person_id = p_person_id
153: and prg.pl_id = eper.pl_id
154: and eper.pgm_id is null

Line 979: FROM ben_popl_rptg_grp_f

975: --
976: cursor c2(p_reporting_group_id number, p_business_group_id number,
977: p_effective_date date) is
978: SELECT 'x'
979: FROM ben_popl_rptg_grp_f
980: where rptg_grp_id = p_reporting_group_id
981: and business_group_id = p_business_group_id
982: and trunc(p_effective_date) between effective_start_date and effective_end_date;
983: --