DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 9759: FROM ben_cbr_per_in_ler crp, ben_pil_elctbl_chc_popl pel

9755: --
9756: CURSOR c_get_elcns_made_dt IS
9757: SELECT pel.elcns_made_dt
9758: ,crp.per_in_ler_id
9759: FROM ben_cbr_per_in_ler crp, ben_pil_elctbl_chc_popl pel
9760: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
9761: AND crp.init_evt_flag = 'Y'
9762: AND crp.business_group_id = p_business_group_id
9763: AND crp.per_in_ler_id = pel.per_in_ler_id

Line 10167: FROM ben_pil_elctbl_chc_popl pel

10163: --
10164: CURSOR c_get_enrt_perd_dates(
10165: p_pgm_id IN NUMBER) IS
10166: SELECT pel.*
10167: FROM ben_pil_elctbl_chc_popl pel
10168: ,ben_per_in_ler pil
10169: WHERE pel.pgm_id = p_pgm_id
10170: AND pel.per_in_ler_id = pil.per_in_ler_id
10171: and pil.person_id = p_person_id