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 1232: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/

1228: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1229: ) AS
1230:
1231: /* Bug 2680486 -- Performance changes -- To avoid Non-mergable view issue,
1232: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/
1233:
1234: CURSOR cur_pa_tasks_sub
1235: IS
1236: SELECT PT.CARRYING_OUT_ORGANIZATION_ID

Line 1244: ,PA_WORK_TYPES_TL PWT

1240: ,PT.SERVICE_TYPE_CODE
1241: ,PL.MEANING SERVICE_TYPE_NAME
1242: FROM PA_TASKS PT
1243: ,HR_ORGANIZATION_UNITS HOU
1244: ,PA_WORK_TYPES_TL PWT
1245: ,PA_LOOKUPS PL
1246: WHERE PT.TASK_ID = p_task_id
1247: AND PT.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1248: AND PT.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)

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

1357: x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1358: ) AS
1359:
1360: /* Bug 2680486 -- Performance changes -- To avoid Non-mergable view issue,
1361: Changed PA_WORK_TYPES_VL to PA_WORK_TYPES_TL and added condition for userenev('lang')*/
1362:
1363: -- MOAC Changes: Bug 4363092: removed nvl with org_id
1364: CURSOR cur_pa_project
1365: IS

Line 1374: ,PA_WORK_TYPES_TL PWT

1370: ,PPT.SERVICE_TYPE_CODE
1371: ,PL.MEANING SERVICE_TYPE_NAME
1372: FROM PA_PROJECTS_ALL PPA
1373: ,HR_ORGANIZATION_UNITS HOU
1374: ,PA_WORK_TYPES_TL PWT
1375: ,PA_LOOKUPS PL
1376: ,PA_PROJECT_TYPES_ALL PPT
1377: WHERE PPA.PROJECT_ID = p_project_id
1378: AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID