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 647: from hr_organization_units hou

643:
644: CURSOR c_tax_unit_name IS
645: select hou.name
646: ,hou.location_id
647: from hr_organization_units hou
648: where hou.business_group_id = P_BUSINESS_GROUP_ID
649: and hou.organization_id = TAX_UNIT_ID;
650:
651: BEGIN

Line 760: ,hr_organization_units hou

756: ,hr_organization_information hoi4
757: ,hr_organization_information hoi3
758: ,hr_organization_information hoi2
759: ,hr_organization_information hoi1
760: ,hr_organization_units hou
761: Where
762: pps.person_id = ppf.person_id
763:
764: And fnd_date.canonical_to_date(P_REPORT_DATE)

Line 815: ,hr_organization_units hou

811: ,hr_organization_information hoi4
812: ,hr_organization_information hoi3
813: ,hr_organization_information hoi2
814: ,hr_organization_information hoi1
815: ,hr_organization_units hou
816: Where
817: pps.person_id = ppf.person_id
818:
819: And fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1149: , hr_organization_units hou

1145: FROM
1146: hr_organization_information hoi3
1147: , hr_organization_information hoi2
1148: , hr_organization_information hoi1
1149: , hr_organization_units hou
1150: WHERE
1151: hou.business_group_id = P_BUSINESS_GROUP_ID
1152: AND hoi1.organization_id = hou.organization_id
1153: AND hoi1.org_information_context = 'CLASS'

Line 1168: , hr_organization_units hou

1164: SELECT
1165: count(hou.organization_id)
1166: FROM
1167: hr_organization_information hoi3
1168: , hr_organization_units hou
1169: WHERE
1170: hou.business_group_id = P_BUSINESS_GROUP_ID
1171: AND hoi3.organization_id = hou.organization_id
1172: AND hoi3.org_information_context = 'New Hire Reporting'

Line 1190: ,hr_organization_units hou

1186: ,hr_organization_information hoi4
1187: ,hr_organization_information hoi3
1188: ,hr_organization_information hoi2
1189: ,hr_organization_information hoi1
1190: ,hr_organization_units hou
1191:
1192: Where
1193: pps.person_id = ppf.person_id
1194: And fnd_date.canonical_to_date(P_REPORT_DATE)

Line 1244: ,hr_organization_units hou

1240: ,hr_organization_information hoi4
1241: ,hr_organization_information hoi3
1242: ,hr_organization_information hoi2
1243: ,hr_organization_information hoi1
1244: ,hr_organization_units hou
1245:
1246: Where
1247: pps.person_id = ppf.person_id
1248:

Line 1561: FROM hr_organization_units hou

1557: And fnd_date.canonical_to_date(P_REPORT_DATE)
1558: between paf.effective_start_date and paf.effective_end_date
1559: And hscf.segment1 in
1560: (SELECT to_char(hou.organization_id )
1561: FROM hr_organization_units hou
1562: WHERE hou.business_group_id = P_BUSINESS_GROUP_ID
1563: )
1564: And paf.soft_coding_keyflex_id = hscf.soft_coding_keyflex_id
1565: And paf.assignment_type = 'E'

Line 1611: FROM hr_organization_units hou

1607: )
1608: And pps.date_start = paf.effective_start_date
1609: And hscf.segment1 in
1610: (SELECT to_char(hou.organization_id )
1611: FROM hr_organization_units hou
1612: WHERE hou.business_group_id = P_BUSINESS_GROUP_ID
1613: )
1614: And paf.soft_coding_keyflex_id = hscf.soft_coding_keyflex_id
1615: And paf.assignment_type = 'E'