APPS.PA_MC_CURRENCY_PKG dependencies on PA_MC_DRAFT_INV_DETAILS_ALL

Line 1262: FROM pa_mc_draft_inv_details_all mcdii ,

1258: AND set_of_books_id = x_sob;
1259:
1260: SELECT sum(nvl(mcdii.bill_amount,0))
1261: INTO ic_rdl_amt
1262: FROM pa_mc_draft_inv_details_all mcdii ,
1263: pa_draft_invoice_details_all dii
1264: WHERE dii.project_id = x_project_id
1265: AND dii.draft_invoice_num = x_di_num
1266: AND dii.draft_invoice_line_num = x_line_num

Line 2030: FROM pa_mc_draft_inv_details_all

2026: SELECT SUM(bill_amount),
2027: Min(acct_exchange_rate),
2028: Min(acct_rate_type),
2029: Min(acct_rate_date)
2030: FROM pa_mc_draft_inv_details_all
2031: WHERE set_of_books_id = x_set_of_books_id
2032: AND draft_invoice_detail_id in
2033: (select draft_invoice_detail_id
2034: from pa_draft_invoice_details_all

Line 2044: x_err_stage := ' Select from pa_mc_draft_inv_details_all';

2040:
2041: l_old_stack := x_err_stack;
2042: x_err_code := 0;
2043: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_invdtl_tp_amts';
2044: x_err_stage := ' Select from pa_mc_draft_inv_details_all';
2045: x_transfer_price := NULL;
2046:
2047: OPEN C_TP_REC;
2048: