APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_PL_BNF_F

Line 7282: ben_pl_bnf_f pb

7278: (months_between(p_effective_date, per.date_of_birth))/ 12
7279: ) bnf_age,
7280: pb.ttee_person_id
7281: from per_all_people_f per,
7282: ben_pl_bnf_f pb
7283: where pb.pl_bnf_id = p_pl_bnf_id
7284: and per.person_id = pb.bnf_person_id
7285: and per.business_group_id = p_business_group_id
7286: and p_effective_date between per.effective_start_date

Line 7587: from ben_pl_bnf_f pbd,

7583: --
7584: cursor c_dsgn_bnf is
7585: select pbd.pl_bnf_id,
7586: pbd.bnf_person_id
7587: from ben_pl_bnf_f pbd,
7588: ben_per_in_ler pil
7589: where pbd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7590: and pbd.dsgn_strt_dt is not null
7591: and nvl(pbd.dsgn_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 8406: from ben_pl_bnf_f,

8402: -- or if designation 'O' optional, do not suspend.
8403: --
8404: cursor c_find_bnf is
8405: select pl_bnf_id
8406: from ben_pl_bnf_f,
8407: ben_per_in_ler pil
8408: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8409: and p_effective_date between
8410: effective_start_date and effective_end_date

Line 8411: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id

8407: ben_per_in_ler pil
8408: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8409: and p_effective_date between
8410: effective_start_date and effective_end_date
8411: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8412: and pil.business_group_id=p_business_group_id
8413: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
8414: --
8415: l_find_bnf c_find_bnf%rowtype;

Line 8694: from ben_pl_bnf_f ,

8690:
8691: cursor c_sum_bnf_pct is
8692: select prmry_cntngnt_cd cntgcd,
8693: sum(pct_dsgd_num) prcnt
8694: from ben_pl_bnf_f ,
8695: ben_per_in_ler pil
8696: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8697: and ben_pl_bnf_f.business_group_id = p_business_group_id
8698: and p_effective_date between

Line 8697: and ben_pl_bnf_f.business_group_id = p_business_group_id

8693: sum(pct_dsgd_num) prcnt
8694: from ben_pl_bnf_f ,
8695: ben_per_in_ler pil
8696: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8697: and ben_pl_bnf_f.business_group_id = p_business_group_id
8698: and p_effective_date between
8699: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date
8700: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8701: and pil.business_group_id=p_business_group_id

Line 8699: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date

8695: ben_per_in_ler pil
8696: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8697: and ben_pl_bnf_f.business_group_id = p_business_group_id
8698: and p_effective_date between
8699: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date
8700: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8701: and pil.business_group_id=p_business_group_id
8702: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
8703: group by prmry_cntngnt_cd;

Line 8700: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id

8696: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8697: and ben_pl_bnf_f.business_group_id = p_business_group_id
8698: and p_effective_date between
8699: ben_pl_bnf_f.effective_start_date and ben_pl_bnf_f.effective_end_date
8700: and pil.per_in_ler_id=ben_pl_bnf_f.per_in_ler_id
8701: and pil.business_group_id=p_business_group_id
8702: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
8703: group by prmry_cntngnt_cd;
8704: --

Line 8745: ben_pl_bnf_f plb,

8741: pl.pl_id
8742: from per_all_people_f per,
8743: per_contact_relationships pcr,
8744: ben_pl_f pl,
8745: ben_pl_bnf_f plb,
8746: ben_prtt_enrt_rslt_f pen,
8747: ben_per_in_ler pil
8748: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8749: and pen.pl_id = pl.pl_id

Line 8784: ben_pl_bnf_f plb,

8780: pl.pl_id
8781: from per_all_people_f per,
8782: hr_all_organization_units o,
8783: ben_pl_f pl,
8784: ben_pl_bnf_f plb,
8785: ben_prtt_enrt_rslt_f pen,
8786: ben_per_in_ler pil
8787: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8788: and pen.pl_id = pl.pl_id