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.

[Home] [Help]

APPS.IBY_PAYINSTR_PUB dependencies on IBY_PAYMENTS_ALL

Line 96: p_payment_profile_id IN IBY_PAYMENTS_ALL.

92: p_comments IN IBY_PAY_INSTRUCTIONS_ALL.
93: comments%TYPE,
94:
95: /*-- selection criteria --*/
96: p_payment_profile_id IN IBY_PAYMENTS_ALL.
97: payment_profile_id%TYPE,
98: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.
99: calling_app_id%TYPE,
100: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

Line 106: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.

102: %TYPE,
103: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
104: payment_service_request_id
105: %TYPE,
106: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
107: internal_bank_account_id%TYPE,
108: p_payment_currency IN IBY_PAYMENTS_ALL.
109: payment_currency_code%TYPE,
110: p_le_id IN IBY_PAYMENTS_ALL.

Line 108: p_payment_currency IN IBY_PAYMENTS_ALL.

104: payment_service_request_id
105: %TYPE,
106: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
107: internal_bank_account_id%TYPE,
108: p_payment_currency IN IBY_PAYMENTS_ALL.
109: payment_currency_code%TYPE,
110: p_le_id IN IBY_PAYMENTS_ALL.
111: legal_entity_id%TYPE,
112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,

Line 110: p_le_id IN IBY_PAYMENTS_ALL.

106: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
107: internal_bank_account_id%TYPE,
108: p_payment_currency IN IBY_PAYMENTS_ALL.
109: payment_currency_code%TYPE,
110: p_le_id IN IBY_PAYMENTS_ALL.
111: legal_entity_id%TYPE,
112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
113: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
114: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,

Line 112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,

108: p_payment_currency IN IBY_PAYMENTS_ALL.
109: payment_currency_code%TYPE,
110: p_le_id IN IBY_PAYMENTS_ALL.
111: legal_entity_id%TYPE,
112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
113: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
114: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
115: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
116:

Line 113: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,

109: payment_currency_code%TYPE,
110: p_le_id IN IBY_PAYMENTS_ALL.
111: legal_entity_id%TYPE,
112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
113: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
114: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
115: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
116:
117: /*-- single payments / batch flow identifier --*/

Line 114: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,

110: p_le_id IN IBY_PAYMENTS_ALL.
111: legal_entity_id%TYPE,
112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
113: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
114: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
115: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
116:
117: /*-- single payments / batch flow identifier --*/
118: p_single_pmt_flow_flag IN VARCHAR2 DEFAULT 'N',

Line 115: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,

111: legal_entity_id%TYPE,
112: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
113: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
114: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
115: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
116:
117: /*-- single payments / batch flow identifier --*/
118: p_single_pmt_flow_flag IN VARCHAR2 DEFAULT 'N',
119:

Line 176: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction

172: * Since the IBY_PAY_INSTRUCTIONS_ALL table does not contain a payment id,
173: * a separate data structure is needed to keep track of the payments
174: * that are part of a payment instruction. This information is tracked
175: * in the pmtsInInstrTabType table. The rows in pmtsInInstrTabType are
176: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction
177: * ids.
178: *
179: * l_instrTab l_pmtsInInstrTab
180: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)

Line 180: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)

176: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction
177: * ids.
178: *
179: * l_instrTab l_pmtsInInstrTab
180: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)
181: * /--------------------------------------\ /-------------\
182: * |Payment |Payment|..|Instr |Payment|..| |Payment |Pmt |
183: * |Instr Id|Profile|..|Status |Count |..| |Instr Id|Id |
184: * | |Id |..| | |..| | | |

Line 218: prev_pmt_id iby_payments_all.payment_id%TYPE;

214: l_errTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
215:
216: /* previous payment attributes */
217: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
218: prev_pmt_id iby_payments_all.payment_id%TYPE;
219: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;

Line 219: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;

215:
216: /* previous payment attributes */
217: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
218: prev_pmt_id iby_payments_all.payment_id%TYPE;
219: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;

Line 220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;

216: /* previous payment attributes */
217: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
218: prev_pmt_id iby_payments_all.payment_id%TYPE;
219: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;

Line 221: prev_int_bank_acct_id iby_payments_all.

217: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
218: prev_pmt_id iby_payments_all.payment_id%TYPE;
219: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;

Line 223: prev_org_id iby_payments_all.org_id%TYPE;

219: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;

Line 224: prev_org_type iby_payments_all.org_type%TYPE;

220: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;

Line 225: prev_le_id iby_payments_all.legal_entity_id%TYPE;

221: prev_int_bank_acct_id iby_payments_all.
222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

Line 226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;

222: internal_bank_account_id%TYPE;
223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

Line 227: prev_payment_date iby_payments_all.payment_date%TYPE;

223: prev_org_id iby_payments_all.org_id%TYPE;
224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

Line 228: prev_pmt_function iby_payments_all.payment_function%TYPE;

224: prev_org_type iby_payments_all.org_type%TYPE;
225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;

Line 229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

225: prev_le_id iby_payments_all.legal_entity_id%TYPE;
226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
233: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;

Line 230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

226: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
233: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
234: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;

Line 231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

227: prev_payment_date iby_payments_all.payment_date%TYPE;
228: prev_pmt_function iby_payments_all.payment_function%TYPE;
229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
233: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
234: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
235:

Line 233: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;

229: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
233: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
234: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
235:
236: /* current payment attributes */
237: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;

Line 234: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;

230: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
231: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
232: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
233: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
234: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
235:
236: /* current payment attributes */
237: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
238: curr_pmt_id iby_payments_all.payment_id%TYPE;

Line 238: curr_pmt_id iby_payments_all.payment_id%TYPE;

234: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
235:
236: /* current payment attributes */
237: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
238: curr_pmt_id iby_payments_all.payment_id%TYPE;
239: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;

Line 239: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;

235:
236: /* current payment attributes */
237: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
238: curr_pmt_id iby_payments_all.payment_id%TYPE;
239: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;

Line 240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;

236: /* current payment attributes */
237: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
238: curr_pmt_id iby_payments_all.payment_id%TYPE;
239: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;

Line 241: curr_int_bank_acct_id iby_payments_all.

237: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
238: curr_pmt_id iby_payments_all.payment_id%TYPE;
239: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;

Line 243: curr_org_id iby_payments_all.org_id%TYPE;

239: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;

Line 244: curr_org_type iby_payments_all.org_type%TYPE;

240: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;

Line 245: curr_le_id iby_payments_all.legal_entity_id%TYPE;

241: curr_int_bank_acct_id iby_payments_all.
242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

Line 246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;

242: internal_bank_account_id%TYPE;
243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

Line 247: curr_payment_date iby_payments_all.payment_date%TYPE;

243: curr_org_id iby_payments_all.org_id%TYPE;
244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

Line 248: curr_pmt_function iby_payments_all.payment_function%TYPE;

244: curr_org_type iby_payments_all.org_type%TYPE;
245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;

Line 249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

245: curr_le_id iby_payments_all.legal_entity_id%TYPE;
246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
253: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;

Line 250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

246: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
253: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
254: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;

Line 251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

247: curr_payment_date iby_payments_all.payment_date%TYPE;
248: curr_pmt_function iby_payments_all.payment_function%TYPE;
249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
253: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
254: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
255:

Line 253: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;

249: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
253: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
254: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
255:
256: l_sql_chunk VARCHAR2(3000);
257: l_cursor_stmt VARCHAR2(8000);

Line 254: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;

250: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
251: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
252: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
253: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
254: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
255:
256: l_sql_chunk VARCHAR2(3000);
257: l_cursor_stmt VARCHAR2(8000);
258:

Line 555: FROM iby_payments_all pmts

551: /*IF(p_pmt_document_id IS NOT NULL AND p_payreq_id IS NOT NULL) THEN
552:
553: SELECT Count(pmts.payment_id)
554: INTO l_pmts_invalid_pdoc
555: FROM iby_payments_all pmts
556: WHERE pmts.payment_service_request_id = p_payreq_id
557: and pmts.internal_bank_account_id <> (SELECT pdoc.internal_bank_account_id
558: FROM ce_payment_documents pdoc
559: WHERE pdoc.payment_document_id = p_pmt_document_id);

Line 2856: || 'IBY_PAYMENTS_ALL table. Possible data '

2852: IF (p_pmtsInPayInstTab.COUNT = 0) THEN
2853: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2854: print_debuginfo(l_module_name, 'After grouping, no '
2855: || 'payments provided to update '
2856: || 'IBY_PAYMENTS_ALL table. Possible data '
2857: || 'corruption issue.');
2858: END IF;
2859: RETURN;
2860: END IF;

Line 2878: IBY_PAYMENTS_ALL

2874: || p_pmtsInPayInstTab(i).payment_id);
2875:
2876: END IF;
2877: UPDATE
2878: IBY_PAYMENTS_ALL
2879: SET
2880: payment_instruction_id = p_pmtsInPayInstTab(i).pay_instr_id,
2881: paper_document_number = p_pmtsInPayInstTab(i).check_number,
2882: payment_status = p_pmtsInPayInstTab(i).payment_status,

Line 3021: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;

3017:
3018:
3019: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
3020: l_grp_cntr NUMBER;
3021: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
3022: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
3023:
3024: TYPE type_payment_id IS TABLE OF
3025: IBY_PAYMENTS_ALL.payment_id%TYPE

Line 3025: IBY_PAYMENTS_ALL.payment_id%TYPE

3021: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
3022: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
3023:
3024: TYPE type_payment_id IS TABLE OF
3025: IBY_PAYMENTS_ALL.payment_id%TYPE
3026: INDEX BY BINARY_INTEGER;
3027: t_payment_id type_payment_id;
3028:
3029: TYPE type_logical_group_reference IS TABLE OF

Line 3030: IBY_PAYMENTS_ALL.logical_group_reference%TYPE

3026: INDEX BY BINARY_INTEGER;
3027: t_payment_id type_payment_id;
3028:
3029: TYPE type_logical_group_reference IS TABLE OF
3030: IBY_PAYMENTS_ALL.logical_group_reference%TYPE
3031: INDEX BY BINARY_INTEGER;
3032: t_logical_group_reference type_logical_group_reference;
3033:
3034: TYPE type_legal_entity_id IS TABLE OF

Line 3035: iby_payments_all.legal_entity_id%TYPE

3031: INDEX BY BINARY_INTEGER;
3032: t_logical_group_reference type_logical_group_reference;
3033:
3034: TYPE type_legal_entity_id IS TABLE OF
3035: iby_payments_all.legal_entity_id%TYPE
3036: INDEX BY BINARY_INTEGER;
3037: t_legal_entity_id type_legal_entity_id;
3038:
3039: TYPE type_payment_currency_code IS TABLE OF

Line 3040: iby_payments_all.payment_currency_code%TYPE

3036: INDEX BY BINARY_INTEGER;
3037: t_legal_entity_id type_legal_entity_id;
3038:
3039: TYPE type_payment_currency_code IS TABLE OF
3040: iby_payments_all.payment_currency_code%TYPE
3041: INDEX BY BINARY_INTEGER;
3042: t_payment_currency_code type_payment_currency_code;
3043:
3044: TYPE type_payment_method_code IS TABLE OF

Line 3045: iby_payments_all.payment_method_code%TYPE

3041: INDEX BY BINARY_INTEGER;
3042: t_payment_currency_code type_payment_currency_code;
3043:
3044: TYPE type_payment_method_code IS TABLE OF
3045: iby_payments_all.payment_method_code%TYPE
3046: INDEX BY BINARY_INTEGER;
3047: t_payment_method_code type_payment_method_code;
3048:
3049: TYPE type_payment_date IS TABLE OF

Line 3050: iby_payments_all.payment_date%TYPE

3046: INDEX BY BINARY_INTEGER;
3047: t_payment_method_code type_payment_method_code;
3048:
3049: TYPE type_payment_date IS TABLE OF
3050: iby_payments_all.payment_date%TYPE
3051: INDEX BY BINARY_INTEGER;
3052: t_payment_date type_payment_date;
3053:
3054: TYPE type_payment_reason_code IS TABLE OF

Line 3055: iby_payments_all.payment_reason_code%TYPE

3051: INDEX BY BINARY_INTEGER;
3052: t_payment_date type_payment_date;
3053:
3054: TYPE type_payment_reason_code IS TABLE OF
3055: iby_payments_all.payment_reason_code%TYPE
3056: INDEX BY BINARY_INTEGER;
3057: t_payment_reason_code type_payment_reason_code;
3058:
3059: TYPE type_internal_bank_account_id IS TABLE OF

Line 3060: iby_payments_all.internal_bank_account_id%TYPE

3056: INDEX BY BINARY_INTEGER;
3057: t_payment_reason_code type_payment_reason_code;
3058:
3059: TYPE type_internal_bank_account_id IS TABLE OF
3060: iby_payments_all.internal_bank_account_id%TYPE
3061: INDEX BY BINARY_INTEGER;
3062: t_internal_bank_account_id type_internal_bank_account_id;
3063:
3064:

Line 3067: iby_payments_all.settlement_priority%TYPE

3063:
3064:
3065: /* Added as part of SEPA Changes Bug 9437357*/
3066: TYPE type_settlement_priority IS TABLE OF
3067: iby_payments_all.settlement_priority%TYPE
3068: INDEX BY BINARY_INTEGER;
3069: t_settlement_priority type_settlement_priority;
3070:
3071: TYPE type_payment_function IS TABLE OF

Line 3072: iby_payments_all.payment_function%TYPE

3068: INDEX BY BINARY_INTEGER;
3069: t_settlement_priority type_settlement_priority;
3070:
3071: TYPE type_payment_function IS TABLE OF
3072: iby_payments_all.payment_function%TYPE
3073: INDEX BY BINARY_INTEGER;
3074: t_payment_function type_payment_function;
3075:
3076: /* Added as part of SEPA Changes v5.5 Bug 12801608*/

Line 3078: iby_payments_all.DELIVERY_CHANNEL_CODE%TYPE

3074: t_payment_function type_payment_function;
3075:
3076: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3077: TYPE type_delivery_channel IS TABLE OF
3078: iby_payments_all.DELIVERY_CHANNEL_CODE%TYPE
3079: INDEX BY BINARY_INTEGER;
3080: t_delivery_channel type_delivery_channel;
3081: /* End of SEPA Changes v5.5 Bug 12801608*/
3082: TYPE type_ext_payee_id IS TABLE OF

Line 3083: iby_payments_all.ext_payee_id%TYPE

3079: INDEX BY BINARY_INTEGER;
3080: t_delivery_channel type_delivery_channel;
3081: /* End of SEPA Changes v5.5 Bug 12801608*/
3082: TYPE type_ext_payee_id IS TABLE OF
3083: iby_payments_all.ext_payee_id%TYPE
3084: INDEX BY BINARY_INTEGER;
3085: t_ext_payee_id type_ext_payee_id;
3086:
3087: TYPE type_org_id IS TABLE OF

Line 3088: iby_payments_all.org_id%TYPE

3084: INDEX BY BINARY_INTEGER;
3085: t_ext_payee_id type_ext_payee_id;
3086:
3087: TYPE type_org_id IS TABLE OF
3088: iby_payments_all.org_id%TYPE
3089: INDEX BY BINARY_INTEGER;
3090: t_org_id type_org_id;
3091:
3092: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;

Line 3109: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;

3105: /* End of SEPA Changes v5.5 Bug 12801608*/
3106:
3107: l_first_group_by VARCHAR2(1);
3108:
3109: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
3110: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
3111: prev_payment_date iby_payments_all.payment_date%TYPE;
3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
3113:

Line 3110: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;

3106:
3107: l_first_group_by VARCHAR2(1);
3108:
3109: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
3110: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
3111: prev_payment_date iby_payments_all.payment_date%TYPE;
3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
3113:
3114: /*Added as part of SEPA Changes Bug 9437357 */

Line 3111: prev_payment_date iby_payments_all.payment_date%TYPE;

3107: l_first_group_by VARCHAR2(1);
3108:
3109: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
3110: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
3111: prev_payment_date iby_payments_all.payment_date%TYPE;
3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
3113:
3114: /*Added as part of SEPA Changes Bug 9437357 */
3115: prev_payment_currency_code iby_payments_all.payment_currency_code%TYPE;

Line 3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;

3108:
3109: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
3110: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
3111: prev_payment_date iby_payments_all.payment_date%TYPE;
3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
3113:
3114: /*Added as part of SEPA Changes Bug 9437357 */
3115: prev_payment_currency_code iby_payments_all.payment_currency_code%TYPE;
3116: prev_settlement_priority iby_payments_all.settlement_priority%TYPE;

Line 3115: prev_payment_currency_code iby_payments_all.payment_currency_code%TYPE;

3111: prev_payment_date iby_payments_all.payment_date%TYPE;
3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
3113:
3114: /*Added as part of SEPA Changes Bug 9437357 */
3115: prev_payment_currency_code iby_payments_all.payment_currency_code%TYPE;
3116: prev_settlement_priority iby_payments_all.settlement_priority%TYPE;
3117: prev_payment_function iby_payments_all.payment_function%TYPE;
3118:
3119: /* Added as part of SEPA Changes v5.5 Bug 12801608*/

Line 3116: prev_settlement_priority iby_payments_all.settlement_priority%TYPE;

3112: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
3113:
3114: /*Added as part of SEPA Changes Bug 9437357 */
3115: prev_payment_currency_code iby_payments_all.payment_currency_code%TYPE;
3116: prev_settlement_priority iby_payments_all.settlement_priority%TYPE;
3117: prev_payment_function iby_payments_all.payment_function%TYPE;
3118:
3119: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3120: prev_delivery_channel iby_payments_all.DELIVERY_CHANNEL_CODE%type;

Line 3117: prev_payment_function iby_payments_all.payment_function%TYPE;

3113:
3114: /*Added as part of SEPA Changes Bug 9437357 */
3115: prev_payment_currency_code iby_payments_all.payment_currency_code%TYPE;
3116: prev_settlement_priority iby_payments_all.settlement_priority%TYPE;
3117: prev_payment_function iby_payments_all.payment_function%TYPE;
3118:
3119: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3120: prev_delivery_channel iby_payments_all.DELIVERY_CHANNEL_CODE%type;
3121: /* End of SEPA Changes v5.5 Bug 12801608*/

Line 3120: prev_delivery_channel iby_payments_all.DELIVERY_CHANNEL_CODE%type;

3116: prev_settlement_priority iby_payments_all.settlement_priority%TYPE;
3117: prev_payment_function iby_payments_all.payment_function%TYPE;
3118:
3119: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3120: prev_delivery_channel iby_payments_all.DELIVERY_CHANNEL_CODE%type;
3121: /* End of SEPA Changes v5.5 Bug 12801608*/
3122: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;
3123:
3124:

Line 3122: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;

3118:
3119: /* Added as part of SEPA Changes v5.5 Bug 12801608*/
3120: prev_delivery_channel iby_payments_all.DELIVERY_CHANNEL_CODE%type;
3121: /* End of SEPA Changes v5.5 Bug 12801608*/
3122: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;
3123:
3124:
3125: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';
3126:

Line 3164: FROM IBY_PAYMENTS_ALL

3160: IF l_grouping_mode = 'SNGL' THEN
3161:
3162: SELECT PAYMENT_ID BULK COLLECT
3163: INTO t_payment_id
3164: FROM IBY_PAYMENTS_ALL
3165: WHERE PAYMENT_INSTRUCTION_ID = l_payment_instruction_id;
3166:
3167: FOR j in t_payment_id.FIRST .. t_payment_id.LAST
3168: LOOP

Line 3181: UPDATE IBY_PAYMENTS_ALL

3177:
3178: /* CHANGE FOR BUG : 14348326 - START */
3179: FORALL k IN t_payment_id.FIRST .. t_payment_id.LAST SAVE EXCEPTIONS
3180: /* CHANGE FOR BUG : 14348326 - END */
3181: UPDATE IBY_PAYMENTS_ALL
3182: SET LOGICAL_GROUP_REFERENCE = t_logical_group_reference(k)
3183: WHERE payment_id = t_payment_id(k) ;
3184:
3185: ELSIF l_grouping_mode = 'GRPD' THEN

Line 3194: UPDATE IBY_PAYMENTS_ALL

3190: print_debuginfo(l_module_name, 'logical_grp_ref: '
3191: || l_logical_group_reference );
3192:
3193: END IF;
3194: UPDATE IBY_PAYMENTS_ALL
3195: SET logical_group_reference = l_logical_group_reference
3196: WHERE payment_instruction_id = l_payment_instruction_id;
3197:
3198: ELSIF l_grouping_mode = 'MIXD' THEN

Line 3234: from_clause :=' FROM IBY_PAYMENTS_ALL';

3230: l_group_by_delivery_channel
3231: FROM IBY_PMT_LOGICAL_GRP_RULES
3232: WHERE SYSTEM_PROFILE_CODE = l_payment_profile_code;
3233:
3234: from_clause :=' FROM IBY_PAYMENTS_ALL';
3235: order_clause := ' ORDER BY ';
3236:
3237: l_first_group_by := 'Y';
3238:

Line 3417: UPDATE IBY_PAYMENTS_ALL

3413:
3414: /* CHANGE FOR BUG : 14348326 - START */
3415: FORALL j IN t_payment_id.FIRST .. t_payment_id.LAST SAVE EXCEPTIONS
3416: /* CHANGE FOR BUG : 14348326 - END */
3417: UPDATE IBY_PAYMENTS_ALL
3418: SET logical_group_reference = t_logical_group_reference(j)
3419: WHERE payment_id = t_payment_id(j);
3420:
3421: END IF;

Line 5683: * pmts -> IBY_PAYMENTS_ALL

5679: * ------------- --------------------
5680: * payee -> HZ_PARTIES
5681: * payee_location -> HZ_LOCATIONS
5682: * payee_bank -> IBY_EXT_BANK_ACCOUNTS_V
5683: * pmts -> IBY_PAYMENTS_ALL
5684: *
5685: * These aliased table names are used in
5686: * query to pick up the sorted payments
5687: * in getSortedPmtsForInstr().

Line 5945: CURSOR c_document_count(l_pmt_id iby_payments_all.payment_id%type)

5941:
5942: l_module_name VARCHAR2(200) := G_PKG_NAME || '.populateDocumentCount';
5943: l_docs_in_pmt_count docsInPmtCountTabType;
5944:
5945: CURSOR c_document_count(l_pmt_id iby_payments_all.payment_id%type)
5946: IS
5947: SELECT
5948: count(payment_id)
5949: FROM

Line 6352: IBY_PAYMENTS_ALL

6348:
6349: FOR i IN p_sortedPmtsTab.FIRST .. p_sortedPmtsTab.LAST LOOP
6350:
6351: UPDATE
6352: IBY_PAYMENTS_ALL
6353: SET
6354: payment_reference_number = p_sortedPmtsTab(i).payment_ref,
6355: document_category_code = p_sortedPmtsTab(i).doc_cat_code,
6356: document_sequence_id = p_sortedPmtsTab(i).sequence_id,

Line 6397: IBY_PAYMENTS_ALL

6393:
6394: FOR i IN p_sortedPmtsTab.FIRST .. p_sortedPmtsTab.LAST LOOP
6395:
6396: UPDATE
6397: IBY_PAYMENTS_ALL
6398: SET
6399: document_category_code = p_sortedPmtsTab(i).doc_cat_code,
6400: document_sequence_id = p_sortedPmtsTab(i).sequence_id,
6401: document_sequence_value = p_sortedPmtsTab(i).sequence_number

Line 6441: IBY_PAYMENTS_ALL

6437:
6438: FOR i IN p_sortedPmtsTab.FIRST .. p_sortedPmtsTab.LAST LOOP
6439:
6440: UPDATE
6441: IBY_PAYMENTS_ALL
6442: SET
6443: payment_reference_number = p_sortedPmtsTab(i).payment_ref
6444: WHERE
6445: payment_id = p_sortedPmtsTab(i).payment_id

Line 6474: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,

6470: *---------------------------------------------------------------------*/
6471: PROCEDURE deriveDistinctAccessTypsForIns(
6472: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
6473: %TYPE,
6474: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
6475: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
6476: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
6477: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
6478: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab

Line 6475: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,

6471: PROCEDURE deriveDistinctAccessTypsForIns(
6472: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
6473: %TYPE,
6474: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
6475: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
6476: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
6477: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
6478: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
6479: )

Line 6476: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,

6472: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
6473: %TYPE,
6474: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
6475: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
6476: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
6477: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
6478: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
6479: )
6480: IS

Line 6768: IBY_PAYMENTS_ALL

6764: document_sequence_value
6765: INTO
6766: l_seq_num
6767: FROM
6768: IBY_PAYMENTS_ALL
6769: WHERE
6770: payment_instruction_id = p_instr_id AND
6771: ROWNUM = 1
6772: ;

Line 6874: IBY_PAYMENTS_ALL

6870: payment_reference_number
6871: INTO
6872: l_pmt_ref
6873: FROM
6874: IBY_PAYMENTS_ALL
6875: WHERE
6876: payment_instruction_id = p_instr_id AND
6877: ROWNUM = 1
6878: ;

Line 7021: || 'IBY_PAYMENTS_ALL pmt, '

7017: || 'NULL, ' /* ledger id */
7018: || 'NULL, ' /* sequence number */
7019: || 'NULL ' /* sequence id */
7020: || 'FROM '
7021: || 'IBY_PAYMENTS_ALL pmt, '
7022: || 'IBY_PAY_SERVICE_REQUESTS req, '
7023: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
7024: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
7025: || 'HZ_PARTIES payee, '

Line 7060: || 'IBY_PAYMENTS_ALL pmt, '

7056: || 'NULL, ' /* ledger id */
7057: || 'NULL, ' /* sequence number */
7058: || 'NULL ' /* sequence id */
7059: || 'FROM '
7060: || 'IBY_PAYMENTS_ALL pmt, '
7061: || 'IBY_PAY_SERVICE_REQUESTS req, '
7062: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
7063: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
7064: || 'HZ_PARTIES payee '