APPS.AR_CREDIT_MEMO_API_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 568: FROM ra_customer_trx_lines

564: FOR i in 1..p_cm_line_tbl.count
565: LOOP
566: SELECT count(*)
567: INTO l_count_trx
568: FROM ra_customer_trx_lines
569: WHERE customer_trx_id = p_customer_trx_id
570: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
571:
572: IF l_count_trx = 0 THEN

Line 606: FROM ra_customer_trx_lines

602: END IF;
603: -- Get the extended amount for the customer_trx_line_id
604: SELECT NVL(extended_amount,0)
605: INTO l_extended_amount
606: FROM ra_customer_trx_lines
607: WHERE customer_trx_id = p_customer_trx_id
608: AND customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
609:
610: -- Get the credited amount, if any, for this customer_trx_line

Line 613: FROM ra_customer_trx_lines

609:
610: -- Get the credited amount, if any, for this customer_trx_line
611: SELECT NVL(extended_amount,0)
612: INTO l_credited_amount
613: FROM ra_customer_trx_lines
614: WHERE previous_customer_trx_id = p_customer_trx_id
615: AND previous_customer_trx_line_id = p_cm_line_tbl(i).customer_trx_line_id;
616:
617: IF p_cm_line_tbl(i).extended_amount > (l_extended_amount - l_credited_amount) THEN

Line 1163: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',

1159: p_desc_flex_rec.attribute15:=p_cm_line_tbl(i).attribute15;
1160:
1161: arp_util.Validate_Desc_Flexfield(
1162: p_desc_flex_rec => p_desc_flex_rec,
1163: p_desc_flex_name => 'RA_CUSTOMER_TRX_LINES',
1164: p_return_status => x_return_status );
1165:
1166: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1167: THEN