DBA Data[Home] [Help]

APPS.BEN_DDR_BUS dependencies on BEN_PL_F

Line 601: l_pl_id ben_pl_f.pl_id%TYPE;

597: --
598: l_proc varchar2(72) := g_package||'chk_pln_oipl_opt_mutexcl';
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: --

Line 841: (p_base_table_name => 'ben_pl_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
841: (p_base_table_name => 'ben_pl_f',
842: p_base_key_column => 'pl_id',
843: p_base_key_value => p_pl_id,
844: p_from_date => p_validation_start_date,
845: p_to_date => p_validation_end_date))) Then

Line 846: l_table_name := 'ben_pl_f';

842: p_base_key_column => 'pl_id',
843: p_base_key_value => p_pl_id,
844: p_from_date => p_validation_start_date,
845: p_to_date => p_validation_end_date))) Then
846: l_table_name := 'ben_pl_f';
847: Raise l_integrity_error;
848: End If;
849: --
850: End If;