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_EFC_BIL dependencies on PA_DRAFT_INVOICE_ITEMS

Line 78: FROM pa_draft_invoice_items dii,

74: -- get the total accrued revenue for project level funding
75:
76: SELECT sum(dii.amount) dii_amount
77: INTO pl_billed
78: FROM pa_draft_invoice_items dii,
79: pa_draft_invoices_all di
80: WHERE dii.project_id = di.project_id
81: AND dii.draft_invoice_num = di.draft_invoice_num
82: AND di.project_id = p_project_id

Line 93: FROM pa_draft_invoice_items dii,

89:
90: SELECT round(sum(dii.amount * (1 -
91: ( nvl(di.retention_percentage,0)/100 )) ),2) dii_amount
92: INTO pl_billed
93: FROM pa_draft_invoice_items dii,
94: pa_draft_invoices_all di
95: WHERE dii.project_id = di.project_id
96: AND dii.draft_invoice_num = di.draft_invoice_num
97: AND dii.task_id = p_task_id