APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_BNF_F

Line 7367: ben_pl_bnf_f pb

7363: (months_between(p_effective_date, per.date_of_birth))/ 12
7364: ) bnf_age,
7365: pb.ttee_person_id
7366: from per_all_people_f per,
7367: ben_pl_bnf_f pb
7368: where pb.pl_bnf_id = p_pl_bnf_id
7369: and per.person_id = pb.bnf_person_id
7370: and per.business_group_id = p_business_group_id
7371: and p_effective_date between per.effective_start_date

Line 7672: from ben_pl_bnf_f pbd,

7668: --
7669: cursor c_dsgn_bnf is
7670: select pbd.pl_bnf_id,
7671: pbd.bnf_person_id
7672: from ben_pl_bnf_f pbd,
7673: ben_per_in_ler pil
7674: where pbd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7675: and pbd.dsgn_strt_dt is not null
7676: and nvl(pbd.dsgn_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 8491: from ben_pl_bnf_f,

8487: -- or if designation 'O' optional, do not suspend.
8488: --
8489: cursor c_find_bnf is
8490: select pl_bnf_id
8491: from ben_pl_bnf_f,
8492: ben_per_in_ler pil
8493: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8494: and p_effective_date between
8495: effective_start_date and effective_end_date

Line 8496: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id

8492: ben_per_in_ler pil
8493: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8494: and p_effective_date between
8495: effective_start_date and effective_end_date
8496: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8497: and pil.business_group_id=p_business_group_id
8498: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
8499: --
8500: l_find_bnf c_find_bnf%rowtype;

Line 8779: from ben_pl_bnf_f ,

8775:
8776: cursor c_sum_bnf_pct is
8777: select prmry_cntngnt_cd cntgcd,
8778: sum(pct_dsgd_num) prcnt
8779: from ben_pl_bnf_f ,
8780: ben_per_in_ler pil
8781: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8782: and ben_pl_bnf_f.business_group_id = p_business_group_id
8783: and p_effective_date between

Line 8782: and ben_pl_bnf_f.business_group_id = p_business_group_id

8778: sum(pct_dsgd_num) prcnt
8779: from ben_pl_bnf_f ,
8780: ben_per_in_ler pil
8781: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8782: and ben_pl_bnf_f.business_group_id = p_business_group_id
8783: and p_effective_date between
8784: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date
8785: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8786: and pil.business_group_id=p_business_group_id

Line 8784: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date

8780: ben_per_in_ler pil
8781: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8782: and ben_pl_bnf_f.business_group_id = p_business_group_id
8783: and p_effective_date between
8784: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date
8785: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8786: and pil.business_group_id=p_business_group_id
8787: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
8788: group by prmry_cntngnt_cd;

Line 8785: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id

8781: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8782: and ben_pl_bnf_f.business_group_id = p_business_group_id
8783: and p_effective_date between
8784: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date
8785: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8786: and pil.business_group_id=p_business_group_id
8787: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
8788: group by prmry_cntngnt_cd;
8789: --

Line 8830: ben_pl_bnf_f plb,

8826: pl.pl_id
8827: from per_all_people_f per,
8828: per_contact_relationships pcr,
8829: ben_pl_f pl,
8830: ben_pl_bnf_f plb,
8831: ben_prtt_enrt_rslt_f pen,
8832: ben_per_in_ler pil
8833: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8834: and pen.pl_id = pl.pl_id

Line 8869: ben_pl_bnf_f plb,

8865: pl.pl_id
8866: from per_all_people_f per,
8867: hr_all_organization_units o,
8868: ben_pl_f pl,
8869: ben_pl_bnf_f plb,
8870: ben_prtt_enrt_rslt_f pen,
8871: ben_per_in_ler pil
8872: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8873: and pen.pl_id = pl.pl_id