DBA Data[Home] [Help]

APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_POPL_RPTG_GRP_F

Line 1159: ,ben_popl_rptg_grp_f rgr

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
1163: AND rgr.rptg_grp_id = bnr.rptg_grp_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 1938: l_tabname_set(13) := 'ben_popl_rptg_grp_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';
1942: l_tabname_set(12) := 'ben_rptg_grp';