DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 695: ben_pil_elctbl_chc_popl pel

691: pil.person_id,
692: pil.ler_id
693: from ben_elig_per_elctbl_chc epe,
694: ben_per_in_ler pil,
695: ben_pil_elctbl_chc_popl pel
696: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
697: and epe.per_in_ler_id = pil.per_in_ler_id
698: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
699: and epe.per_in_ler_id = pel.per_in_ler_id;

Line 1081: ben_pil_elctbl_chc_popl pel,

1077: cursor c_pln_auto_distr (p_elig_per_elctbl_chc_id number)
1078: is
1079: select auto_distr_flag
1080: from ben_enrt_perd enp,
1081: ben_pil_elctbl_chc_popl pel,
1082: ben_elig_per_elctbl_chc epe
1083: where enp.enrt_perd_id = pel.enrt_perd_id
1084: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1085: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;