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.AP_ETAX_SERVICES_PKG dependencies on AP_HOLDS_ALL

Line 5494: TYPE hold_lookup_code_tab IS TABLE OF ap_holds_all.hold_lookup_code%TYPE;

5490: l_msg VARCHAR2(4000);
5491:
5492: l_return_status BOOLEAN := TRUE;
5493:
5494: TYPE hold_lookup_code_tab IS TABLE OF ap_holds_all.hold_lookup_code%TYPE;
5495: l_hold_lookup_code hold_lookup_code_tab;
5496: l_release_lookup_code ap_holds_all.release_lookup_code%TYPE;
5497: l_api_name varchar2(30);
5498: --Bug 7410237 start

Line 5496: l_release_lookup_code ap_holds_all.release_lookup_code%TYPE;

5492: l_return_status BOOLEAN := TRUE;
5493:
5494: TYPE hold_lookup_code_tab IS TABLE OF ap_holds_all.hold_lookup_code%TYPE;
5495: l_hold_lookup_code hold_lookup_code_tab;
5496: l_release_lookup_code ap_holds_all.release_lookup_code%TYPE;
5497: l_api_name varchar2(30);
5498: --Bug 7410237 start
5499: l_system_user NUMBER := 5;
5500:

Line 5640: FROM ap_holds_all

5636: -----------------------------------------------------------------
5637: BEGIN
5638: SELECT hold_lookup_code
5639: BULK COLLECT INTO l_hold_lookup_code
5640: FROM ap_holds_all
5641: WHERE invoice_id = l_inv_header_rec.invoice_id
5642: AND org_id = l_inv_header_rec.org_id
5643: AND hold_lookup_code IN ('TAX VARIANCE', 'TAX AMOUNT RANGE')
5644: AND release_lookup_code is NULL;