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.PQH_PQIPED7_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 228: FROM HR_ALL_ORGANIZATION_UNITS

224: AND ASS.JOB_ID = JOB.JOB_ID
225: AND ASS.ASSIGNMENT_TYPE = 'E'
226: AND ASS.ORGANIZATION_ID IN
227: (SELECT ORGANIZATION_ID
228: FROM HR_ALL_ORGANIZATION_UNITS
229: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
230: ;
231: /*Commenting for the bug#7033011
232:

Line 298: FROM HR_ALL_ORGANIZATION_UNITS

294: AND ASS.JOB_ID = JOB.JOB_ID
295: AND ASS.ASSIGNMENT_TYPE = 'E'
296: AND ASS.ORGANIZATION_ID IN
297: (SELECT ORGANIZATION_ID
298: FROM HR_ALL_ORGANIZATION_UNITS
299: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
300: ;
301: */
302: CURSOR GET_LINE2_COUNTS IS

Line 380: FROM HR_ALL_ORGANIZATION_UNITS

376: AND ASS.JOB_ID = JOB.JOB_ID
377: AND ASS.ASSIGNMENT_TYPE = 'E'
378: AND ASS.ORGANIZATION_ID IN
379: (SELECT ORGANIZATION_ID
380: FROM HR_ALL_ORGANIZATION_UNITS
381: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
382: GROUP BY HL.LOOKUP_CODE;
383:
384:

Line 452: FROM HR_ALL_ORGANIZATION_UNITS

448: AND ASS.JOB_ID = JOB.JOB_ID
449: AND ASS.ASSIGNMENT_TYPE = 'E'
450: AND ASS.ORGANIZATION_ID IN
451: (SELECT ORGANIZATION_ID
452: FROM HR_ALL_ORGANIZATION_UNITS
453: WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID)
454: AND HL.LOOKUP_CODE = C_LOOKUP_CODE;
455: */
456: