DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INV_SELECTION_CRITERIA_ALL

Line 114: from ap_inv_selection_criteria_all

110:
111:
112: select next_voucher_number
113: into l_next_voucher_number
114: from ap_inv_selection_criteria_all
115: where checkrun_id = p_checkrun_id
116: for update;
117:
118: if l_next_voucher_number is null then

Line 138: update ap_inv_selection_criteria_all

134:
135:
136: end loop;
137:
138: update ap_inv_selection_criteria_all
139: set next_voucher_number = l_next_voucher_number
140: where checkrun_id = p_checkrun_id;
141:
142:

Line 552: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;

548: p_rejected_docs_group_id IN NUMBER) IS
549:
550:
551: l_checkrun_id number;
552: l_checkrun_name ap_inv_selection_criteria_all.checkrun_name%type;
553: l_check_date date;
554: l_debug_info varchar2(200);
555: /*Bug 5020577*/
556: /*Introduced the join for org id with IBY tables*/

Line 599: from ap_inv_selection_criteria_all

595:
596:
597: select checkrun_name, check_date
598: into l_checkrun_name, l_check_date
599: from ap_inv_selection_criteria_all
600: where checkrun_id = l_checkrun_id;
601:
602: OPEN c_sel_invs;
603:

Line 959: FROM ap_inv_selection_criteria_all

955: l_transfer_priority,
956: l_check_date, --use this for the exchange date also, PM confirmed
957: l_checkrun_name,
958: l_first_voucher_number
959: FROM ap_inv_selection_criteria_all
960: WHERE checkrun_id = l_checkrun_id;
961:
962: l_debug_info := 'get_terms';
963: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN