DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 2066: FROM ap_inv_SELECTion_criteria_all AISC

2062:
2063: debug_info := 'Select check_date for thIS checkrun';
2064: SELECT AISC.check_date
2065: INTO l_awt_date
2066: FROM ap_inv_SELECTion_criteria_all AISC
2067: WHERE AISC.checkrun_name = P_Checkrun_Name
2068: and aisc.checkrun_id = p_checkrun_id;
2069:
2070:

Line 2089: update ap_inv_selection_criteria_all

2085: -- pass the rejection_level_code as 'REQUEST' to IBY.
2086: -- We will not update the rejection levels directly so that we can retrieve
2087: -- the initial values for these if the user removes awt invoices during
2088: -- the review stage from the selected invoices.
2089: update ap_inv_selection_criteria_all
2090: set /*document_rejection_level_code = 'REQUEST',
2091: payment_rejection_level_code = 'REQUEST'*/
2092: inv_awt_exists_flag = 'Y'
2093: where checkrun_id = p_checkrun_id;

Line 2269: update ap_inv_selection_criteria_all

2265: -- pass the rejection_level_code as 'REQUEST' to IBY.
2266: -- We will not update the rejection levels directly so that we can retrieve
2267: -- the initial values for these if the user removes awt invoices during
2268: -- the review stage from the selected invoices.
2269: update ap_inv_selection_criteria_all
2270: set /*document_rejection_level_code = 'REQUEST',
2271: payment_rejection_level_code = 'REQUEST'*/
2272: inv_awt_exists_flag = 'Y'
2273: where checkrun_id = p_checkrun_id;