APPS.BEN_RGR_BUS dependencies on BEN_PL_F

Line 300: from ben_pl_f pln, ben_pl_typ_f ptp

296: where rptg_grp_id = p_rptg_grp_id;
297: --
298: cursor crs_irec_pln is
299: select null
300: from ben_pl_f pln, ben_pl_typ_f ptp
301: where pln.pl_id = p_pl_id
302: and p_validate_start_date <= pln.effective_end_date
303: and p_validate_end_date >= pln.effective_start_date
304: and pln.pl_typ_id = ptp.pl_typ_id

Line 604: (p_base_table_name => 'ben_pl_f',

600: Raise l_integrity_error;
601: End If;
602: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
603: NOT (dt_api.check_min_max_dates
604: (p_base_table_name => 'ben_pl_f',
605: p_base_key_column => 'pl_id',
606: p_base_key_value => p_pl_id,
607: p_from_date => p_validation_start_date,
608: p_to_date => p_validation_end_date))) Then

Line 609: l_table_name := 'ben_pl_f';

605: p_base_key_column => 'pl_id',
606: p_base_key_value => p_pl_id,
607: p_from_date => p_validation_start_date,
608: p_to_date => p_validation_end_date))) Then
609: l_table_name := 'ben_pl_f';
610: Raise l_integrity_error;
611: End If;
612: --
613: End If;