APPS.PA_RETN_BILLING_PKG dependencies on PA_IMPLEMENTATIONS

Line 327: FROM PA_IMPLEMENTATIONS I

323: and NOT EXISTS
324: (
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

Line 340: FROM PA_IMPLEMENTATIONS I

336: AND C.CUSTOMER_ID <> C.BILL_TO_CUSTOMER_ID
337: ))
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

Line 353: FROM PA_IMPLEMENTATIONS I

349: AND C.CUSTOMER_ID <> C.SHIP_TO_CUSTOMER_ID
350: ))
351: UNION ALL
352: SELECT NULL
353: FROM PA_IMPLEMENTATIONS I
354: WHERE I.cust_acc_rel_code = 'N'
355: AND exists (select 1 from PA_PROJECT_CUSTOMERS C
356: WHERE C.PROJECT_ID = p_project_id
357: AND ( C.CUSTOMER_ID <> C.BILL_TO_CUSTOMER_ID

Line 452: FROM pa_implementations imp;

448:
449: --- Get the set of books id
450: SELECT imp.set_of_books_id
451: INTO TmpSetOfBooks
452: FROM pa_implementations imp;
453:
454: IF g1_debug_mode = 'Y' THEN
455: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'TmpSetOfBooks : ' || TmpSetOfBooks);
456: pa_retention_util.write_log('Build_Retn_Invoice_Header: ' || 'Call PA_OUTPUT_TAX.GET_DEFAULT_TAX_INFO');