APPS.AR_CREDIT_MEMO_API_PUB dependencies on AR_LOOKUPS

Line 587: ar_lookups

583: count(*)
584: INTO
585: l_count_reason_code
586: FROM
587: ar_lookups
588: WHERE lookup_type ='CREDIT_MEMO_REASON'
589: AND lookup_code = p_cm_reason_code ;
590:
591: IF l_count_reason_code = 0 THEN

Line 911: arp_util.debug ('get_request_status: ' || 'Selecting the meaning for the credit memo dispute from ar_lookups');

907: p_data => x_msg_data);
908: END;
909:
910: IF PG_DEBUG in ('Y', 'C') THEN
911: arp_util.debug ('get_request_status: ' || 'Selecting the meaning for the credit memo dispute from ar_lookups');
912: END IF;
913: SELECT meaning
914: INTO x_reason_meaning
915: FROM ar_lookups

Line 915: FROM ar_lookups

911: arp_util.debug ('get_request_status: ' || 'Selecting the meaning for the credit memo dispute from ar_lookups');
912: END IF;
913: SELECT meaning
914: INTO x_reason_meaning
915: FROM ar_lookups
916: WHERE lookup_type='CREDIT_MEMO_REASON'
917: AND lookup_code = l_reason_code;
918:
919: IF PG_DEBUG in ('Y', 'C') THEN