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_REVENUES_ALL

Line 260: from pa_draft_revenues_all dr, pa_projects_all pa

256: dr.gl_date) gl_period_name ,
257: dr.unbilled_receivable_dr ubr_amount,
258: dr.unearned_revenue_cr uer_amount,
259: 'U' ins_upd_flag
260: from pa_draft_revenues_all dr, pa_projects_all pa
261: where pa.org_id = G_org_id
262: and dr.project_id = pa.project_id
263: and dr.transfer_status_code = 'A'
264: and dr.gl_date <= G_p_gl_end_date

Line 464: UPDATE pa_draft_revenues_all dr1

460:
461: -- pa_debug.write_file('LEV2:After Summary Processing ');
462:
463: FORALL j IN l_project_id_arr.FIRST..l_project_id_arr.LAST
464: UPDATE pa_draft_revenues_all dr1
465: SET ( dr1.request_id,dr1.ubr_uer_process_flag , dr1.ubr_summary_id ,dr1.uer_summary_id )
466: = ( select G_p_request_id,'Y',temp1.ubr_summary_id, temp1.uer_summary_id
467: from pa_draft_rev_inv_temp temp1
468: where temp1.project_id = dr1.project_id