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

Line 198: FROM hr_organization_units hou

194: /* Cursor to fetch the Legal Employer Details */
195: CURSOR csr_get_le_details(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
196: SELECT hou.name NAME
197: , hoi.org_information1 ORGANIZATION_NO
198: FROM hr_organization_units hou
199: ,hr_organization_information hoi
200: WHERE hou.business_group_id = p_business_group_id
201: and hoi.organization_id = hou.organization_id
202: and hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'

Line 360: FROM HR_ORGANIZATION_UNITS hou

356: /* Cursor to fetch local units for a Legal Employer */
357: CURSOR csr_get_lu_le (p_le_id NUMBER
358: ,p_bg_id NUMBER) IS
359: SELECT to_number(hoi.ORG_INFORMATION1) lu_id
360: FROM HR_ORGANIZATION_UNITS hou
361: , HR_ORGANIZATION_INFORMATION hoi
362: WHERE hou.business_group_id = p_bg_id
363: AND hou.organization_id = p_le_id
364: AND hoi.ORG_INFORMATION_CONTEXT='NO_LOCAL_UNITS'