APPS.BEN_CTP_BUS dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 4471: -- contain no records for that program: BEN_LER_CHG_DPNT_CVG_F,

4467: -- ----------------------------------------------------------------------------
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.

Line 4506: from ben_ler_chg_dpnt_cvg_f ldc

4502: l_api_updating boolean;
4503: l_dummy varchar2(1);
4504: --
4505: cursor c1 is select 'x'
4506: from ben_ler_chg_dpnt_cvg_f ldc
4507: where ldc.ptip_id = p_ptip_id
4508: and ldc.business_group_id + 0 = p_business_group_id
4509: and p_effective_date between ldc.effective_start_date
4510: and ldc.effective_end_date;

Line 4933: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',

4929: l_table_name := 'ben_wv_prtn_rsn_ptip_f';
4930: Raise l_rows_exist;
4931: End If;
4932: If (dt_api.rows_exist
4933: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
4934: p_base_key_column => 'ptip_id',
4935: p_base_key_value => p_ptip_id,
4936: p_from_date => p_validation_start_date,
4937: p_to_date => p_validation_end_date)) Then

Line 4938: l_table_name := 'ben_ler_chg_dpnt_cvg_f';

4934: p_base_key_column => 'ptip_id',
4935: p_base_key_value => p_ptip_id,
4936: p_from_date => p_validation_start_date,
4937: p_to_date => p_validation_end_date)) Then
4938: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
4939: Raise l_rows_exist;
4940: End If;
4941: If (dt_api.rows_exist
4942: (p_base_table_name => 'ben_acty_base_rt_f',