APPS.AR_CREDIT_MEMO_API_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 611: FROM ra_customer_trx_lines

607: FOR i in 1..p_cm_line_tbl.count
608: LOOP
609: SELECT count(*)
610: INTO l_count_trx
611: FROM ra_customer_trx_lines
612: WHERE customer_trx_id = p_customer_trx_id
613: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
614:
615: IF l_count_trx = 0 THEN

Line 649: FROM ra_customer_trx_lines

645: END IF;
646: -- Get the extended amount for the customer_trx_line_id
647: SELECT NVL(extended_amount,0)
648: INTO l_extended_amount
649: FROM ra_customer_trx_lines
650: WHERE customer_trx_id = p_customer_trx_id
651: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
652:
653: -- Get the credited amount, if any, for this customer_trx_line

Line 656: FROM ra_customer_trx_lines

652:
653: -- Get the credited amount, if any, for this customer_trx_line
654: SELECT NVL(extended_amount,0)
655: INTO l_credited_amount
656: FROM ra_customer_trx_lines
657: WHERE previous_customer_trx_id = p_customer_trx_id
658: AND previous_customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
659:
660: IF p_cm_line_tbl(i).extended_amount > (l_extended_amount - l_credited_amount) THEN

Line 1237: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',

1233: p_desc_flex_rec.attribute15:=p_cm_line_tbl(i).attribute15;
1234:
1235: arp_util.Validate_Desc_Flexfield(
1236: p_desc_flex_rec => p_desc_flex_rec,
1237: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1238: p_return_status => x_return_status );
1239:
1240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1241: THEN