APPS.BEN_OPR_BUS dependencies on BEN_PTIP_F

Line 121: from ben_ptip_f ctp

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

Line 482: (p_base_table_name => 'ben_ptip_f',

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

Line 487: l_table_name := 'ben_ptip_f';

483: p_base_key_column => 'ptip_id',
484: p_base_key_value => p_ptip_id,
485: p_from_date => p_validation_start_date,
486: p_to_date => p_validation_end_date))) Then
487: l_table_name := 'ben_ptip_f';
488: Raise l_integrity_error;
489: End If;
490: --
491: End If;