APPS.BEN_PGM_BUS dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 5208: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PGM_DPNT_CVG_CTFN_F.

5204: --
5205: -- Description
5206: -- If dependent designation level is null then the following tables must
5207: -- contain no records for that program: BEN_LER_CHG_DPNT_CVG_F,
5208: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PGM_DPNT_CVG_CTFN_F.
5209: --
5210: -- Pre Conditions
5211: -- None.
5212: --

Line 5256: from ben_pgm_dpnt_cvg_ctfn_f pgc

5252: and p_effective_date between ade.effective_start_date
5253: and ade.effective_end_date;
5254: --
5255: cursor c3 is select 'x'
5256: from ben_pgm_dpnt_cvg_ctfn_f pgc
5257: where pgc.pgm_id = p_pgm_id
5258: and pgc.business_group_id + 0 = p_business_group_id
5259: and p_effective_date between pgc.effective_start_date
5260: and pgc.effective_end_date;

Line 5346: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PGM_DPNT_CVG_CTFN_F.

5342: --
5343: -- Description
5344: -- If dependent designation level is not 'Program' the following tables must
5345: -- contain no records for that program: BEN_LER_CHG_DPNT_CVG_F,
5346: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PGM_DPNT_CVG_CTFN_F.
5347: --
5348: -- Pre Conditions
5349: -- None.
5350: --

Line 5394: from ben_pgm_dpnt_cvg_ctfn_f pgc

5390: and p_effective_date between ade.effective_start_date
5391: and ade.effective_end_date;
5392: --
5393: cursor c3 is select 'x'
5394: from ben_pgm_dpnt_cvg_ctfn_f pgc
5395: where pgc.pgm_id = p_pgm_id
5396: and pgc.business_group_id + 0 = p_business_group_id
5397: and p_effective_date between pgc.effective_start_date
5398: and pgc.effective_end_date;

Line 6107: (p_base_table_name => 'ben_pgm_dpnt_cvg_ctfn_f',

6103: l_table_name := 'ben_acty_base_rt_f';
6104: Raise l_rows_exist;
6105: End If;
6106: If (dt_api.rows_exist
6107: (p_base_table_name => 'ben_pgm_dpnt_cvg_ctfn_f',
6108: p_base_key_column => 'pgm_id',
6109: p_base_key_value => p_pgm_id,
6110: p_from_date => p_validation_start_date,
6111: p_to_date => p_validation_end_date)) Then

Line 6112: l_table_name := 'ben_pgm_dpnt_cvg_ctfn_f';

6108: p_base_key_column => 'pgm_id',
6109: p_base_key_value => p_pgm_id,
6110: p_from_date => p_validation_start_date,
6111: p_to_date => p_validation_end_date)) Then
6112: l_table_name := 'ben_pgm_dpnt_cvg_ctfn_f';
6113: Raise l_rows_exist;
6114: End If;
6115: If (dt_api.rows_exist
6116: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',