APPS.BEN_ABR_BUS dependencies on BEN_OIPL_F

Line 172: from ben_oipl_f

168: l_proc varchar2(72) := g_package||'chk_elem_unique';
169: --
170: cursor c_oipl is
171: select opt_id, pl_id
172: from ben_oipl_f
173: where oipl_id = p_rec.oipl_id
174: and p_effective_date between effective_start_date and effective_end_date;
175: --
176: l_oipl c_oipl%rowtype;

Line 389: from ben_oipl_f

385: where plip_id = p_plip_id;
386: --
387: cursor c_oipl is
388: select pl_id
389: from ben_oipl_f
390: where oipl_id = p_oipl_id;
391: --
392: cursor c_oiplip is
393: select oipl.pl_id

Line 395: ben_oipl_f oipl

391: --
392: cursor c_oiplip is
393: select oipl.pl_id
394: from ben_oiplip_f oiplip,
395: ben_oipl_f oipl
396: where oiplip.oiplip_id = p_oiplip_id
397: and oipl.oipl_id = oiplip.oipl_id;
398: --
399: l_pl_id number := nvl(p_pl_id,-1);

Line 774: from ben_oipl_f

770: --
771: --ICM Changes
772: cursor c_oipl is
773: select opt_id, pl_id
774: from ben_oipl_f
775: where oipl_id = p_rec.oipl_id
776: and p_effective_date between effective_start_date and effective_end_date;
777: --
778: l_oipl c_oipl%rowtype;

Line 943: ben_oipl_f oipl

939:
940: cursor c_oipl is
941: select 'x'
942: from ben_pl_f pln,
943: ben_oipl_f oipl
944: where oipl.oipl_id = p_oipl_id
945: and pln.pl_id = oipl.pl_id
946: and pln.subj_to_imptd_incm_typ_cd is not null
947: and p_effective_date between pln.effective_start_date

Line 970: ben_oipl_f oipl,

966:
967: cursor c_oiplip is
968: select 'x'
969: from ben_pl_f pln,
970: ben_oipl_f oipl,
971: ben_oiplip_f oiplip
972: where oiplip.oiplip_id = p_oiplip_id
973: and oipl.oipl_id = oiplip.oipl_id
974: and pln.pl_id = oipl.pl_id

Line 2547: from ben_oipl_f

2543: l_dummy char(1);
2544: --
2545: cursor get_plan_id is
2546: select pl_id
2547: from ben_oipl_f
2548: where oipl_id = p_oipl_id
2549: and business_group_id = p_business_group_id
2550: and p_effective_start_date between effective_start_date and effective_end_date;
2551: --

Line 4546: (p_base_table_name => 'ben_oipl_f',

4542: Raise l_integrity_error;
4543: End If;
4544: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
4545: NOT (dt_api.check_min_max_dates
4546: (p_base_table_name => 'ben_oipl_f',
4547: p_base_key_column => 'oipl_id',
4548: p_base_key_value => p_oipl_id,
4549: p_from_date => p_validation_start_date,
4550: p_to_date => p_validation_end_date))) Then

Line 4551: l_table_name := 'ben_oipl_f';

4547: p_base_key_column => 'oipl_id',
4548: p_base_key_value => p_oipl_id,
4549: p_from_date => p_validation_start_date,
4550: p_to_date => p_validation_end_date))) Then
4551: l_table_name := 'ben_oipl_f';
4552: Raise l_integrity_error;
4553: End If;
4554: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
4555: NOT (dt_api.check_min_max_dates