APPS.BEN_PLN_BUS dependencies on BEN_PL_DPNT_CVG_CTFN_F

Line 1289: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PL_DPNT_CVG_CTFN_F.

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

Line 1347: from ben_pl_dpnt_cvg_ctfn_f pnd

1343: and p_validation_end_date >= ade1.effective_start_date ; /* end bug 3981774 */
1344:
1345: --
1346: cursor c3 is select 'x'
1347: from ben_pl_dpnt_cvg_ctfn_f pnd
1348: where pnd.pl_id = p_pl_id
1349: and pnd.business_group_id + 0 = p_business_group_id
1350: /* and p_effective_date between pnd.effective_start_date
1351: and pnd.effective_end_date;*/

Line 5285: (p_base_table_name => 'ben_pl_dpnt_cvg_ctfn_f',

5281: l_table_name := 'ben_acty_base_rt_f';
5282: Raise l_rows_exist;
5283: End If;
5284: If (dt_api.rows_exist
5285: (p_base_table_name => 'ben_pl_dpnt_cvg_ctfn_f',
5286: p_base_key_column => 'pl_id',
5287: p_base_key_value => p_pl_id,
5288: p_from_date => p_validation_start_date,
5289: p_to_date => p_validation_end_date)) Then

Line 5290: l_table_name := 'ben_pl_dpnt_cvg_ctfn_f';

5286: p_base_key_column => 'pl_id',
5287: p_base_key_value => p_pl_id,
5288: p_from_date => p_validation_start_date,
5289: p_to_date => p_validation_end_date)) Then
5290: l_table_name := 'ben_pl_dpnt_cvg_ctfn_f';
5291: Raise l_rows_exist;
5292: End If;
5293: If (dt_api.rows_exist
5294: (p_base_table_name => 'ben_pl_bnf_ctfn_f',