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.PAY_US_TRR_ENGINE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 35: from hr_organization_units hoi,

31: */
32:
33: cursor gre_sizes_gre is
34: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
35: from hr_organization_units hoi,
36: hr_organization_information info
37: where hoi.organization_id = info.organization_id
38: and info.org_information_context = 'CLASS'
39: and info.org_information1 = 'HR_LEGAL'

Line 47: from hr_organization_units hoi,

43: order by count(*);
44:
45: cursor gre_sizes is
46: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
47: from hr_organization_units hoi,
48: hr_organization_information info
49: where hoi.organization_id = info.organization_id
50: and info.org_information_context = 'CLASS'
51: and info.org_information1 = 'HR_LEGAL'

Line 59: from hr_organization_units hoi,

55: order by count(*);
56:
57: cursor gre_sizes_gre_state is
58: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
59: from hr_organization_units hoi,
60: hr_organization_information info
61: where hoi.organization_id = info.organization_id
62: and info.org_information_context = 'CLASS'
63: and info.org_information1 = 'HR_LEGAL'

Line 73: select /+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) /

69: group by info.organization_id,hoi.name
70: order by count(*);
71:
72: cursor gre_sizes_state is
73: select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
74: count(*) gre_size,info.organization_id gre_id, hoi.name gre_name
75: from hr_organization_units hoi,
76: hr_organization_information info
77: where hoi.organization_id = info.organization_id

Line 75: from hr_organization_units hoi,

71:
72: cursor gre_sizes_state is
73: select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
74: count(*) gre_size,info.organization_id gre_id, hoi.name gre_name
75: from hr_organization_units hoi,
76: hr_organization_information info
77: where hoi.organization_id = info.organization_id
78: and info.org_information_context = 'CLASS'
79: and info.org_information1 = 'HR_LEGAL'

Line 398: from hr_organization_units hoi,

394: */
395:
396: cursor gre_sizes_gre is
397: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
398: from hr_organization_units hoi,
399: hr_organization_information info
400: where hoi.organization_id = info.organization_id
401: and info.org_information_context = 'CLASS'
402: and info.org_information1 = 'HR_LEGAL'

Line 410: from hr_organization_units hoi,

406: order by count(*);
407:
408: cursor gre_sizes is
409: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
410: from hr_organization_units hoi,
411: hr_organization_information info
412: where hoi.organization_id = info.organization_id
413: and info.org_information_context = 'CLASS'
414: and info.org_information1 = 'HR_LEGAL'

Line 422: from hr_organization_units hoi,

418: order by count(*);
419:
420: cursor gre_sizes_gre_juri(cv_jurisdiction varchar2) is
421: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
422: from hr_organization_units hoi,
423: hr_organization_information info
424: where hoi.organization_id = info.organization_id
425: and info.org_information_context = 'CLASS'
426: and info.org_information1 = 'HR_LEGAL'

Line 436: select /+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) /

432: group by info.organization_id,hoi.name
433: order by count(*);
434:
435: cursor gre_sizes_juri(cv_jurisdiction varchar2) is
436: select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
437: count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
438: from hr_organization_units hoi,
439: hr_organization_information info
440: where hoi.organization_id = info.organization_id

Line 438: from hr_organization_units hoi,

434:
435: cursor gre_sizes_juri(cv_jurisdiction varchar2) is
436: select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
437: count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
438: from hr_organization_units hoi,
439: hr_organization_information info
440: where hoi.organization_id = info.organization_id
441: and info.org_information_context = 'CLASS'
442: and info.org_information1 = 'HR_LEGAL'