APPS.BEN_PLN_BUS dependencies on BEN_LER_CHG_DPNT_CVG_F

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

1284: -- ----------------------------------------------------------------------------
1285: --
1286: -- Description
1287: -- If dependent designation code is null then the following tables must
1288: -- contain no records for that program: BEN_LER_CHG_DPNT_CVG_F,
1289: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PL_DPNT_CVG_CTFN_F.
1290: --
1291: -- Pre Conditions
1292: -- None.

Line 1326: from ben_ler_chg_dpnt_cvg_f ldc1

1322: l_api_updating boolean;
1323: l_dummy varchar2(1);
1324: --
1325: cursor c1 is select 'x'
1326: from ben_ler_chg_dpnt_cvg_f ldc1
1327: where ldc1.pl_id = p_pl_id
1328: and ldc1.business_group_id + 0 = p_business_group_id
1329: /* start of bug 3981774
1330: and p_effective_date between ldc1.effective_start_date

Line 5249: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',

5245: l_table_name := 'ben_cvg_amt_calc_mthd_f';
5246: Raise l_rows_exist;
5247: End If;
5248: If (dt_api.rows_exist
5249: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
5250: p_base_key_column => 'pl_id',
5251: p_base_key_value => p_pl_id,
5252: p_from_date => p_validation_start_date,
5253: p_to_date => p_validation_end_date)) Then

Line 5254: l_table_name := 'ben_ler_chg_dpnt_cvg_f';

5250: p_base_key_column => 'pl_id',
5251: p_base_key_value => p_pl_id,
5252: p_from_date => p_validation_start_date,
5253: p_to_date => p_validation_end_date)) Then
5254: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
5255: Raise l_rows_exist;
5256: End If;
5257: If (dt_api.rows_exist
5258: (p_base_table_name => 'ben_popl_org_f',