APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on PA_PROJECTS_ALL

Line 371: FROM pa_projects_all pa,

367: NULL CUSTOMER_ASSIGNED_TO,
368: NULL CUSTOMER_NAME,
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

Line 748: pa_projects_all pa,

744: hp.party_name CUSTOMER_NAME,
745: hcsu.location CUSTOMER_SITE,
746: arl.meaning CUSTOMER_CATEGORY
747: FROM
748: pa_projects_all pa,
749: pa_tasks pat,
750: hz_parties hp,
751: hz_cust_site_uses_all hcsu,
752: ar_lookups arl,