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 258: from pa_draft_revenues_all dr, pa_projects_all pa

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

Line 462: UPDATE pa_draft_revenues_all dr1

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