DBA Data[Home] [Help]

APPS.AR_CREDIT_MEMO_API_PUB dependencies on AR_LOOKUPS

Line 544: ar_lookups

540: count(*)
541: INTO
542: l_count_reason_code
543: FROM
544: ar_lookups
545: WHERE lookup_type ='CREDIT_MEMO_REASON'
546: AND lookup_code = p_cm_reason_code ;
547:
548: IF l_count_reason_code = 0 THEN

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

864: p_data => x_msg_data);
865: END;
866:
867: IF PG_DEBUG in ('Y', 'C') THEN
868: arp_util.debug ('get_request_status: ' || 'Selecting the meaning for the credit memo dispute from ar_lookups');
869: END IF;
870: SELECT meaning
871: INTO x_reason_meaning
872: FROM ar_lookups

Line 872: FROM ar_lookups

868: arp_util.debug ('get_request_status: ' || 'Selecting the meaning for the credit memo dispute from ar_lookups');
869: END IF;
870: SELECT meaning
871: INTO x_reason_meaning
872: FROM ar_lookups
873: WHERE lookup_type='CREDIT_MEMO_REASON'
874: AND lookup_code = l_reason_code;
875:
876: IF PG_DEBUG in ('Y', 'C') THEN