APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PA_R_PROJECT_RESOURCES_V

Line 58: FROM pa_r_project_resources_v

54: resource_type,
55: job_id,
56: job_group_id,
57: location_id
58: FROM pa_r_project_resources_v
59: WHERE person_id = p_in_person_id
60: AND (p_type = p_person_type or p_person_type = 'ALL')
61: UNION
62: -- This select is to get each person_id from HR that is terminated

Line 128: FROM pa_r_project_resources_v

124: resource_type,
125: job_id,
126: job_group_id,
127: location_id
128: FROM pa_r_project_resources_v
129: WHERE per_emp_number >= nvl(l_from_emp_num, per_emp_number) and
130: per_emp_number <= nvl(l_to_emp_num, per_emp_number) and
131: organization_id = nvl(l_p_org_id, organization_id)
132: ORDER BY person_id, assignment_start_date;

Line 2089: from pa_r_project_resources_v res

2085: /* Modified cursor starts for Bug 6263517 */
2086: CURSOR get_max_end_date_term(p_person_id IN NUMBER) IS
2087: SELECT MAX (asgn_end_date) FROM
2088: (select max(res.assignment_end_date) asgn_end_date
2089: from pa_r_project_resources_v res
2090: where res.person_id = p_person_id
2091: and res.assignment_end_date IS NOT NULL
2092: UNION
2093: select max(res.assignment_end_date) ass_end_date

Line 2747: -- It goes through a loop using pa_r_project_resources_v

2743:
2744:
2745: ------------------------------------------------------------
2746: -- This is the concurrent pull program
2747: -- It goes through a loop using pa_r_project_resources_v
2748: ------------------------------------------------------------
2749: ELSE /* Not an individual pull - Mass pull */
2750:
2751: -- Check that terminated resources pull date is within