APPS.BEN_PGM_BUS dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_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 5249: from ben_apld_dpnt_cvg_elig_prfl_f ade

5245: and p_effective_date between ldc.effective_start_date
5246: and ldc.effective_end_date;
5247: --
5248: cursor c2 is select 'x'
5249: from ben_apld_dpnt_cvg_elig_prfl_f ade
5250: where ade.pgm_id = p_pgm_id
5251: and ade.business_group_id + 0 = p_business_group_id
5252: and p_effective_date between ade.effective_start_date
5253: and ade.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 5387: from ben_apld_dpnt_cvg_elig_prfl_f ade

5383: and p_effective_date between ldc.effective_start_date
5384: and ldc.effective_end_date;
5385: --
5386: cursor c2 is select null
5387: from ben_apld_dpnt_cvg_elig_prfl_f ade
5388: where ade.pgm_id = p_pgm_id
5389: and ade.business_group_id + 0 = p_business_group_id
5390: and p_effective_date between ade.effective_start_date
5391: and ade.effective_end_date;

Line 5569: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PTIP_DPNT_CVG_CTFN_F.

5565: --
5566: -- Description
5567: -- If dependent designation level is not 'Plan Type' the following tables must
5568: -- contain no records for that plan type: BEN_LER_CHG_DPNT_CVG_F,
5569: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PTIP_DPNT_CVG_CTFN_F.
5570: --
5571: -- Pre Conditions
5572: -- None.
5573: --

Line 5616: BEN_APLD_DPNT_CVG_ELIG_PRFL_F ade

5612: and ldc.effective_end_date;
5613: --
5614: cursor c2 is select null
5615: from BEN_PTIP_F ctp,
5616: BEN_APLD_DPNT_CVG_ELIG_PRFL_F ade
5617: where ctp.pgm_id = p_pgm_id
5618: and ctp.business_group_id +0 = p_business_group_id
5619: and p_effective_date between ctp.effective_start_date
5620: and ctp.effective_end_date

Line 6116: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

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',
6117: p_base_key_column => 'pgm_id',
6118: p_base_key_value => p_pgm_id,
6119: p_from_date => p_validation_start_date,
6120: p_to_date => p_validation_end_date)) Then

Line 6121: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';

6117: p_base_key_column => 'pgm_id',
6118: p_base_key_value => p_pgm_id,
6119: p_from_date => p_validation_start_date,
6120: p_to_date => p_validation_end_date)) Then
6121: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';
6122: Raise l_rows_exist;
6123: End If;
6124: If (dt_api.rows_exist
6125: (p_base_table_name => 'ben_popl_rptg_grp_f',