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 957: hr_organization_information hoi,

953: (
954: --***** start new code for Bug 5089488**************
955: select hoi.ORG_INFORMATION5
956: from hr_organization_units hou,
957: hr_organization_information hoi,
958: hr_organization_information hoi2
959: where hou.business_group_id = p_business_group_id
960: and hou.organization_id = hoi.organization_id
961: and hoi.organization_id = hoi2.organization_id

Line 958: hr_organization_information hoi2

954: --***** start new code for Bug 5089488**************
955: select hoi.ORG_INFORMATION5
956: from hr_organization_units hou,
957: hr_organization_information hoi,
958: hr_organization_information hoi2
959: where hou.business_group_id = p_business_group_id
960: and hou.organization_id = hoi.organization_id
961: and hoi.organization_id = hoi2.organization_id
962: and hoi.org_information_context = 'Business Group Information'

Line 1045: hr_organization_information hoi,

1041: (
1042: --***** start new code for Bug 5089488**************
1043: select hoi.ORG_INFORMATION4
1044: from hr_organization_units hou,
1045: hr_organization_information hoi,
1046: hr_organization_information hoi2
1047: where hou.business_group_id = p_business_group_id
1048: and hou.organization_id = hoi.organization_id
1049: and hoi.organization_id = hoi2.organization_id

Line 1046: hr_organization_information hoi2

1042: --***** start new code for Bug 5089488**************
1043: select hoi.ORG_INFORMATION4
1044: from hr_organization_units hou,
1045: hr_organization_information hoi,
1046: hr_organization_information hoi2
1047: where hou.business_group_id = p_business_group_id
1048: and hou.organization_id = hoi.organization_id
1049: and hoi.organization_id = hoi2.organization_id
1050: and hoi.org_information_context = 'Business Group Information'