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_EXCEPTION_ENGINE_PKG dependencies on PA_PROJECT_STATUSES

Line 58: pa_project_statuses pps -- Added for Bug 4338924

54: SELECT DISTINCT ppa.project_id
55: FROM pa_projects_all ppa,
56: pa_project_parties ppp,
57: pa_project_types_all ppt,
58: pa_project_statuses pps -- Added for Bug 4338924
59: WHERE ppa.project_id = ppp.project_id
60: AND ppp.object_type = 'PA_PROJECTS'
61: AND ppa.project_status_code = pps.project_status_code -- Added for Bug 4338924
62: AND pps.status_type = 'PROJECT' -- Added for Bug 4338924

Line 86: pa_project_statuses pps -- Added for Bug 4338924

82: l_proj IN NUMBER) IS
83: SELECT distinct ppa.project_id
84: FROM pa_projects_all ppa,
85: pa_project_types_all ppt,
86: pa_project_statuses pps -- Added for Bug 4338924
87: WHERE ppa.carrying_out_organization_id = nvl(l_project_ou, ppa.carrying_out_organization_id)
88: AND ppa.org_id = nvl(l_project_org, ppa.org_id)
89: AND ppa.project_status_code = pps.project_status_code -- Added for Bug 4338924
90: AND pps.status_type = 'PROJECT' -- Added for Bug 4338924