APPS.PA_HR_UPDATE_API dependencies on PA_R_PROJECT_RESOURCES_V

Line 2762: FROM pa_r_project_resources_v res

2758: GROUP BY person_id;
2759:
2760: CURSOR distinct_job_res_recs IS
2761: SELECT DISTINCT res.person_id person_id
2762: FROM pa_r_project_resources_v res
2763: WHERE res.job_id = p_job_id;
2764:
2765: BEGIN
2766: -- Initialize the Error stack

Line 3219: from pa_r_project_resources_v res

3215: --Bug 9838014 Start
3216: CURSOR get_max_end_date_term(p_person_id IN NUMBER) IS
3217: SELECT MAX (asgn_end_date) FROM
3218: (select max(res.assignment_end_date) asgn_end_date
3219: from pa_r_project_resources_v res
3220: where res.person_id = p_person_id
3221: and res.assignment_end_date IS NOT NULL
3222: UNION
3223: select max(res.assignment_end_date) ass_end_date

Line 3388: FROM pa_r_project_resources_v

3384: BEGIN
3385:
3386: SELECT max(assignment_end_date)
3387: INTO l_resource_effective_end_date
3388: FROM pa_r_project_resources_v
3389: WHERE person_id = p_person_id;
3390:
3391: EXCEPTION
3392: WHEN NO_DATA_FOUND THEN