APPS.PA_DCTN_APRV_NOTIFICATION dependencies on HR_ORGANIZATION_UNITS

Line 295: FROM HR_ORGANIZATION_UNITS

291: ,x_content_id OUT NOCOPY NUMBER) IS
292:
293: CURSOR c_orgz_info (p_carrying_out_organization_id NUMBER) IS
294: SELECT name organization_name
295: FROM HR_ORGANIZATION_UNITS
296: WHERE organization_id = p_carrying_out_organization_id;
297:
298: CURSOR c_vendor_info (c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
299: SELECT pov.vendor_name Vendor_Name,