1429: wo_factor number := 0;
1430: BEGIN
1431: SELECT (inv.amount/invorg.amount)
1432: INTO wo_factor
1433: FROM pa_draft_invoice_items invorg,
1434: pa_draft_invoice_items inv
1435: WHERE inv.project_id = x_project_id
1436: AND inv.draft_invoice_num = x_di_num
1437: AND inv.line_num = 1
1430: BEGIN
1431: SELECT (inv.amount/invorg.amount)
1432: INTO wo_factor
1433: FROM pa_draft_invoice_items invorg,
1434: pa_draft_invoice_items inv
1435: WHERE inv.project_id = x_project_id
1436: AND inv.draft_invoice_num = x_di_num
1437: AND inv.line_num = 1
1438: AND invorg.project_id = inv.project_id
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'
1502: AND mii.set_of_books_id = x_sob_id