DBA Data[Home] [Help]

APPS.BEN_PLN_BUS dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 221: from ben_prtt_reimbmt_rqst_f a

217: l_dummy varchar2(1);
218: --
219: cursor c1 is
220: select null
221: from ben_prtt_reimbmt_rqst_f a
222: where a.business_group_id +0 = p_business_group_id
223: and a.pl_id = p_pl_id
224: and a.prtt_reimbmt_rqst_stat_cd <> 'VOIDD';
225: --

Line 5312: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f',

5308: l_table_name := 'ben_popl_rptg_grp_f';
5309: Raise l_rows_exist;
5310: End If;
5311: If (dt_api.rows_exist
5312: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
5313: p_base_key_column => 'pl_id',
5314: p_base_key_value => p_pl_id,
5315: p_from_date => p_validation_start_date,
5316: p_to_date => p_validation_end_date)) Then

Line 5317: l_table_name := 'ben_prtt_reimbmt_rqst_f';

5313: p_base_key_column => 'pl_id',
5314: p_base_key_value => p_pl_id,
5315: p_from_date => p_validation_start_date,
5316: p_to_date => p_validation_end_date)) Then
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',