DBA Data[Home] [Help]

APPS.ARP_PROCESS_PAYINFO dependencies on RA_INTERFACE_LINES

Line 301: UPDATE ra_interface_lines il

297: -- Update transaction header with payment attributes for grouping
298: --
299: /* 7039838 - replaced hint for FT performance tuning initialitive */
300:
301: UPDATE ra_interface_lines il
302: SET payment_attributes =
303: (SELECT
304: CASE
305: WHEN authorized_flag = 'Y' THEN

Line 412: FROM RA_INTERFACE_LINES_GT L,

408: 'VALIDATE_EXT_ID:NO_MSG'
409: END,
410: L.PAYMENT_TRXN_EXTENSION_ID,
411: L.ORG_ID
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