APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2859: hr_all_organization_units_tl hr, -- Bug 4358492

2855: pap.location_id,
2856: hr.name organization_name,
2857: NVL(pt.administrative_flag,'N') admin_flag
2858: FROM pa_projects_all pap,
2859: hr_all_organization_units_tl hr, -- Bug 4358492
2860: pa_project_types_all pt
2861: WHERE pap.project_id = l_project_id
2862: AND pap.carrying_out_organization_id = hr.organization_id
2863: AND pt.project_type = pap.project_type