DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_MC_DRAFT_INV_ITEMS

Line 1221: FROM pa_mc_draft_inv_items

1217: BEGIN
1218:
1219: SELECT sum(nvl(amount,0))
1220: INTO inv_amt
1221: FROM pa_mc_draft_inv_items
1222: WHERE project_id = x_project_id
1223: AND draft_invoice_num = x_di_num
1224: AND line_num = x_line_num
1225: AND set_of_books_id = x_sob;

Line 1497: FROM pa_mc_draft_inv_items mii,

1493: rtn_amount NUMBER := 0;
1494: BEGIN
1495: SELECT sum(mii.amount)
1496: INTO rtn_amount
1497: FROM pa_mc_draft_inv_items mii,
1498: pa_draft_invoice_items ii
1499: WHERE ii.project_id = x_project_id
1500: AND ii.draft_invoice_num = x_di_num
1501: AND ii.invoice_line_type <> 'RETENTION'