APPS.BEN_PTP_BUS dependencies on BEN_PL_F

Line 331: from ben_pl_f pln, ben_popl_rptg_grp_f rgr, ben_rptg_grp bnr

327: l_dummy varchar2(1);
328: --
329: cursor c1 is
330: select null
331: from ben_pl_f pln, ben_popl_rptg_grp_f rgr, ben_rptg_grp bnr
332: where pln.pl_typ_id = p_pl_typ_id
333: and ( pln.business_group_id = p_business_group_id or p_business_group_id is null)
334: and p_validation_start_date <= pln.effective_end_date
335: and p_validation_end_date >= pln.effective_Start_date

Line 1072: (p_base_table_name => 'ben_pl_f',

1068: l_table_name := 'ben_ptip_f_1';
1069: Raise l_rows_exist;
1070: End If;
1071: If (dt_api.rows_exist
1072: (p_base_table_name => 'ben_pl_f',
1073: p_base_key_column => 'pl_typ_id',
1074: p_base_key_value => p_pl_typ_id,
1075: p_from_date => p_validation_start_date,
1076: p_to_date => p_validation_end_date)) Then

Line 1077: l_table_name := 'ben_pl_f';

1073: p_base_key_column => 'pl_typ_id',
1074: p_base_key_value => p_pl_typ_id,
1075: p_from_date => p_validation_start_date,
1076: p_to_date => p_validation_end_date)) Then
1077: l_table_name := 'ben_pl_f';
1078: Raise l_rows_exist;
1079: End If;
1080: -- 4395957 check existence of rows in ben_pl_typ_opt_typ_f as well.
1081: If (dt_api.rows_exist