eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAAP_PWP_PKG dependencies on AP_HOLDS_ALL

Line 436: select hold_lookup_code from ap_holds_all

432:
433: -- Cursor c1 is to fetch hold lookup code
434: -- for the invoice being passed if any of the PWP or DLV hold exists.
435: Cursor c1(p_invoice_id Number) Is
436: select hold_lookup_code from ap_holds_all
437: where invoice_id= p_invoice_id
438: and hold_lookup_code in ('Pay When Paid','PO Deliverable')
439: and release_reason IS NULL;
440:

Line 689: Select hold_lookup_code, hold_reason, 'PWP/DLV' HoldType From ap_holds_all

685: group by apd.invoice_id, apd.project_Id, apd.task_id, apd.po_dIstribution_id, apd.expenditure_item_date;
686:
687: -- To get the hold reason if any for an Invoice.
688: Cursor C3(P_Invoice_Id Number) Is
689: Select hold_lookup_code, hold_reason, 'PWP/DLV' HoldType From ap_holds_all
690: Where invoice_id= P_Invoice_Id
691: And hold_lookup_code In ('Pay When Paid','PO Deliverable')
692: and RELEASE_REASON is null;
693: