APPS.BEN_PLN_BUS dependencies on BEN_POPL_RPTG_GRP_F

Line 128: from ben_popl_rptg_grp_f rgr, ben_rptg_grp bnr

124: l_new_opt_typ_cd varchar2(30);
125: --
126: cursor c1 is
127: select null
128: from ben_popl_rptg_grp_f rgr, ben_rptg_grp bnr
129: where rgr.pl_id = p_pl_id
130: and ( rgr.business_group_id = p_business_group_id or p_business_group_id is null)
131: and p_validation_start_date <= rgr.effective_end_date
132: and p_validation_end_date >= rgr.effective_Start_date

Line 5303: (p_base_table_name => 'ben_popl_rptg_grp_f',

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',
5304: p_base_key_column => 'pl_id',
5305: p_base_key_value => p_pl_id,
5306: p_from_date => p_validation_start_date,
5307: p_to_date => p_validation_end_date)) Then

Line 5308: l_table_name := 'ben_popl_rptg_grp_f';

5304: p_base_key_column => 'pl_id',
5305: p_base_key_value => p_pl_id,
5306: p_from_date => p_validation_start_date,
5307: p_to_date => p_validation_end_date)) Then
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',