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_PROJECT_TYPES

Line 59: -- pa_project_types_all pt -- performance changes bug 2706550

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
63: and pp.project_type = pt.project_type

Line 60: pa_project_types_v pt -- Added to remove FTS bug 2706550

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
63: and pp.project_type = pt.project_type
64: and pt.project_type_class_code = 'CONTRACT'

Line 190: from pa_projects pp, pa_project_types pt

186: UNION
187: select 'This is an Inter Company Billing Project', 'PA_ARPR_IC_BILLING_PROJ'
188: from dual
189: where exists ( select null
190: from pa_projects pp, pa_project_types pt
191: where pp.project_id = p_project_id
192: and pp.project_type = pt.project_type
193: and pt.project_type_class_code = 'CONTRACT'
194: and pt.cc_prvdr_flag = 'Y'