APPS.PA_PWP_INVOICE_REL dependencies on AP_HOLDS_ALL

Line 60: from ap_holds_all

56: pa_draft_invoice_items pdii ,
57: pa_cust_rev_dist_lines crdl ,
58: pa_expenditure_items ei ,
59: ( select distinct invoice_id
60: from ap_holds_all
61: where hold_lookup_code = 'Pay When Paid'
62: and release_reason is null ) AHA ----- Alias query added for bug#12404156
63: WHERE AHA.invoice_id = ei.document_header_id
64: AND prj.project_type = NVL(p_project_type ,prj.project_type)

Line 104: from ap_holds_all

100: FROM pa_projects prj
101: , pa_draft_invoices pdi
102: , pa_pwp_linked_invoices pwp
103: ,( select distinct invoice_id
104: from ap_holds_all
105: where hold_lookup_code = 'Pay When Paid'
106: and release_reason is null ) AHA ----- Alias query added for bug#12404156
107: WHERE AHA.invoice_id = pwp.AP_INVOICE_ID
108: AND prj.project_type = NVL(p_project_type ,prj.project_type)

Line 211: from ap_holds_all

207: ,PA_TASKS TASK
208: ,PA_TASKS TOPTASK
209: ,
210: ( select distinct invoice_id
211: from ap_holds_all
212: where hold_lookup_code = 'Pay When Paid'
213: and release_reason is null ) aha ----- Alias query added for bug#12404156
214: WHERE aha.invoice_id = ei.document_header_id
215: AND proj.project_type = NVL(p_project_type ,proj.project_type)

Line 269: FROM AP_HOLDS_ALL

265: PWP.AP_INVOICE_ID = EI.DOCUMENT_HEADER_ID
266: )
267: /* AND EXISTS -- ONLY THOSE INVOICE WHERE A PAY WHEN PAID HOLD EXISTS .
268: (SELECT 1
269: FROM AP_HOLDS_ALL
270: WHERE INVOICE_ID = EI.DOCUMENT_HEADER_ID --- Commented the exists clause for bug#12404156
271: AND HOLD_LOOKUP_CODE = 'Pay When Paid'
272: AND RELEASE_REASON IS NULL
273: )*/

Line 568: select hold_lookup_code from ap_holds_all

564:
565: -- Cursor c1 is to fetch hold lookup code
566: -- for the invoice being passed if any of the PWP hold exists.
567: Cursor c1(p_invoice_id Number) Is
568: select hold_lookup_code from ap_holds_all
569: where invoice_id= p_invoice_id
570: and hold_lookup_code = 'Pay When Paid'
571: and release_reason IS NULL;
572: