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_INVOICES_ALL

Line 79: pa_draft_invoices_all di

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
83: AND di.agreement_id = p_agreement_id

Line 94: pa_draft_invoices_all di

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
98: AND dii.invoice_line_type <> 'RETENTION'