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.XLE_BUSINESSINFO_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 645: hr_organization_information o2,

641:
642: cursor OperUnit_c is
643: SELECT o.organization_id operating_unit_id
644: FROM hr_all_organization_units o,
645: hr_organization_information o2,
646: hr_organization_information o3
647: WHERE o.organization_id = o2.organization_id
648: AND o.organization_id = o3.organization_id
649: AND o2.org_information_context || '' = 'CLASS'

Line 646: hr_organization_information o3

642: cursor OperUnit_c is
643: SELECT o.organization_id operating_unit_id
644: FROM hr_all_organization_units o,
645: hr_organization_information o2,
646: hr_organization_information o3
647: WHERE o.organization_id = o2.organization_id
648: AND o.organization_id = o3.organization_id
649: AND o2.org_information_context || '' = 'CLASS'
650: AND o3.org_information_context = 'Operating Unit Information'

Line 683: hr_organization_information o2,

679:
680: SELECT DISTINCT o3.org_information3
681: INTO l_ledger_id
682: FROM hr_all_organization_units o,
683: hr_organization_information o2,
684: hr_organization_information o3
685: WHERE o.organization_id = o2.organization_id
686: AND o.organization_id = o3.organization_id
687: AND o3.organization_id = o2.organization_id

Line 684: hr_organization_information o3

680: SELECT DISTINCT o3.org_information3
681: INTO l_ledger_id
682: FROM hr_all_organization_units o,
683: hr_organization_information o2,
684: hr_organization_information o3
685: WHERE o.organization_id = o2.organization_id
686: AND o.organization_id = o3.organization_id
687: AND o3.organization_id = o2.organization_id
688: AND o2.org_information_context || '' = 'CLASS'

Line 895: HR_ORGANIZATION_INFORMATION HOI1,

891: /* The following cursor selects legal entity information related to a organization*/
892: cursor org_c is
893: SELECT DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION2), null) LEGAL_ENTITY
894: FROM HR_ORGANIZATION_UNITS HoU,
895: HR_ORGANIZATION_INFORMATION HOI1,
896: HR_ORGANIZATION_INFORMATION HOI2
897: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
898: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
899: AND HOI1.ORG_INFORMATION1 = 'INV'

Line 896: HR_ORGANIZATION_INFORMATION HOI2

892: cursor org_c is
893: SELECT DECODE(HOI2.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI2.ORG_INFORMATION2), null) LEGAL_ENTITY
894: FROM HR_ORGANIZATION_UNITS HoU,
895: HR_ORGANIZATION_INFORMATION HOI1,
896: HR_ORGANIZATION_INFORMATION HOI2
897: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
898: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
899: AND HOI1.ORG_INFORMATION1 = 'INV'
900: AND HOI1.ORG_INFORMATION2 = 'Y'

Line 1157: hr_organization_information o2,

1153:
1154: SELECT o3.org_information3
1155: INTO l_ledger_id
1156: FROM hr_all_organization_units o,
1157: hr_organization_information o2,
1158: hr_organization_information o3
1159: WHERE o.organization_id = o2.organization_id
1160: AND o.organization_id = o3.organization_id
1161: AND o3.organization_id = o2.organization_id

Line 1158: hr_organization_information o3

1154: SELECT o3.org_information3
1155: INTO l_ledger_id
1156: FROM hr_all_organization_units o,
1157: hr_organization_information o2,
1158: hr_organization_information o3
1159: WHERE o.organization_id = o2.organization_id
1160: AND o.organization_id = o3.organization_id
1161: AND o3.organization_id = o2.organization_id
1162: AND o2.org_information_context || '' = 'CLASS'