APPS.ARP_CORRECT_CC_ERRORS dependencies on ARPT_SQL_FUNC_UTIL

Line 566: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),

562: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
563: END IF;
564: SELECT NVL(trx.cc_error_code,'Unknown'),
565: NVL(trx.cc_error_text,'Unknown Error'),
566: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',p_cc_trx_category),
567: trx.trx_number,
568: trx.invoice_currency_code,
569: trx.trx_date,
570: party.party_name,

Line 2210: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',cr.type),

2206: END LOOP;
2207: /*Collect the info to pass to events */
2208: Select NVL(cr.cc_error_code,'Unknown'),
2209: NVL(cr.cc_error_text,'Unknown Error'),
2210: ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CC_TRX_CATEGORY',cr.type),
2211: cr.receipt_number,
2212: cr.currency_code,
2213: cr.amount,
2214: cr.receipt_date,