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_PROJECTS_MAINT_PVT dependencies on PA_LOOKUPS

Line 169: , pa_lookups lps

165: CURSOR l_get_prj_class_code
166: IS
167: select meaning
168: from pa_project_types pt
169: , pa_lookups lps
170: , pa_projects pp
171: where pt.project_type = pp.project_type
172: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
173: and lps.lookup_code(+) = pt.project_type_class_code

Line 1165: FROM pa_lookups

1161: l_old_organization_id NUMBER;
1162: cursor get_batch_name_csr
1163: IS
1164: SELECT meaning
1165: FROM pa_lookups
1166: WHERE lookup_type = 'TRANSLATION'
1167: AND lookup_code = 'MANUAL';
1168:
1169: cursor get_batch_desc_csr

Line 1172: FROM pa_lookups

1168:
1169: cursor get_batch_desc_csr
1170: IS
1171: SELECT meaning
1172: FROM pa_lookups
1173: WHERE lookup_type = 'TRANSLATION'
1174: AND lookup_code = 'MASS_UPDATE_BATCH_DESC';
1175:
1176: CURSOR l_project_details_csr

Line 4964: , pa_lookups lps

4960: -- MOAC Changes: Bug 4363092 - removed nvl used with org_id
4961: select meaning
4962: into t_project_type_class_code
4963: from pa_project_types_all pt -- Bug#3807805 : Modifed pa_project_types to pa_project_types_all
4964: , pa_lookups lps
4965: where pt.project_type = p_project_type
4966: and lps.lookup_type(+) = 'PROJECT TYPE CLASS'
4967: and lps.lookup_code(+) = pt.project_type_class_code
4968: and pt.org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805