APPS.ARP_PROCESS_PAYINFO dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 315: FROM iby_fndcpt_tx_extensions ext,

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

Line 416: IBY_FNDCPT_TX_EXTENSIONS X

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