DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 678: ben_pil_elctbl_chc_popl pel

674: pil.person_id,
675: pil.ler_id
676: from ben_elig_per_elctbl_chc epe,
677: ben_per_in_ler pil,
678: ben_pil_elctbl_chc_popl pel
679: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
680: and epe.per_in_ler_id = pil.per_in_ler_id
681: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
682: and epe.per_in_ler_id = pel.per_in_ler_id;

Line 1064: ben_pil_elctbl_chc_popl pel,

1060: cursor c_pln_auto_distr (p_elig_per_elctbl_chc_id number)
1061: is
1062: select auto_distr_flag
1063: from ben_enrt_perd enp,
1064: ben_pil_elctbl_chc_popl pel,
1065: ben_elig_per_elctbl_chc epe
1066: where enp.enrt_perd_id = pel.enrt_perd_id
1067: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1068: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;