APPS.BEN_PGM_BUS dependencies on BEN_LER_CHG_DPNT_CVG_F

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

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

Line 5242: from ben_ler_chg_dpnt_cvg_f ldc

5238: l_api_updating boolean;
5239: l_dummy varchar2(1);
5240: --
5241: cursor c1 is select 'x'
5242: from ben_ler_chg_dpnt_cvg_f ldc
5243: where ldc.pgm_id = p_pgm_id
5244: and ldc.business_group_id + 0 = p_business_group_id
5245: and p_effective_date between ldc.effective_start_date
5246: and ldc.effective_end_date;

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

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

Line 5380: from ben_ler_chg_dpnt_cvg_f ldc

5376: l_api_updating boolean;
5377: l_dummy varchar2(1);
5378: --
5379: cursor c1 is select null
5380: from ben_ler_chg_dpnt_cvg_f ldc
5381: where ldc.pgm_id = p_pgm_id
5382: and ldc.business_group_id + 0 = p_business_group_id
5383: and p_effective_date between ldc.effective_start_date
5384: and ldc.effective_end_date;

Line 5568: -- contain no records for that plan type: BEN_LER_CHG_DPNT_CVG_F,

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

Line 5604: BEN_LER_CHG_DPNT_CVG_F ldc

5600: l_dummy varchar2(30);
5601: --
5602: cursor c1 is select null
5603: from BEN_PTIP_F ctp,
5604: BEN_LER_CHG_DPNT_CVG_F ldc
5605: where ctp.pgm_id = p_pgm_id
5606: and ctp.business_group_id +0 = p_business_group_id
5607: and p_effective_date between ctp.effective_start_date
5608: and ctp.effective_end_date

Line 6071: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',

6067: l_table_name := 'ben_elig_to_prte_rsn_f';
6068: Raise l_rows_exist;
6069: End If;
6070: If (dt_api.rows_exist
6071: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
6072: p_base_key_column => 'pgm_id',
6073: p_base_key_value => p_pgm_id,
6074: p_from_date => p_validation_start_date,
6075: p_to_date => p_validation_end_date)) Then

Line 6076: l_table_name := 'ben_ler_chg_dpnt_cvg_f';

6072: p_base_key_column => 'pgm_id',
6073: p_base_key_value => p_pgm_id,
6074: p_from_date => p_validation_start_date,
6075: p_to_date => p_validation_end_date)) Then
6076: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
6077: Raise l_rows_exist;
6078: End If;
6079: If (dt_api.rows_exist
6080: (p_base_table_name => 'ben_popl_org_f',