APPS.BEN_BNR_BUS dependencies on BEN_POPL_RPTG_GRP

Line 244: from ben_popl_rptg_grp_f rgr, ben_pl_f pln, ben_pl_typ_f ptp

240: p_object_version_number in number) is
241: --
242: cursor c1 is
243: select null
244: from ben_popl_rptg_grp_f rgr, ben_pl_f pln, ben_pl_typ_f ptp
245: where rgr.rptg_grp_id = p_rptg_grp_id
246: and rgr.pl_id = pln.pl_id
247: and rgr.effective_start_date <= pln.effective_end_date
248: and rgr.effective_end_date >= pln.effective_start_date

Line 257: from ben_popl_rptg_grp_f rgr

253: and ptp.opt_typ_cd <> 'COMP';
254: --
255: cursor c2 is
256: select null
257: from ben_popl_rptg_grp_f rgr
258: where rgr.rptg_grp_id = p_rptg_grp_id
259: and rgr.pgm_id is not null;
260: --
261: l_proc varchar2(72) := g_package||'chk_irec_plans ';

Line 478: from ben_popl_rptg_grp prg

474: l_dummy varchar2(1);
475: --
476: cursor c1 is
477: select null
478: from ben_popl_rptg_grp prg
479: where prg.business_group_id <> p_business_group_id
480: and prg.rptg_grp_id = p_rptg_grp_id
481: union
482: select null

Line 627: (p_base_table_name => 'ben_popl_rptg_grp_f',

623: Raise l_rows_exist;
624: End If;
625:
626: If (dt_api.rows_exist
627: (p_base_table_name => 'ben_popl_rptg_grp_f',
628: p_base_key_column => 'rptg_grp_id',
629: p_base_key_value => p_rptg_grp_id,
630: p_from_date => p_validation_start_date,
631: p_to_date => p_validation_end_date)) Then

Line 632: l_table_name := 'ben_popl_rptg_grp_f';

628: p_base_key_column => 'rptg_grp_id',
629: p_base_key_value => p_rptg_grp_id,
630: p_from_date => p_validation_start_date,
631: p_to_date => p_validation_end_date)) Then
632: l_table_name := 'ben_popl_rptg_grp_f';
633: Raise l_rows_exist;
634: End If;
635:
636: --