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

Line 655: from hr_organization_units hou

651:
652: CURSOR c_tax_unit_name IS
653: select hou.name
654: ,hou.location_id
655: from hr_organization_units hou
656: where hou.business_group_id = P_BUSINESS_GROUP_ID
657: and hou.organization_id = TAX_UNIT_ID;
658:
659: BEGIN

Line 768: ,hr_organization_units hou

764: ,hr_organization_information hoi4
765: ,hr_organization_information hoi3
766: ,hr_organization_information hoi2
767: ,hr_organization_information hoi1
768: ,hr_organization_units hou
769: Where
770: pps.person_id = ppf.person_id
771:
772: And fnd_date.canonical_to_date(P_REPORT_DATE)

Line 823: ,hr_organization_units hou

819: ,hr_organization_information hoi4
820: ,hr_organization_information hoi3
821: ,hr_organization_information hoi2
822: ,hr_organization_information hoi1
823: ,hr_organization_units hou
824: Where
825: pps.person_id = ppf.person_id
826:
827: And fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1157: , hr_organization_units hou

1153: FROM
1154: hr_organization_information hoi3
1155: , hr_organization_information hoi2
1156: , hr_organization_information hoi1
1157: , hr_organization_units hou
1158: WHERE
1159: hou.business_group_id = P_BUSINESS_GROUP_ID
1160: AND hoi1.organization_id = hou.organization_id
1161: AND hoi1.org_information_context = 'CLASS'

Line 1176: , hr_organization_units hou

1172: SELECT
1173: count(hou.organization_id)
1174: FROM
1175: hr_organization_information hoi3
1176: , hr_organization_units hou
1177: WHERE
1178: hou.business_group_id = P_BUSINESS_GROUP_ID
1179: AND hoi3.organization_id = hou.organization_id
1180: AND hoi3.org_information_context = 'New Hire Reporting'

Line 1198: ,hr_organization_units hou

1194: ,hr_organization_information hoi4
1195: ,hr_organization_information hoi3
1196: ,hr_organization_information hoi2
1197: ,hr_organization_information hoi1
1198: ,hr_organization_units hou
1199:
1200: Where
1201: pps.person_id = ppf.person_id
1202: And fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1252: ,hr_organization_units hou

1248: ,hr_organization_information hoi4
1249: ,hr_organization_information hoi3
1250: ,hr_organization_information hoi2
1251: ,hr_organization_information hoi1
1252: ,hr_organization_units hou
1253:
1254: Where
1255: pps.person_id = ppf.person_id
1256:

Line 1569: FROM hr_organization_units hou

1565: And fnd_date.canonical_to_date(P_REPORT_DATE)
1566: between paf.effective_start_date and paf.effective_end_date
1567: And hscf.segment1 in
1568: (SELECT to_char(hou.organization_id )
1569: FROM hr_organization_units hou
1570: WHERE hou.business_group_id = P_BUSINESS_GROUP_ID
1571: )
1572: And paf.soft_coding_keyflex_id = hscf.soft_coding_keyflex_id
1573: And paf.assignment_type = 'E'

Line 1619: FROM hr_organization_units hou

1615: )
1616: And pps.date_start = paf.effective_start_date
1617: And hscf.segment1 in
1618: (SELECT to_char(hou.organization_id )
1619: FROM hr_organization_units hou
1620: WHERE hou.business_group_id = P_BUSINESS_GROUP_ID
1621: )
1622: And paf.soft_coding_keyflex_id = hscf.soft_coding_keyflex_id
1623: And paf.assignment_type = 'E'