APPS.BEN_CTP_BUS dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 4472: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PGM_DPNT_CVG_CTFN_F.

4468: --
4469: -- Description
4470: -- If dependent designation level is null then the following tables must
4471: -- contain no records for that program: BEN_LER_CHG_DPNT_CVG_F,
4472: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PGM_DPNT_CVG_CTFN_F.
4473: --
4474: -- Pre Conditions
4475: -- None.
4476: --

Line 4513: from ben_apld_dpnt_cvg_elig_prfl_f ade

4509: and p_effective_date between ldc.effective_start_date
4510: and ldc.effective_end_date;
4511: --
4512: cursor c2 is select 'x'
4513: from ben_apld_dpnt_cvg_elig_prfl_f ade
4514: where ade.ptip_id = p_ptip_id
4515: and ade.business_group_id + 0 = p_business_group_id
4516: and p_effective_date between ade.effective_start_date
4517: and ade.effective_end_date;

Line 4951: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

4947: l_table_name := 'ben_acty_base_rt_f';
4948: Raise l_rows_exist;
4949: End If;
4950: If (dt_api.rows_exist
4951: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
4952: p_base_key_column => 'ptip_id',
4953: p_base_key_value => p_ptip_id,
4954: p_from_date => p_validation_start_date,
4955: p_to_date => p_validation_end_date)) Then

Line 4956: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';

4952: p_base_key_column => 'ptip_id',
4953: p_base_key_value => p_ptip_id,
4954: p_from_date => p_validation_start_date,
4955: p_to_date => p_validation_end_date)) Then
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',