APPS.PA_MCB_INVOICE_PKG dependencies on PA_CUST_REV_DIST_LINES

Line 1869: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl

1865:
1866: /* Commented and rewritten for bug 4735682
1867: UPDATE pa_draft_invoice_items dii
1868: SET dii.inv_amount =
1869: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl
1870: WHERE rdl.project_id = dii.project_id
1871: AND rdl.draft_invoice_num = dii.draft_invoice_num
1872: AND rdl.draft_invoice_item_line_num = dii.line_num)
1873: WHERE dii.project_id = p_project_id

Line 1882: FROM pa_cust_rev_dist_lines_all rdl

1878: /* Select query for bug 4735682 brought out to comply with 8i.. bug 4995695 */
1879:
1880: SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) * l_head_inv_exch_rate
1881: INTO l_calc_inv_amount
1882: FROM pa_cust_rev_dist_lines_all rdl
1883: WHERE rdl.project_id = p_project_id
1884: AND rdl.draft_invoice_num = inv_num_cached
1885: AND rdl.draft_invoice_item_line_num = cm_rec.line_num;
1886:

Line 2045: UPDATE pa_cust_rev_dist_lines

2041: /* Added for bug 3144517.Fix is similar to that in 2870248 */
2042:
2043: IF TmpInvLines(k).event_num =0 THEN
2044: --Update the RDLS
2045: UPDATE pa_cust_rev_dist_lines
2046: SET draft_invoice_item_line_num = TmpInvLines(k).current_line_num+1000000
2047: WHERE project_id = p_project_id
2048: AND request_id = p_request_id
2049: AND draft_invoice_num = TmpInvLines(k).current_draft_invoice_num

Line 2096: UPDATE pa_cust_rev_dist_lines

2092:
2093: /*fix for bug 3144517 */
2094: IF TmpInvLines(k).event_num =0 THEN
2095: --Update the RDLS
2096: UPDATE pa_cust_rev_dist_lines
2097: SET draft_invoice_num = TmpInvLines(k).new_draft_invoice_num,
2098: draft_invoice_item_line_num = TmpInvLines(k).new_line_num
2099: WHERE project_id = p_project_id
2100: AND request_id = p_request_id