APPS.MSC_SATP_FUNC dependencies on HR_ALL_ORGANIZATION_UNITS
Line 26: from HR_ALL_ORGANIZATION_UNITS
22: SELECT location_id
23: into l_location_id
24: --bug 3346564
25: --from HR_ORGANIZATION_UNITS 26: from HR_ALL_ORGANIZATION_UNITS 27: where organization_id = p_organization_id;
28:
29: ELSIF (p_customer_id IS NOT NULL and p_customer_site_id IS NOT NULL) THEN
30: -- Bug 2793404, Bug discovered by Sony