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_FI_ARCHIVE_UMFR dependencies on HR_ORGANIZATION_UNITS

Line 254: FROM hr_organization_information hoi, hr_organization_units hou

250: csr_v_trade_union_id hr_organization_information.organization_id%TYPE
251: )
252: IS
253: SELECT hou.NAME, hoi.org_information1, hoi.org_information5
254: FROM hr_organization_information hoi, hr_organization_units hou
255: WHERE org_information_context = 'FI_TRADE_UNION_DETAILS'
256: AND hou.organization_id = csr_v_trade_union_id
257: AND hoi.organization_id = hou.organization_id;
258:

Line 266: FROM hr_organization_information hoi, hr_organization_units hou

262: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE
263: )
264: IS
265: SELECT hou.NAME, hoi.org_information1, hoi.org_information8
266: FROM hr_organization_information hoi, hr_organization_units hou
267: WHERE org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS'
268: AND hoi.organization_id = hou.organization_id
269: AND hou.organization_id = csr_v_legal_employer_id;
270:

Line 281: FROM hr_organization_units hou_le,

277: SELECT hoi_le.org_information1 local_unit_id,
278: hou_lu.NAME local_unit_name,
279: hoi_lu.org_information1 y_spare_number,
280: hoi_lu.org_information2 local_unit_number
281: FROM hr_organization_units hou_le,
282: hr_organization_information hoi_le,
283: hr_organization_units hou_lu,
284: hr_organization_information hoi_lu
285: WHERE hoi_le.organization_id = hou_le.organization_id

Line 283: hr_organization_units hou_lu,

279: hoi_lu.org_information1 y_spare_number,
280: hoi_lu.org_information2 local_unit_number
281: FROM hr_organization_units hou_le,
282: hr_organization_information hoi_le,
283: hr_organization_units hou_lu,
284: hr_organization_information hoi_lu
285: WHERE hoi_le.organization_id = hou_le.organization_id
286: AND hou_le.organization_id = csr_v_legal_employer_id
287: AND hoi_le.org_information_context = 'FI_LOCAL_UNITS'

Line 300: FROM hr_organization_information hoi, hr_organization_units hou

296: )
297: IS
298: SELECT hou.NAME, hoi.org_information1 y_spare_number,
299: hoi.org_information2 local_unit_number
300: FROM hr_organization_information hoi, hr_organization_units hou
301: WHERE org_information_context = 'FI_LOCAL_UNIT_DETAILS'
302: AND hoi.organization_id = hou.organization_id
303: AND hou.organization_id = csr_v_local_unit_id;
304: