DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on AP_HOLDS_ALL

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

4673: l_msg VARCHAR2(4000);
4674:
4675: l_return_status BOOLEAN := TRUE;
4676:
4677: TYPE hold_lookup_code_tab IS TABLE OF ap_holds_all.hold_lookup_code%TYPE;
4678: l_hold_lookup_code hold_lookup_code_tab;
4679: l_release_lookup_code ap_holds_all.release_lookup_code%TYPE;
4680: l_api_name varchar2(30);
4681: --Bug 7410237 start

Line 4679: l_release_lookup_code ap_holds_all.release_lookup_code%TYPE;

4675: l_return_status BOOLEAN := TRUE;
4676:
4677: TYPE hold_lookup_code_tab IS TABLE OF ap_holds_all.hold_lookup_code%TYPE;
4678: l_hold_lookup_code hold_lookup_code_tab;
4679: l_release_lookup_code ap_holds_all.release_lookup_code%TYPE;
4680: l_api_name varchar2(30);
4681: --Bug 7410237 start
4682: l_system_user NUMBER := 5;
4683:

Line 4798: FROM ap_holds_all

4794: -----------------------------------------------------------------
4795: BEGIN
4796: SELECT hold_lookup_code
4797: BULK COLLECT INTO l_hold_lookup_code
4798: FROM ap_holds_all
4799: WHERE invoice_id = l_inv_header_rec.invoice_id
4800: AND org_id = l_inv_header_rec.org_id
4801: AND hold_lookup_code IN ('TAX VARIANCE', 'TAX AMOUNT RANGE')
4802: AND release_lookup_code is NULL;