APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 373: pn_space_assign_emp_all emp

369: NULL CUSTOMER_SITE,
370: NULL CUSTOMER_CATEGORY
371: FROM pa_projects_all pa,
372: pa_tasks pat,
373: pn_space_assign_emp_all emp
374: WHERE emp.location_id = V_LOCATION_ID_2
375: AND pa.project_id(+) = emp.project_id
376: AND pat.task_id(+) = emp.task_id
377: AND as_of_date between emp.emp_assign_start_date AND NVL(emp.emp_assign_end_date, l_date);