APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_PTNL_LER_FOR_PER

Line 552: ben_ptnl_ler_for_per ppl

548: ,pel.pgm_id pgm_id
549: ,pel.pil_elctbl_chc_popl_id pil_elctbl_chc_popl_id
550: FROM ben_pil_elctbl_chc_popl pel,
551: ben_per_in_ler pil,
552: ben_ptnl_ler_for_per ppl
553: WHERE pel.per_in_ler_id = pil.per_in_ler_id
554: AND ppl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id
555: AND pil.per_in_ler_id = p_pil_rec.per_in_ler_id
556: );

Line 591: ben_ptnl_ler_for_per ppl

587: THEN 'BCKDT'
588: ELSE pil.per_in_ler_stat_cd END ) per_in_ler_stat_cd
589: ,pil.business_group_id
590: FROM ben_per_in_ler pil,
591: ben_ptnl_ler_for_per ppl
592: WHERE pil.per_in_ler_id = p_per_in_ler_id
593: AND ppl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id;
594:
595: l_pil_rec G_PIL_REC_TYPE;