DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on HR_ORGANIZATION_UNITS

Line 3434: hr_organization_units hou,

3430: hou.name organization,
3431: paf.employment_category employment_category,
3432: hrl.meaning employment_category_meaning
3433: FROM per_jobs pj,
3434: hr_organization_units hou,
3435: hr_lookups hrl,
3436: per_phones pp,
3437: per_person_types_tl ppttl,
3438: per_all_assignments_f paf,

Line 3498: HR_ORGANIZATION_UNITS hou

3494: SELECT pa.segment1,
3495: hou.name
3496: INTO l_emp_pr_data
3497: FROM PA_PROJECTS_ALL pa,
3498: HR_ORGANIZATION_UNITS hou
3499: WHERE pa.project_id = p_projectId
3500: AND hou.organization_id = pa.carrying_out_organization_id;
3501:
3502: RETURN l_emp_pr_data;