APPS.BEN_DDR_BUS dependencies on BEN_OPT_F

Line 603: l_opt_id ben_opt_f.opt_id%TYPE;

599: l_api_updating boolean;
600: l_dummy varchar2(1);
601: l_pl_id ben_pl_f.pl_id%TYPE;
602: l_oipl_id ben_oipl_f.oipl_id%TYPE;
603: l_opt_id ben_opt_f.opt_id%TYPE;
604:
605: --
606: cursor c1 is
607: select a.pl_id, a.oipl_id, a.opt_id

Line 831: (p_base_table_name => 'ben_opt_f',

827: Raise l_integrity_error;
828: End If;
829: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
830: NOT (dt_api.check_min_max_dates
831: (p_base_table_name => 'ben_opt_f',
832: p_base_key_column => 'opt_id',
833: p_base_key_value => p_opt_id,
834: p_from_date => p_validation_start_date,
835: p_to_date => p_validation_end_date))) Then

Line 836: l_table_name := 'ben_opt_f';

832: p_base_key_column => 'opt_id',
833: p_base_key_value => p_opt_id,
834: p_from_date => p_validation_start_date,
835: p_to_date => p_validation_end_date))) Then
836: l_table_name := 'ben_opt_f';
837: Raise l_integrity_error;
838: End If;
839: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
840: NOT (dt_api.check_min_max_dates