APPS.BEN_CTP_BUS dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 4520: from ben_ptip_dpnt_cvg_ctfn_f pgc

4516: and p_effective_date between ade.effective_start_date
4517: and ade.effective_end_date;
4518: --
4519: cursor c3 is select 'x'
4520: from ben_ptip_dpnt_cvg_ctfn_f pgc
4521: where pgc.ptip_id = p_ptip_id
4522: and pgc.business_group_id + 0 = p_business_group_id
4523: and p_effective_date between pgc.effective_start_date
4524: and pgc.effective_end_date;

Line 4960: (p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',

4956: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';
4957: Raise l_rows_exist;
4958: End If;
4959: If (dt_api.rows_exist
4960: (p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',
4961: p_base_key_column => 'ptip_id',
4962: p_base_key_value => p_ptip_id,
4963: p_from_date => p_validation_start_date,
4964: p_to_date => p_validation_end_date)) Then

Line 4965: l_table_name := 'ben_ptip_dpnt_cvg_ctfn_f';

4961: p_base_key_column => 'ptip_id',
4962: p_base_key_value => p_ptip_id,
4963: p_from_date => p_validation_start_date,
4964: p_to_date => p_validation_end_date)) Then
4965: l_table_name := 'ben_ptip_dpnt_cvg_ctfn_f';
4966: Raise l_rows_exist;
4967: End If;
4968: --
4969: End If;