APPS.PA_MCB_INVOICE_PKG dependencies on PA_CUST_REV_DIST_LINES

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

1873:
1874: /* Commented and rewritten for bug 4735682
1875: UPDATE pa_draft_invoice_items dii
1876: SET dii.inv_amount =
1877: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl
1878: WHERE rdl.project_id = dii.project_id
1879: AND rdl.draft_invoice_num = dii.draft_invoice_num
1880: AND rdl.draft_invoice_item_line_num = dii.line_num)
1881: WHERE dii.project_id = p_project_id

Line 1890: FROM pa_cust_rev_dist_lines_all rdl

1886: /* Select query for bug 4735682 brought out to comply with 8i.. bug 4995695 */
1887:
1888: SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) * l_head_inv_exch_rate
1889: INTO l_calc_inv_amount
1890: FROM pa_cust_rev_dist_lines_all rdl
1891: WHERE rdl.project_id = p_project_id
1892: AND rdl.draft_invoice_num = inv_num_cached
1893: AND rdl.draft_invoice_item_line_num = cm_rec.line_num;
1894:

Line 2053: UPDATE pa_cust_rev_dist_lines

2049: /* Added for bug 3144517.Fix is similar to that in 2870248 */
2050:
2051: IF TmpInvLines(k).event_num =0 THEN
2052: --Update the RDLS
2053: UPDATE pa_cust_rev_dist_lines
2054: SET draft_invoice_item_line_num = TmpInvLines(k).current_line_num+1000000
2055: WHERE project_id = p_project_id
2056: AND request_id = p_request_id
2057: AND draft_invoice_num = TmpInvLines(k).current_draft_invoice_num

Line 2104: UPDATE pa_cust_rev_dist_lines

2100:
2101: /*fix for bug 3144517 */
2102: IF TmpInvLines(k).event_num =0 THEN
2103: --Update the RDLS
2104: UPDATE pa_cust_rev_dist_lines
2105: SET draft_invoice_num = TmpInvLines(k).new_draft_invoice_num,
2106: draft_invoice_item_line_num = TmpInvLines(k).new_line_num
2107: WHERE project_id = p_project_id
2108: AND request_id = p_request_id