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
376: AND pat.task_id(+) = emp.task_id
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,
753: hz_cust_accounts hca,