APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_RPTG_GRP

Line 1158: FROM ben_rptg_grp bnr

1154: the user. */
1155: AND (
1156: EXISTS
1157: (SELECT NULL
1158: FROM ben_rptg_grp bnr
1159: ,ben_popl_rptg_grp_f rgr
1160: WHERE bnr.rptg_grp_id = p_rptg_grp_id
1161: AND nvl(bnr.business_group_id,cpp.business_group_id) =
1162: cpp.business_group_id

Line 1303: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr

1299: reporting group that has been specified by the user. */
1300: AND (
1301: EXISTS
1302: (SELECT NULL
1303: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr
1304: WHERE bnr.rptg_grp_id = p_rptg_grp_id
1305: AND nvl(bnr.business_group_id,pgm.business_group_id)
1306: = pgm.business_group_id
1307: AND rgr.rptg_grp_id = bnr.rptg_grp_id

Line 1486: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr

1482: /* Make sure that plan being linked to is in the correct benefit group */
1483: AND (
1484: EXISTS
1485: (SELECT NULL
1486: FROM ben_rptg_grp bnr, ben_popl_rptg_grp_f rgr
1487: WHERE bnr.rptg_grp_id = nvl(p_rptg_grp_id, bnr.rptg_grp_id) --irec
1488: AND nvl(bnr.business_group_id,pln.business_group_id)
1489: = pln.business_group_id
1490: AND rgr.rptg_grp_id = bnr.rptg_grp_id

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

1933: l_tabname_set(9) := 'ben_eligy_prfl_f';
1934: --
1935: l_tabname_set(10) := 'ben_popl_yr_perd';
1936: l_tabname_set(11) := 'ben_yr_perd';
1937: l_tabname_set(12) := 'ben_rptg_grp';
1938: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1939: --
1940: l_tabname_set(10) := 'ben_popl_yr_perd';
1941: l_tabname_set(11) := 'ben_yr_perd';

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

1938: l_tabname_set(13) := 'ben_popl_rptg_grp_f';
1939: --
1940: l_tabname_set(10) := 'ben_popl_yr_perd';
1941: l_tabname_set(11) := 'ben_yr_perd';
1942: l_tabname_set(12) := 'ben_rptg_grp';
1943: l_tabname_set(13) := 'ben_popl_rptg_grp';
1944: --
1945: l_tabname_set(14) := 'ben_enrt_perd_for_pl_f';
1946: l_tabname_set(15) := 'ben_enrt_perd';