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_ZA_EMP201 dependencies on HR_ORGANIZATION_INFORMATION

Line 290: hr_organization_information hoi,

286: */
287: CURSOR get_legal_entity_name(p_organization_id number)IS
288: select haou.name
289: from hr_all_organization_units haou,
290: hr_organization_information hoi,
291: hr_organization_information hoi2
292: where haou.organization_id = p_organization_id
293: and hoi.organization_id = haou.organization_id
294: and hoi.org_information_context = 'ZA_LEGAL_ENTITY'

Line 291: hr_organization_information hoi2

287: CURSOR get_legal_entity_name(p_organization_id number)IS
288: select haou.name
289: from hr_all_organization_units haou,
290: hr_organization_information hoi,
291: hr_organization_information hoi2
292: where haou.organization_id = p_organization_id
293: and hoi.organization_id = haou.organization_id
294: and hoi.org_information_context = 'ZA_LEGAL_ENTITY'
295: and hoi2.organization_id = haou.organization_id

Line 706: , hr_organization_information hoi

702: cursor get_sdl_exemption (p_assignment_id number
703: , p_effective_date date) is
704: select decode(hoi.org_information1,'Exempt','E',nvl(aei.aei_information9,'N')) "Exemption"
705: from per_all_assignments_f ass
706: , hr_organization_information hoi
707: , per_assignment_extra_info aei
708: where ass.assignment_id = p_assignment_id
709: and p_effective_date between ass.effective_start_date and ass.effective_end_date
710: and ass.organization_id = hoi.organization_id