[Home] [Help]
761: SELECT customer_trx_line_id,
762: extended_amount,
763: quantity,
764: price
765: FROM ra_cm_request_lines_all
766: WHERE request_id = p_request_id;
767:
768: line_det_rec line_det_cur%rowtype;
769:
940:
941: IF p_line_credits_flag = 'Y' THEN
942: SELECT count(*)
943: INTO l_line_count
944: FROM ra_cm_request_lines
945: WHERE request_id = p_request_id;
946:
947: OPEN line_det_cur;
948: FOR i in 1..(l_line_count)