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_TASKS_MAINT_UTILS dependencies on PA_WORK_TYPES_TL

Line 1283: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/

1279: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1280: ) AS
1281:
1282: /* Bug 2680486 -- Performance changes -- To avoid Non-mergable view issue,
1283: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/
1284:
1285: CURSOR cur_pa_tasks_sub
1286: IS
1287: SELECT PT.CARRYING_OUT_ORGANIZATION_ID

Line 1295: ,PA_WORK_TYPES_TL PWT

1291: ,PT.SERVICE_TYPE_CODE
1292: ,PL.MEANING SERVICE_TYPE_NAME
1293: FROM PA_TASKS PT
1294: ,HR_ORGANIZATION_UNITS HOU
1295: ,PA_WORK_TYPES_TL PWT
1296: ,PA_LOOKUPS PL
1297: WHERE PT.TASK_ID = p_task_id
1298: AND PT.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1299: AND PT.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)

Line 1412: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/

1408: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1409: ) AS
1410:
1411: /* Bug 2680486 -- Performance changes -- To avoid Non-mergable view issue,
1412: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/
1413:
1414: -- MOAC Changes: Bug 4363092: removed nvl with org_id
1415: CURSOR cur_pa_project
1416: IS

Line 1425: ,PA_WORK_TYPES_TL PWT

1421: ,PPT.SERVICE_TYPE_CODE
1422: ,PL.MEANING SERVICE_TYPE_NAME
1423: FROM PA_PROJECTS_ALL PPA
1424: ,HR_ORGANIZATION_UNITS HOU
1425: ,PA_WORK_TYPES_TL PWT
1426: ,PA_LOOKUPS PL
1427: ,PA_PROJECT_TYPES_ALL PPT
1428: WHERE PPA.PROJECT_ID = p_project_id
1429: AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID