DBA Data[Home] [Help]

APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 2309: From ben_pil_elctbl_chc_popl popl,

2305: ,pgm.name
2306: ,pgm.pgm_uom uom
2307: ,pgm.acty_ref_perd_cd acty_ref_perd_cd
2308: ,popl.pil_elctbl_chc_popl_id
2309: From ben_pil_elctbl_chc_popl popl,
2310: ben_pgm_f pgm
2311: Where popl.per_in_ler_id = p_per_in_ler_id
2312: and popl.pgm_id =pgm.pgm_id
2313: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;

Line 2321: ben_pil_elctbl_chc_popl popl

2317: Select distinct pt.pl_typ_id,
2318: pt.name
2319: From ben_pl_typ_f pt,
2320: ben_elig_per_elctbl_chc epe,
2321: ben_pil_elctbl_chc_popl popl
2322: Where pt.pl_typ_id = epe.pl_typ_id
2323: and popl.per_in_ler_id = p_per_in_ler_id
2324: and popl.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
2325: and epe.comp_lvl_cd = 'PLAN'

Line 2964: From ben_pil_elctbl_chc_popl popl,

2960: ,pgm.name
2961: ,pgm.pgm_uom uom
2962: ,pgm.acty_ref_perd_cd acty_ref_perd_cd
2963: ,popl.pil_elctbl_chc_popl_id
2964: From ben_pil_elctbl_chc_popl popl,
2965: ben_pgm_f pgm
2966: Where popl.per_in_ler_id = p_per_in_ler_id
2967: and popl.pgm_id =pgm.pgm_id
2968: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;

Line 2977: ben_pil_elctbl_chc_popl popl

2973: pt.name
2974: From ben_pl_typ_f pt
2975: Where pt.pl_typ_id IN ( Select epe.pl_typ_id
2976: From ben_elig_per_elctbl_chc epe,
2977: ben_pil_elctbl_chc_popl popl
2978: Where popl.per_in_ler_id = p_per_in_ler_id
2979: and popl.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
2980: and epe.comp_lvl_cd = 'PLAN'
2981: and popl.pl_id = epe.pl_id