APPS.BEN_EPM_BUS dependencies on BEN_PGM_F

Line 121: from ben_pgm_f pgm

117: l_exists varchar2(1);
118: --
119: cursor c1 is
120: select null
121: from ben_pgm_f pgm
122: where pgm.pgm_id = p_pgm_id
123: and pgm.business_group_id = p_business_group_id
124: and p_effective_date
125: between pgm.effective_start_date and pgm.effective_end_date;

Line 480: (p_base_table_name => 'ben_pgm_f',

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

Line 485: l_table_name := 'ben_pgm_f';

481: p_base_key_column => 'pgm_id',
482: p_base_key_value => p_pgm_id,
483: p_from_date => p_validation_start_date,
484: p_to_date => p_validation_end_date))) Then
485: l_table_name := 'ben_pgm_f';
486: Raise l_integrity_error;
487: End If;
488: --
489: End If;