APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PA_PROJECTS_ALL

Line 403: FROM pa_projects_all pa,

399: NULL customer_assigned_to,
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

Line 739: pa_projects_all pa,

735: FROM hz_parties hp,
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