DBA Data[Home] [Help]

APPS.BEN_PEP_BUS dependencies on BEN_PLIP_F

Line 302: from ben_plip_f plip

298: l_dummy varchar2(1);
299: --
300: cursor c1 is
301: select pgm_id
302: from ben_plip_f plip
303: where plip.pl_id = p_pl_id
304: and business_group_id + 0 = p_business_group_id
305: and p_effective_date
306: between plip.effective_start_date

Line 2429: (p_base_table_name => 'ben_plip_f',

2425: Raise l_integrity_error;
2426: End If;
2427: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2428: NOT (dt_api.check_min_max_dates
2429: (p_base_table_name => 'ben_plip_f',
2430: p_base_key_column => 'plip_id',
2431: p_base_key_value => p_plip_id,
2432: p_from_date => p_validation_start_date,
2433: p_to_date => p_validation_end_date))) Then

Line 2434: l_table_name := 'ben_plip_f';

2430: p_base_key_column => 'plip_id',
2431: p_base_key_value => p_plip_id,
2432: p_from_date => p_validation_start_date,
2433: p_to_date => p_validation_end_date))) Then
2434: l_table_name := 'ben_plip_f';
2435: Raise l_integrity_error;
2436: End If;
2437: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
2438: NOT (dt_api.check_min_max_dates