APPS.PA_PWP_INVOICE_REL dependencies on AP_HOLDS_ALL

Line 95: FROM AP_HOLDS_ALL

91: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1))
92: )
93: and EXISTS -- only those invoice where a Pay When Paid hold exists .
94: ( SELECT 1
95: FROM AP_HOLDS_ALL
96: WHERE invoice_id = ei.document_header_id
97: AND hold_lookup_code = 'Pay When Paid'
98: AND release_reason is null )
99: UNION

Line 135: FROM AP_HOLDS_ALL

131:
132: )
133: and EXISTS -- only those invoice where a Pay When Paid hold exists .
134: ( SELECT 1
135: FROM AP_HOLDS_ALL
136: WHERE invoice_id = pwp.AP_INVOICE_ID
137: AND hold_lookup_code = 'Pay When Paid'
138: AND release_reason is null)
139: ;

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
271: AND HOLD_LOOKUP_CODE = 'Pay When Paid'
272: AND RELEASE_REASON IS NULL
273: );

Line 565: select hold_lookup_code from ap_holds_all

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