APPS.BEN_PEN_BUS dependencies on BEN_PL_F

Line 907: ben_pl_f bpl

903: ben_crt_ordr_cvrd_per cvr,
904: per_all_people_f per,
905: per_contact_relationships con,
906: hr_lookups lkp,
907: ben_pl_f bpl
908: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
909: AND crt.person_id = p_person_id
910: AND crt.pl_id = p_pl_id
911: AND crt.crt_ordr_id = cvr.crt_ordr_id

Line 1625: ben_pl_f pln

1621: from ben_prtt_enrt_rslt_f pen,
1622: ben_elig_per_elctbl_chc epe,
1623: ben_plip_f cpp,
1624: ben_oipl_f cop,
1625: ben_pl_f pln
1626: where pen.person_id = c_person_id
1627: and pen.prtt_enrt_rslt_stat_cd is null
1628: and pen.pgm_id <> c_pgm_id
1629: and pen.effective_end_date = hr_api.g_eot

Line 1662: l_prev_pl_id ben_pl_f.pl_id%type := -99999;

1658: --
1659: l_prev_pgm_id ben_pgm_f.pgm_id%type := -99999;
1660: l_prev_ptip_id ben_ptip_f.ptip_id%type := -99999;
1661: l_prev_pl_typ_id ben_pl_typ_f.pl_typ_id%type := -99999;
1662: l_prev_pl_id ben_pl_f.pl_id%type := -99999;
1663: l_pl_typ_rec g_c_pl_typ%rowtype;
1664: l_interim_tbl interim_table;
1665: l_interim_cnt binary_integer := 0;
1666: i binary_integer;

Line 2251: l_pl_rec ben_pl_f%rowtype;

2247: is
2248: --
2249: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2250: /*
2251: l_pl_rec ben_pl_f%rowtype;
2252: */
2253: --
2254: begin
2255: --

Line 2762: ,ben_pl_f c

2758: --
2759: Cursor c1 is
2760: select distinct b.per_in_ler_id, b.ler_id, b.pl_id
2761: From ben_prtt_enrt_rslt_f b
2762: ,ben_pl_f c
2763: Where b.person_id = p_person_id
2764: And nvl(b.pgm_id,-1) = nvl(p_pgm_id,-1)
2765: And p_effective_date between
2766: b.effective_start_date and b.effective_end_date

Line 2894: from ben_pl_f pln

2890: order by assignment_type desc, effective_start_date desc ; -- bug 4124110
2891: --
2892: cursor c_pl_name(cv_pl_id number) is
2893: select pln.name
2894: from ben_pl_f pln
2895: where pln.pl_id = cv_pl_id
2896: and pln.business_group_id = p_business_group_id;
2897: --
2898:

Line 2944: l_plan_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683

2940: --
2941: -- Bug 2162121
2942: --
2943: l_ptip_tbl_ct number := g_ptip_tbl.count;
2944: l_plan_name ben_pl_f.name%type; -- UTF8 Change Bug 2254683
2945: l_option_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683
2946: --
2947: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2948: /*

Line 2949: l_pl_rec ben_pl_f%rowtype;

2945: l_option_name ben_opt_f.name%type; -- UTF8 Change Bug 2254683
2946: --
2947: l_pl_rec ben_cobj_cache.g_pl_inst_row;
2948: /*
2949: l_pl_rec ben_pl_f%rowtype;
2950: */
2951: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2952: /*
2953: l_oipl_rec ben_oipl_f%rowtype;

Line 3743: (p_base_table_name => 'ben_pl_f',

3739: Raise l_integrity_error;
3740: End If;
3741: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
3742: NOT (dt_api.check_min_max_dates
3743: (p_base_table_name => 'ben_pl_f',
3744: p_base_key_column => 'pl_id',
3745: p_base_key_value => p_pl_id,
3746: p_from_date => p_validation_start_date,
3747: p_to_date => p_validation_end_date))) Then

Line 3748: l_table_name := 'ben_pl_f';

3744: p_base_key_column => 'pl_id',
3745: p_base_key_value => p_pl_id,
3746: p_from_date => p_validation_start_date,
3747: p_to_date => p_validation_end_date))) Then
3748: l_table_name := 'ben_pl_f';
3749: Raise l_integrity_error;
3750: End If;
3751: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
3752: NOT (dt_api.check_min_max_dates