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 624: from pa_draft_invoices_all di, pa_projects_all pa

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

Line 818: UPDATE pa_draft_invoices_all di1

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