APPS.BEN_ABR_BUS dependencies on BEN_OIPLIP_F

Line 394: from ben_oiplip_f oiplip,

390: where oipl_id = p_oipl_id;
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: --

Line 686: ben_oiplip_f where oiplip_id = p_oiplip_id and

682: ben_plip_f where plip_id = p_plip_id and
683: p_effective_date between effective_start_date and effective_end_date ;
684:
685: cursor c_oiplip is select oipl_id from
686: ben_oiplip_f where oiplip_id = p_oiplip_id and
687: p_effective_date between effective_start_date and effective_end_date ;
688:
689: begin
690: hr_utility.set_location('Entering:'||l_proc, 5);

Line 971: ben_oiplip_f oiplip

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
975: and pln.subj_to_imptd_incm_typ_cd is not null

Line 4566: (p_base_table_name => 'ben_oiplip_f',

4562: Raise l_integrity_error;
4563: End If;
4564: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and
4565: NOT (dt_api.check_min_max_dates
4566: (p_base_table_name => 'ben_oiplip_f',
4567: p_base_key_column => 'oiplip_id',
4568: p_base_key_value => p_oiplip_id,
4569: p_from_date => p_validation_start_date,
4570: p_to_date => p_validation_end_date))) Then

Line 4571: l_table_name := 'ben_oiplip_f';

4567: p_base_key_column => 'oiplip_id',
4568: p_base_key_value => p_oiplip_id,
4569: p_from_date => p_validation_start_date,
4570: p_to_date => p_validation_end_date))) Then
4571: l_table_name := 'ben_oiplip_f';
4572: Raise l_integrity_error;
4573: End If;
4574: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
4575: NOT (dt_api.check_min_max_dates