DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 3106: FROM ap_inv_SELECTion_criteria_all AISC

3102: END IF;
3103:
3104: SELECT AISC.check_date
3105: INTO l_awt_date
3106: FROM ap_inv_SELECTion_criteria_all AISC
3107: WHERE AISC.checkrun_name = P_Checkrun_Name
3108: and aisc.checkrun_id = p_checkrun_id;
3109:
3110:

Line 3137: update ap_inv_selection_criteria_all

3133: -- pass the rejection_level_code as 'REQUEST' to IBY.
3134: -- We will not update the rejection levels directly so that we can retrieve
3135: -- the initial values for these if the user removes awt invoices during
3136: -- the review stage from the selected invoices.
3137: update ap_inv_selection_criteria_all
3138: set /*document_rejection_level_code = 'REQUEST',
3139: payment_rejection_level_code = 'REQUEST'*/
3140: inv_awt_exists_flag = 'Y'
3141: where checkrun_id = p_checkrun_id;

Line 3372: update ap_inv_selection_criteria_all

3368: -- pass the rejection_level_code as 'REQUEST' to IBY.
3369: -- We will not update the rejection levels directly so that we can retrieve
3370: -- the initial values for these if the user removes awt invoices during
3371: -- the review stage from the selected invoices.
3372: update ap_inv_selection_criteria_all
3373: set /*document_rejection_level_code = 'REQUEST',
3374: payment_rejection_level_code = 'REQUEST'*/
3375: inv_awt_exists_flag = 'Y'
3376: where checkrun_id = p_checkrun_id;