APPS.PQH_SS_UTILITY dependencies on BEN_ELIG_PER_F

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 521: FROM ben_elig_per_f eper

517: ,p_effectiveDate IN DATE ) RETURN VARCHAR2 IS
518: --
519: CURSOR cur_elig IS
520: SELECT eper.elig_flag eligibility_flag
521: FROM ben_elig_per_f eper
522: WHERE eper.pl_id = p_planId
523: AND eper.pgm_id IS NULL
524: AND eper.person_id = p_personId
525: AND p_EffectiveDate BETWEEN eper.effective_start_date AND eper.effective_end_date

Line 528: l_isEligible BEN_ELIG_PER_F.elig_flag%TYPE;

524: AND eper.person_id = p_personId
525: AND p_EffectiveDate BETWEEN eper.effective_start_date AND eper.effective_end_date
526: ORDER BY eper.effective_start_date desc;
527: --
528: l_isEligible BEN_ELIG_PER_F.elig_flag%TYPE;
529: --
530: BEGIN
531: --
532: OPEN cur_elig;