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 1005: ben_pil_elctbl_chc_popl pel

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

Line 1032: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

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

Line 1041: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

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