APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_RPTG_GRP

Line 1143: FROM ben_rptg_grp bnr

1139: the user. */
1140: AND (
1141: EXISTS
1142: (SELECT NULL
1143: FROM ben_rptg_grp bnr
1144: ,ben_popl_rptg_grp_f rgr
1145: WHERE bnr.rptg_grp_id = p_rptg_grp_id
1146: AND nvl(bnr.business_group_id,cpp.business_group_id) =
1147: cpp.business_group_id

Line 1288: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr

1284: reporting group that has been specified by the user. */
1285: AND (
1286: EXISTS
1287: (SELECT NULL
1288: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr
1289: WHERE bnr.rptg_grp_id = p_rptg_grp_id
1290: AND nvl(bnr.business_group_id,pgm.business_group_id)
1291: = pgm.business_group_id
1292: AND rgr.rptg_grp_id = bnr.rptg_grp_id

Line 1471: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr

1467: /* Make sure that plan being linked to is in the correct benefit group */
1468: AND (
1469: EXISTS
1470: (SELECT NULL
1471: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr
1472: WHERE bnr.rptg_grp_id = nvl(p_rptg_grp_id, bnr.rptg_grp_id) --irec
1473: AND nvl(bnr.business_group_id,pln.business_group_id)
1474: = pln.business_group_id
1475: AND rgr.rptg_grp_id = bnr.rptg_grp_id

Line 1919: l_tabname_set(12) := 'ben_rptg_grp';

1915: l_tabname_set(9) := 'ben_eligy_prfl_f';
1916: --
1917: l_tabname_set(10) := 'ben_popl_yr_perd';
1918: l_tabname_set(11) := 'ben_yr_perd';
1919: l_tabname_set(12) := 'ben_rptg_grp';
1920: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1921: --
1922: l_tabname_set(10) := 'ben_popl_yr_perd';
1923: l_tabname_set(11) := 'ben_yr_perd';

Line 1924: l_tabname_set(12) := 'ben_rptg_grp';

1920: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1921: --
1922: l_tabname_set(10) := 'ben_popl_yr_perd';
1923: l_tabname_set(11) := 'ben_yr_perd';
1924: l_tabname_set(12) := 'ben_rptg_grp';
1925: l_tabname_set(13) := 'ben_popl_rptg_grp';
1926: --
1927: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1928: l_tabname_set(15) := 'ben_enrt_perd';