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

Line 453: hr_organization_information hoi,

449: (
450: --***** Start new code for Bug 5089488**************
451: select hoi.ORG_INFORMATION5
452: from hr_organization_units hou,
453: hr_organization_information hoi,
454: hr_organization_information hoi2
455: where hou.business_group_id = p_business_group_id
456: and hou.organization_id = hoi.organization_id
457: and hoi.organization_id = hoi2.organization_id

Line 454: hr_organization_information hoi2

450: --***** Start new code for Bug 5089488**************
451: select hoi.ORG_INFORMATION5
452: from hr_organization_units hou,
453: hr_organization_information hoi,
454: hr_organization_information hoi2
455: where hou.business_group_id = p_business_group_id
456: and hou.organization_id = hoi.organization_id
457: and hoi.organization_id = hoi2.organization_id
458: and hoi.org_information_context = 'Business Group Information'

Line 533: hr_organization_information hoi,

529: (
530: --***** start new code for Bug 5089488**************
531: select hoi.ORG_INFORMATION4
532: from hr_organization_units hou,
533: hr_organization_information hoi,
534: hr_organization_information hoi2
535: where hou.business_group_id = p_business_group_id
536: and hou.organization_id = hoi.organization_id
537: and hoi.organization_id = hoi2.organization_id

Line 534: hr_organization_information hoi2

530: --***** start new code for Bug 5089488**************
531: select hoi.ORG_INFORMATION4
532: from hr_organization_units hou,
533: hr_organization_information hoi,
534: hr_organization_information hoi2
535: where hou.business_group_id = p_business_group_id
536: and hou.organization_id = hoi.organization_id
537: and hoi.organization_id = hoi2.organization_id
538: and hoi.org_information_context = 'Business Group Information'

Line 950: hr_organization_information hoi,

946: (
947: --***** start new code for Bug 5089488**************
948: select hoi.ORG_INFORMATION5
949: from hr_organization_units hou,
950: hr_organization_information hoi,
951: hr_organization_information hoi2
952: where hou.business_group_id = p_business_group_id
953: and hou.organization_id = hoi.organization_id
954: and hoi.organization_id = hoi2.organization_id

Line 951: hr_organization_information hoi2

947: --***** start new code for Bug 5089488**************
948: select hoi.ORG_INFORMATION5
949: from hr_organization_units hou,
950: hr_organization_information hoi,
951: hr_organization_information hoi2
952: where hou.business_group_id = p_business_group_id
953: and hou.organization_id = hoi.organization_id
954: and hoi.organization_id = hoi2.organization_id
955: and hoi.org_information_context = 'Business Group Information'

Line 1038: hr_organization_information hoi,

1034: (
1035: --***** start new code for Bug 5089488**************
1036: select hoi.ORG_INFORMATION4
1037: from hr_organization_units hou,
1038: hr_organization_information hoi,
1039: hr_organization_information hoi2
1040: where hou.business_group_id = p_business_group_id
1041: and hou.organization_id = hoi.organization_id
1042: and hoi.organization_id = hoi2.organization_id

Line 1039: hr_organization_information hoi2

1035: --***** start new code for Bug 5089488**************
1036: select hoi.ORG_INFORMATION4
1037: from hr_organization_units hou,
1038: hr_organization_information hoi,
1039: hr_organization_information hoi2
1040: where hou.business_group_id = p_business_group_id
1041: and hou.organization_id = hoi.organization_id
1042: and hoi.organization_id = hoi2.organization_id
1043: and hoi.org_information_context = 'Business Group Information'