APPS.PA_PWP_NOTIFICATION dependencies on HR_ORGANIZATION_UNITS

Line 507: FROM hr_organization_units

503:
504: CURSOR c_orgz_info ( p_carrying_out_organization_id NUMBER )
505: IS
506: SELECT name Organization_Name
507: FROM hr_organization_units
508: WHERE organization_id = p_carrying_out_organization_id;
509:
510: l_orgz_info_rec c_orgz_info%ROWTYPE;
511: l_proj_manager_rec c_proj_manager%ROWTYPE;