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.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 149: FROM hr_all_organization_units org

145: SELECT org.organization_id legal_employer_id
146: ,org.name
147: ,hoi1.org_information2
148: ,org.location_id
149: FROM hr_all_organization_units org
150: ,hr_organization_information hoi1
151: WHERE org.organization_id = p_legal_employer_id
152: AND hoi1.organization_id (+) = org.organization_id
153: AND hoi1.org_information_context (+) = 'SE_LEGAL_EMPLOYER_DETAILS';

Line 410: FROM hr_all_organization_units hou_le,

406: SELECT hoi_le.org_information1 local_unit_id,
407: hou_lu.NAME local_unit_name,
408: hoi_lu.org_information1,
409: hou_lu.location_id
410: FROM hr_all_organization_units hou_le,
411: hr_organization_information hoi_le,
412: hr_all_organization_units hou_lu,
413: hr_organization_information hoi_lu
414: WHERE hoi_le.organization_id = hou_le.organization_id

Line 412: hr_all_organization_units hou_lu,

408: hoi_lu.org_information1,
409: hou_lu.location_id
410: FROM hr_all_organization_units hou_le,
411: hr_organization_information hoi_le,
412: hr_all_organization_units hou_lu,
413: hr_organization_information hoi_lu
414: WHERE hoi_le.organization_id = hou_le.organization_id
415: AND hou_le.organization_id = p_legal_employer_id
416: AND hoi_le.org_information_context = 'SE_LOCAL_UNITS'