DBA Data[Home] [Help]

APPS.BEN_PLN_BUS dependencies on BEN_PL_BNF_CTFN_F

Line 1357: from ben_pl_bnf_ctfn_f pcx

1353: and p_validation_end_date >= pnd.effective_start_date ; /* end bug 3981774 */
1354:
1355: --
1356: cursor c4 is select 'x'
1357: from ben_pl_bnf_ctfn_f pcx
1358: where pcx.pl_id = p_pl_id
1359: and pcx.business_group_id + 0 = p_business_group_id
1360: /*and p_effective_date between pcx.effective_start_date
1361: and pcx.effective_end_date;*/

Line 5294: (p_base_table_name => 'ben_pl_bnf_ctfn_f',

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',
5295: p_base_key_column => 'pl_id',
5296: p_base_key_value => p_pl_id,
5297: p_from_date => p_validation_start_date,
5298: p_to_date => p_validation_end_date)) Then

Line 5299: l_table_name := 'ben_pl_bnf_ctfn_f';

5295: p_base_key_column => 'pl_id',
5296: p_base_key_value => p_pl_id,
5297: p_from_date => p_validation_start_date,
5298: p_to_date => p_validation_end_date)) Then
5299: l_table_name := 'ben_pl_bnf_ctfn_f';
5300: Raise l_rows_exist;
5301: End If;
5302: If (dt_api.rows_exist
5303: (p_base_table_name => 'ben_popl_rptg_grp_f',