APPS.BEN_PEP_BUS dependencies on BEN_PGM_F

Line 309: l_pgm_id ben_pgm_f.pgm_id%type;

305: and p_effective_date
306: between plip.effective_start_date
307: and plip.effective_end_date;
308: --
309: l_pgm_id ben_pgm_f.pgm_id%type;
310: --
311: begin
312: --
313: hr_utility.set_location('Entering :'||l_proc,5);

Line 2409: (p_base_table_name => 'ben_pgm_f',

2405: Raise l_integrity_error;
2406: End If;
2407: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
2408: NOT (dt_api.check_min_max_dates
2409: (p_base_table_name => 'ben_pgm_f',
2410: p_base_key_column => 'pgm_id',
2411: p_base_key_value => p_pgm_id,
2412: p_from_date => p_validation_start_date,
2413: p_to_date => p_validation_end_date))) Then

Line 2414: l_table_name := 'ben_pgm_f';

2410: p_base_key_column => 'pgm_id',
2411: p_base_key_value => p_pgm_id,
2412: p_from_date => p_validation_start_date,
2413: p_to_date => p_validation_end_date))) Then
2414: l_table_name := 'ben_pgm_f';
2415: Raise l_integrity_error;
2416: End If;
2417: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2418: NOT (dt_api.check_min_max_dates