APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PA_TASKS

Line 404: pa_tasks pat,

400: NULL customer_name,
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

Line 740: pa_tasks pat,

736: hz_cust_site_uses_all hcsu,
737: ar_lookups arl,
738: hz_cust_accounts hca,
739: pa_projects_all pa,
740: pa_tasks pat,
741: pn_space_assign_cust_all cust
742: WHERE cust.location_id = v_location_id_2
743: AND hca.cust_account_id = cust.cust_account_id
744: AND hca.party_id = hp.party_id