eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_MC_CURRENCY_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 1433: FROM pa_draft_invoice_items invorg,

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

Line 1434: pa_draft_invoice_items inv

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

Line 1498: pa_draft_invoice_items ii

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