DBA Data[Home] [Help]

APPS.ARP_PROCESS_PAYINFO dependencies on RA_INTERFACE_LINES

Line 298: UPDATE ra_interface_lines il

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

Line 409: FROM RA_INTERFACE_LINES_GT L,

405: 'VALIDATE_EXT_ID:NO_MSG'
406: END,
407: L.PAYMENT_TRXN_EXTENSION_ID,
408: L.ORG_ID
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