DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 9758: FROM ben_cbr_per_in_ler crp, ben_pil_elctbl_chc_popl pel

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

Line 10166: FROM ben_pil_elctbl_chc_popl pel

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