APPS.HR_PERSON_RECORD dependencies on BEN_PGM_F

Line 1489: (select name from ben_pgm_f pgm

1485: (
1486: select pln.name Plan_Name,
1487: opt.name Option_Name,
1488: plt.name plan_type_name,
1489: (select name from ben_pgm_f pgm
1490: where p_effective_date between pgm.effective_start_date
1491: and pgm.effective_end_date
1492: and pgm.pgm_id=epe.pgm_id
1493: and pgm.business_group_id = p_business_group_id) Program_Name,

Line 1773: (select name from ben_pgm_f pgm

1769: pen.enrt_cvg_strt_dt ,
1770: 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,
1771: decode(pen1.prtt_enrt_rslt_id , null, 'N', 'Y') interim,
1772: ler.name le_name,
1773: (select name from ben_pgm_f pgm
1774: where p_effective_date between pgm.effective_start_date
1775: and pgm.effective_end_date
1776: and pgm.pgm_id=epe.pgm_id
1777: and pgm.business_group_id = p_business_group_id) Program_Name,

Line 1843: (select name from ben_pgm_f pgm

1839: decode(pen.enrt_cvg_thru_dt,
1840: to_date('31-12-4712','DD-MM-YYYY'),to_date(null),pen.enrt_cvg_thru_dt) enrt_cvg_thru_dt,
1841: decode(pen1.prtt_enrt_rslt_id , null, 'N', 'Y') interim,
1842: ler.name le_name,
1843: (select name from ben_pgm_f pgm
1844: where p_effective_date between pgm.effective_start_date
1845: and pgm.effective_end_date
1846: and pgm.pgm_id=epe.pgm_id
1847: and pgm.business_group_id = p_business_group_id) Program_Name,