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 1624: ben_pl_f pln

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

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

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

Line 2250: l_pl_rec ben_pl_f%rowtype;

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

Line 2761: ,ben_pl_f c

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

Line 2893: from ben_pl_f pln

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

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

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

Line 2948: l_pl_rec ben_pl_f%rowtype;

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

Line 3742: (p_base_table_name => 'ben_pl_f',

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

Line 3747: l_table_name := 'ben_pl_f';

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