DBA Data[Home] [Help]

APPS.PA_CANDIDATE_PUB dependencies on PA_PROJECTS_ALL

Line 2045: FROM pa_projects_all pap,

2041: pap.carrying_out_organization_id carrying_out_organization_id,
2042: pap.location_id,
2043: hr.name organization_name,
2044: NVL(pt.administrative_flag,'N') admin_flag
2045: FROM pa_projects_all pap,
2046: hr_all_organization_units hr,
2047: pa_project_types_all pt
2048: WHERE pap.project_id = l_project_id
2049: AND pap.carrying_out_organization_id =