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_PURGE_VALIDATE_BILLING dependencies on PA_PROJECTS_ALL

Line 58: pa_projects_all pp,

54: /* select 'Not Revenue Distributed' , 'PA_ARPR_NOT_REV_DIST'
55: from dual
56: where exists ( select spf.project_id
57: from pa_summary_project_fundings spf,
58: pa_projects_all pp,
59: -- pa_project_types_all pt -- performance changes bug 2706550
60: pa_project_types_v pt -- Added to remove FTS bug 2706550
61: where
62: pp.project_id = p_project_id

Line 143: from pa_projects_all pp

139: UNION
140: select 'UBR and UER not cleared' , 'PA_ARPR_NOT_UBR_UER'
141: from dual
142: where exists ( select project_id
143: from pa_projects_all pp
144: where pp.project_id = p_project_id
145: and
146: (nvl(pp.unbilled_receivable_dr,0) <> 0
147: or