APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 823: FROM ra_cust_trx_line_gl_dist rctl

819: l_line_counter := 0;
820: l_dist_counter := 0;
821:
822: FOR inv_dist_rec IN (SELECT *
823: FROM ra_cust_trx_line_gl_dist rctl
824: WHERE rctl.customer_trx_id = p_parent_invoice_id
825: AND rctl.customer_trx_line_id IS NULL) LOOP
826: l_dist_counter := l_dist_counter + 1;
827: l_trx_dist_tbl(l_dist_counter).trx_header_id := 1;

Line 894: FROM ra_cust_trx_line_gl_dist rctl

890: debug (l_module_name,'** LINES END **');
891: END IF;
892:
893: FOR inv_dist_rec IN (SELECT *
894: FROM ra_cust_trx_line_gl_dist rctl
895: WHERE rctl.customer_trx_id = p_parent_invoice_id
896: AND rctl.customer_trx_line_id = inv_lines_rec.customer_trx_line_id) LOOP
897: l_dist_counter := l_dist_counter + 1;
898: IF (fnd_log.level_statement >= g_CURRENT_LOG_LEVEL) THEN

Line 955: FROM ra_cust_trx_line_gl_dist rctl

951: END IF;
952:
953: SELECT SUM(amount)
954: INTO l_total_line_amount
955: FROM ra_cust_trx_line_gl_dist rctl
956: WHERE rctl.customer_trx_id = p_parent_invoice_id
957: AND rctl.customer_trx_line_id IS NOT NULL;
958:
959:

Line 963: FROM ra_cust_trx_line_gl_dist rctl

959:
960: FOR inv_dist_rec IN (SELECT code_combination_id,
961: sum (amount) amount,
962: ROUND(sum (amount)/l_total_line_amount, 4) percent
963: FROM ra_cust_trx_line_gl_dist rctl
964: WHERE rctl.customer_trx_id = p_parent_invoice_id
965: AND rctl.customer_trx_line_id IS NOT NULL
966: GROUP BY code_combination_id
967: ORDER BY code_combination_id) LOOP