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 400: from hr_organization_units hoi,

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

Line 412: from hr_organization_units hoi,

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

Line 424: from hr_organization_units hoi,

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

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

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

Line 440: from hr_organization_units hoi,

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