APPS.PA_ASSIGNMENT_UTILS dependencies on PA_PROJ_ASSIGNMENTS_ACTUALS_V

Line 855: FROM pa_proj_assignments_actuals_v

851: l_assignment_name pa_project_assignments.assignment_name%TYPE;
852:
853: CURSOR get_assignment_with_name IS
854: SELECT assignment_id, assignment_name
855: FROM pa_proj_assignments_actuals_v
856: WHERE project_id = p_project_id
857: AND person_id = p_person_id
858: AND p_ei_date between start_date and end_date
859: AND assignment_name = x_assignment_name

Line 864: FROM pa_proj_assignments_actuals_v

860: ORDER BY assignment_start_date DESC;
861:
862: CURSOR get_assignment_without_name IS
863: SELECT assignment_id, assignment_name
864: FROM pa_proj_assignments_actuals_v
865: WHERE project_id = p_project_id
866: AND person_id = p_person_id
867: AND p_ei_date between start_date and end_date
868: ORDER BY assignment_start_date DESC;