APPS.BEN_PERSON_RECORD dependencies on BEN_PGM_F

Line 19: (select name from ben_pgm_f pgm

15: (
16: select pln.name Plan_Name,
17: opt.name Option_Name,
18: plt.name plan_type_name,
19: (select name from ben_pgm_f pgm
20: where p_effective_date between pgm.effective_start_date
21: and pgm.effective_end_date
22: and pgm.pgm_id=epe.pgm_id
23: and pgm.business_group_id = p_business_group_id) Program_Name,

Line 305: (select name from ben_pgm_f pgm

301: pen.enrt_cvg_strt_dt ,
302: decode(pen.enrt_cvg_thru_dt,to_date('31-12-4712','DD-MM-YYYY'),to_date(null),pen.enrt_cvg_thru_dt) enrt_cvg_thru_dt,
303: decode(pen1.prtt_enrt_rslt_id , null, 'N', 'Y') interim,
304: ler.name le_name,
305: (select name from ben_pgm_f pgm
306: where p_effective_date between pgm.effective_start_date
307: and pgm.effective_end_date
308: and pgm.pgm_id=epe.pgm_id
309: and pgm.business_group_id = p_business_group_id) Program_Name,

Line 375: (select name from ben_pgm_f pgm

371: decode(pen.enrt_cvg_thru_dt,
372: to_date('31-12-4712','DD-MM-YYYY'),to_date(null),pen.enrt_cvg_thru_dt) enrt_cvg_thru_dt,
373: decode(pen1.prtt_enrt_rslt_id , null, 'N', 'Y') interim,
374: ler.name le_name,
375: (select name from ben_pgm_f pgm
376: where p_effective_date between pgm.effective_start_date
377: and pgm.effective_end_date
378: and pgm.pgm_id=epe.pgm_id
379: and pgm.business_group_id = p_business_group_id) Program_Name,