APPS.IBY_MERGE dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 315: | Account merge procedure for the table, IBY_FNDCPT_TX_EXTENSIONS

311: |
312: | PROCEDURE
313: | TRANSACTIONS_EXT_MERGE
314: | DESCRIPTION :
315: | Account merge procedure for the table, IBY_FNDCPT_TX_EXTENSIONS
316: |--------------------------------------------------------------*/
317:
318: PROCEDURE TRANSACTIONS_EXT_MERGE
319: (

Line 330: UPDATE IBY_FNDCPT_TX_EXTENSIONS DUP

326: */
327:
328: iby_debug_pub.Add('Updating the instrument Assignment Id...');
329: FORALL i in 1..ext_payer_from_list.COUNT
330: UPDATE IBY_FNDCPT_TX_EXTENSIONS DUP
331: SET instr_assignment_id =
332: (SELECT to_instr.instrument_payment_use_id FROM
333: iby_pmt_instr_uses_all from_inst,
334: iby_pmt_instr_uses_all to_instr

Line 373: UPDATE iby_fndcpt_tx_extensions dup

369: /* For credit cards we need to check the Hashcodes. Same hashcodes mean the same instrument*/
370: /*
371: iby_debug_pub.Add('Modifying instrument use id for credit cards');
372: FORALL i in 1..ext_payer_from_list.COUNT
373: UPDATE iby_fndcpt_tx_extensions dup
374: SET instr_assignment_id =
375: (SELECT to_uses.instrument_payment_use_id FROM
376: iby_pmt_instr_uses_all from_uses,
377: iby_pmt_instr_uses_all to_uses,

Line 425: UPDATE iby_fndcpt_tx_extensions dup

421: /* For Bank Accounts we need to check the Hashcodes. Same hashcodes mean the same instrument*/
422: /*
423: iby_debug_pub.Add('Modifying instrument use id for bank accounts');
424: FORALL i in 1..ext_payer_from_list.COUNT
425: UPDATE iby_fndcpt_tx_extensions dup
426: SET instr_assignment_id =
427: (SELECT to_uses.instrument_payment_use_id FROM
428: iby_pmt_instr_uses_all from_uses,
429: iby_pmt_instr_uses_all to_uses,

Line 477: UPDATE iby_fndcpt_tx_extensions dup

473:
474: /* Update the Payer with the new value */
475: iby_debug_pub.Add('Modifying the Payer value');
476: FORALL i in 1..ext_payer_from_list.COUNT
477: UPDATE iby_fndcpt_tx_extensions dup
478: SET ext_payer_id = ext_payer_to_list(i)
479: WHERE ext_payer_id = ext_payer_from_list(i)
480: AND ext_payer_from_list(i) IS NOT NULL
481: AND ext_payer_to_list(i) IS NOT NULL