325: /* Removed the existing code for perf bug 3607384 and added the below */
326: SELECT NULL
327: FROM PA_IMPLEMENTATIONS I
328: WHERE I.CUST_ACC_REL_CODE = 'Y'
329: AND exists ( select 1 from HZ_CUST_ACCT_RELATE HZ1,
330: PA_PROJECT_CUSTOMERS C
331: where C.PROJECT_ID=p_project_id
332: AND ( HZ1.CUST_ACCOUNT_ID(+) = C.CUSTOMER_ID
333: AND HZ1.RELATED_CUST_ACCOUNT_ID(+) = C.BILL_TO_CUSTOMER_ID
338: UNION ALL
339: SELECT NULL
340: FROM PA_IMPLEMENTATIONS I
341: WHERE I.CUST_ACC_REL_CODE = 'Y'
342: AND exists ( select 1 from HZ_CUST_ACCT_RELATE HZ1,
343: PA_PROJECT_CUSTOMERS C
344: where C.PROJECT_ID=p_project_id
345: AND ( HZ1.CUST_ACCOUNT_ID(+) = C.CUSTOMER_ID
346: AND HZ1.RELATED_CUST_ACCOUNT_ID(+) = C.SHIP_TO_CUSTOMER_ID