APPS.BEN_PEN_BUS dependencies on BEN_PL_TYP_F

Line 888: l_benefit_name ben_pl_typ_f.NAME%TYPE;

884: --
885: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
886: l_pl_rec ben_cobj_cache.g_pl_inst_row;
887: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
888: l_benefit_name ben_pl_typ_f.NAME%TYPE;
889: --
890: l_lf_evt_ocrd_dt DATE;
891: --
892: CURSOR c_lf_evt_ocrd_dt

Line 953: ben_pl_typ_f bpt

949: ben_crt_ordr_cvrd_per cvr,
950: per_all_people_f per,
951: per_contact_relationships con,
952: hr_lookups lkp,
953: ben_pl_typ_f bpt
954: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
955: AND crt.person_id = p_person_id
956: AND crt.pl_typ_id = l_pl_rec.pl_typ_id
957: AND crt.crt_ordr_id = cvr.crt_ordr_id

Line 1661: l_prev_pl_typ_id ben_pl_typ_f.pl_typ_id%type := -99999;

1657: -- Local Variable declaration
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;

Line 2932: l_prev_ptip_name ben_pl_typ_f.name%type; -- UTF8 Change Bug 2254683

2928: l_status boolean;
2929: l_step integer;
2930: l_proc varchar2(72) := g_package||'multi_rows_edit';
2931: l_prev_oipl_id number := -999999;
2932: l_prev_ptip_name ben_pl_typ_f.name%type; -- UTF8 Change Bug 2254683
2933: l_prev_pl_id number := -999999;
2934: l_prev_cvg_strt_dt date;
2935: l_prev_cvg_end_dt date;
2936: l_assignment_id per_assignments_f.assignment_id%type;

Line 3753: (p_base_table_name => 'ben_pl_typ_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
3753: (p_base_table_name => 'ben_pl_typ_f',
3754: p_base_key_column => 'pl_typ_id',
3755: p_base_key_value => p_pl_typ_id,
3756: p_from_date => p_validation_start_date,
3757: p_to_date => p_validation_end_date))) Then

Line 3758: l_table_name := 'ben_pl_typ_f';

3754: p_base_key_column => 'pl_typ_id',
3755: p_base_key_value => p_pl_typ_id,
3756: p_from_date => p_validation_start_date,
3757: p_to_date => p_validation_end_date))) Then
3758: l_table_name := 'ben_pl_typ_f';
3759: Raise l_integrity_error;
3760: End If;
3761: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
3762: NOT (dt_api.check_min_max_dates