APPS.FII_USER_SEC_OPTIMIZER dependencies on FII_COMPANY_HIERARCHIES

Line 151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h

147: g_phase := 'Filtering out child company assignments from fii_company_grants.';
148:
149: DELETE FROM fii_company_grants
150: WHERE (user_id, report_region_code, company_id) IN
151: (SELECT s.user_id, s.report_region_code, s.company_id FROM fii_company_grants s, fii_company_hierarchies h
152: WHERE s.company_id = h.child_company_id
153: AND h.parent_company_id IN (SELECT company_id from fii_company_grants where user_id=s.user_id and report_region_code=s.report_region_code)
154: AND h.parent_company_id <> h.child_company_id);
155: