DBA Data[Home] [Help]

APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on PA_TASKS

Line 372: pa_tasks pat,

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

Line 749: pa_tasks pat,

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,