APPS.ARP_CORRECT_CC_ERRORS dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 347: FROM IBY_FNDCPT_TX_EXTENSIONS

343: BEGIN
344: arp_standard.debug( 'Checking for subsequent action code');
345:
346: SELECT INSTR_ASSIGNMENT_ID INTO l_instr_assignment_id
347: FROM IBY_FNDCPT_TX_EXTENSIONS
348: WHERE TRXN_EXTENSION_ID = p_payment_trxn_extension_id;
349:
350: SELECT 1
351: INTO l_dummy_number

Line 354: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b

350: SELECT 1
351: INTO l_dummy_number
352: FROM dual
353: WHERE NOT EXISTS ( SELECT 1
354: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b
355: WHERE cc.cc_trx_id = p_cc_trx_id
356: AND cc.cc_trx_category = p_cc_trx_category
357: AND cc.payment_trxn_extension_id = b.trxn_extension_id
358: AND b.instr_assignment_id = l_instr_assignment_id

Line 381: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b

377: BEGIN
378: arp_standard.debug( 'Checking if it is first time error');
379: SELECT cc.cc_error_date
380: INTO l_first_cc_error_date
381: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b
382: WHERE cc.cc_trx_id = p_cc_trx_id
383: AND cc.cc_trx_category = p_cc_trx_category
384: AND cc.payment_trxn_extension_id = b.trxn_extension_id
385: AND b.instr_assignment_id = l_instr_assignment_id

Line 2144: IBY_FNDCPT_TX_EXTENSIONS B,

2140: l_instrument_assignment_id,
2141: l_payment_channel,
2142: l_receipt_number
2143: FROM
2144: IBY_FNDCPT_TX_EXTENSIONS B,
2145: IBY_EXTERNAL_PAYERS_ALL P,
2146: IBY_PMT_INSTR_USES_ALL U,
2147: AR_CASH_RECEIPTS CR
2148: WHERE B.TRXN_EXTENSION_ID = p_payment_trxn_extension_id