APPS.BEN_DCL_BUS dependencies on BEN_PL_F

Line 122: from ben_pl_f pln

118: l_exists varchar2(1);
119: --
120: cursor c1 is
121: select null
122: from ben_pl_f pln
123: where pln.pl_id = p_pl_id
124: and pln.business_group_id = p_business_group_id
125: and p_effective_date
126: between pln.effective_start_date and pln.effective_end_date;

Line 481: (p_base_table_name => 'ben_pl_f',

477: Raise l_integrity_error;
478: End If;
479: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
480: NOT (dt_api.check_min_max_dates
481: (p_base_table_name => 'ben_pl_f',
482: p_base_key_column => 'pl_id',
483: p_base_key_value => p_pl_id,
484: p_from_date => p_validation_start_date,
485: p_to_date => p_validation_end_date))) Then

Line 486: l_table_name := 'ben_pl_f';

482: p_base_key_column => 'pl_id',
483: p_base_key_value => p_pl_id,
484: p_from_date => p_validation_start_date,
485: p_to_date => p_validation_end_date))) Then
486: l_table_name := 'ben_pl_f';
487: Raise l_integrity_error;
488: End If;
489: --
490: End If;