APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2920: hr_all_organization_units_tl hr, -- Bug 4358492

2916: pap.location_id,
2917: hr.name organization_name,
2918: NVL(pt.administrative_flag,'N') admin_flag
2919: FROM pa_projects_all pap,
2920: hr_all_organization_units_tl hr, -- Bug 4358492
2921: pa_project_types_all pt
2922: WHERE pap.project_id = l_project_id
2923: AND pap.carrying_out_organization_id = hr.organization_id
2924: AND pt.project_type = pap.project_type