APPS.ARP_PROCESS_PAYINFO dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 312: FROM iby_fndcpt_tx_extensions ext,

308: END
309: ELSE
310: 'NO-AUTH~' || ext.instr_assignment_id || '~'
311: END
312: FROM iby_fndcpt_tx_extensions ext,
313: (SELECT /*+ leading(op) use_nl(summ,seft,ueft) */
314: op.trxn_extension_id,
315: decode(decode(summ.status, 0, 'Y', 100, 'Y', NULL), 'N', 'Y') authorized_flag,
316: nvl(seft.settle_require_vrfy_flag, 'N') settle_req_auth_flag

Line 413: IBY_FNDCPT_TX_EXTENSIONS X

409: FROM RA_INTERFACE_LINES_GT L,
410: AR_RECEIPT_METHODS rm,
411: AR_RECEIPT_CLASSES rc,
412: IBY_FNDCPT_PMT_CHNNLS_B P,
413: IBY_FNDCPT_TX_EXTENSIONS X
414: WHERE L.REQUEST_ID = fnd_global.conc_request_id
415: AND L.CUSTOMER_TRX_ID IS NOT NULL
416: AND NVL(L.INTERFACE_STATUS, '~') <> 'P'
417: AND l.receipt_method_id = rm.receipt_method_id (+)