APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 107: from ben_pil_elctbl_chc_popl

103: --
104: /* Cursor Not being used in the code
105: cursor c_enrt_window is
106: select enrt_perd_strt_dt
107: from ben_pil_elctbl_chc_popl
108: where pil_elctbl_chc_popl_id = l_epe_rec.pil_elctbl_chc_popl_id;
109: --
110: */
111: cursor c_min_max_date (p_prtt_enrt_rslt_id number) is

Line 966: ben_pil_elctbl_chc_popl pel

962: epe.cryfwd_elig_dpnt_cd
963: from ben_elig_per_elctbl_chc epe,
964: ben_enrt_bnft enb,
965: ben_per_in_ler pil,
966: ben_pil_elctbl_chc_popl pel
967: where NVL(enb.crntly_enrld_flag(+),epe.crntly_enrd_flag) = 'Y'
968: and pil.person_id = p_person_id
969: and pil.per_in_ler_id = p_per_in_ler_id
970: and epe.per_in_ler_id = pil.per_in_ler_id

Line 1007: ben_pil_elctbl_chc_popl pel

1003: cursor c_elctbl_epe is
1004: select null
1005: from ben_elig_per_elctbl_chc epe,
1006: ben_per_in_ler pil,
1007: ben_pil_elctbl_chc_popl pel
1008: where epe.elctbl_flag = 'Y'
1009: --and pil.business_group_id = p_business_group_id
1010: --and epe.business_group_id = pil.business_group_id
1011: --and pel.business_group_id = epe.business_group_id

Line 1034: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

1030: and pen.effective_end_date = hr_api.g_eot));
1031: --
1032: cursor c_pgm_enrt_dt(v_elig_per_elctbl_chc_id number,v_pgm_id number) is
1033: select pel.enrt_perd_strt_dt
1034: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe
1035: where pel.pgm_id = v_pgm_id
1036: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1037: and epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
1038:

Line 1043: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

1039: l_pgm_enrt_dt c_pgm_enrt_dt%rowtype;
1040:
1041: cursor c_pl_enrt_dt(v_elig_per_elctbl_chc_id number,v_pl_id number) is
1042: select pel.enrt_perd_strt_dt
1043: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe
1044: where pel.pl_id = v_pl_id
1045: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1046: and epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
1047: