APPS.BEN_PLN_BUS dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_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 1337: from ben_apld_dpnt_cvg_elig_prfl_f ade1

1333: and p_validation_end_date >= ldc1.effective_start_date ; /* end bug 3981774 */
1334:
1335: --bug 3981774 fix similar to c1 is done for c2,c3,c4
1336: cursor c2 is select 'x'
1337: from ben_apld_dpnt_cvg_elig_prfl_f ade1
1338: where ade1.pl_id = p_pl_id
1339: and ade1.business_group_id + 0 = p_business_group_id
1340: /*and p_effective_date between ade1.effective_start_date
1341: and ade1.effective_end_date;*/

Line 5321: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

5317: l_table_name := 'ben_prtt_reimbmt_rqst_f';
5318: Raise l_rows_exist;
5319: End If;
5320: If (dt_api.rows_exist
5321: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
5322: p_base_key_column => 'pl_id',
5323: p_base_key_value => p_pl_id,
5324: p_from_date => p_validation_start_date,
5325: p_to_date => p_validation_end_date)) Then

Line 5326: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';

5322: p_base_key_column => 'pl_id',
5323: p_base_key_value => p_pl_id,
5324: p_from_date => p_validation_start_date,
5325: p_to_date => p_validation_end_date)) Then
5326: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';
5327: Raise l_rows_exist;
5328: End If;
5329: If (dt_api.rows_exist
5330: (p_base_table_name => 'ben_dsgn_rqmt_f',