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_UBR_UER_SUMM_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 622: from pa_draft_invoices_all di, pa_projects_all pa

618: di.gl_date) gl_period_name ,
619: di.unbilled_receivable_dr ubr_amount,
620: di.unearned_revenue_cr uer_amount,
621: 'U' ins_upd_flag
622: from pa_draft_invoices_all di, pa_projects_all pa
623: where pa.org_id = G_org_id
624: and di.project_id = pa.project_id
625: and di.transfer_status_code = 'A'
626: and di.gl_date <= G_p_gl_end_date

Line 816: UPDATE pa_draft_invoices_all di1

812:
813: -- pa_debug.write_file('LEV2:After Summary Processing ');
814:
815: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
816: UPDATE pa_draft_invoices_all di1
817: SET ( di1.request_id,di1.ubr_uer_process_flag , di1.ubr_summary_id ,di1.uer_summary_id )
818: = ( select G_p_request_id,'Y',temp1.ubr_summary_id, temp1.uer_summary_id
819: from pa_draft_rev_inv_temp temp1
820: where temp1.project_id = di1.project_id