APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PA_R_PROJECT_RESOURCES_TERM_V

Line 91: FROM pa_r_project_resources_term_v

87: resource_type,
88: job_id,
89: job_group_id,
90: location_id
91: FROM pa_r_project_resources_term_v
92: WHERE p_pull_term_res = 'Y'
93: and person_id = p_in_person_id
94: and termination_date >= p_term_range_date
95: AND (p_type = p_person_type or p_person_type = 'ALL')

Line 2081: from pa_r_project_resources_term_v res

2077: /* Modifying existing cursor to get max terminated date (from both past terminated
2078: or future terminated date values )
2079: CURSOR get_max_end_date_term(p_person_id IN NUMBER) IS
2080: select max(assignment_end_date)
2081: from pa_r_project_resources_term_v res
2082: where res.person_id = p_person_id; */
2083: /* Commenting ends for Bug 6263517 */
2084:
2085: /* Modified cursor starts for Bug 6263517 */

Line 2094: from pa_r_project_resources_term_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
2094: from pa_r_project_resources_term_v res
2095: where res.person_id = p_person_id
2096: and res.assignment_end_date IS NOT NULL ) ;
2097: /* Modified cursor ends for Bug 6263517 */
2098:

Line 2159: FROM pa_r_project_resources_term_v prd

2155: SELECT prd.person_id,
2156: prd.assignment_start_date,
2157: prd.assignment_end_date,
2158: prd.organization_id
2159: FROM pa_r_project_resources_term_v prd
2160: WHERE per_end_date < sysdate
2161: AND assignment_end_date < sysdate
2162: AND per_end_date < l_prof_date
2163: AND per_end_date is not null

Line 3384: --max(assignment_end_date) from pa_r_project_resources_term_v res

3380: ---------------------------------------------------------------------
3381: --This IF tells us the last record for a person as from cur_resources.
3382: --Here we are going to delete all rows for pa_resources_denorm for
3383: --which the resource_effective_end_date is greater than
3384: --max(assignment_end_date) from pa_r_project_resources_term_v res
3385: ---------------------------------------------------------------------
3386: IF (trunc(l_end_date) = trunc(l_assignment_end_date))
3387: AND eRec.termination_date IS NOT NULL THEN
3388: