APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 405: pn_space_assign_emp_all emp

401: NULL customer_site,
402: NULL customer_category
403: FROM pa_projects_all pa,
404: pa_tasks pat,
405: pn_space_assign_emp_all emp
406: WHERE emp.location_id = V_LOCATION_ID_2
407: AND pa.project_id(+)= emp.project_id
408: AND pat.task_id(+) = emp.task_id
409: AND as_of_date BETWEEN emp.emp_assign_start_date AND NVL(emp.emp_assign_end_date, l_date);