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.HR_AE_VALIDATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 185: FROM hr_organization_information hoi,

181:
182: DECLARE
183: CURSOR csr_get_loc_nat IS
184: SELECT org_information1
185: FROM hr_organization_information hoi,
186: per_person_types pty
187: WHERE pty.person_type_id = p_person_type_id
188: AND pty.business_group_id = hoi.organization_id
189: AND hoi.org_information_context = 'AE_BG_DETAILS';

Line 213: hr_organization_information hoi

209:
210: CURSOR csr_fetch_bg_id IS
211: SELECT distinct pty.business_group_id
212: FROM per_person_types pty,
213: hr_organization_information hoi
214: WHERE pty.person_type_id = p_person_type_id
215: AND pty.business_group_id = hoi.organization_id;
216:
217: CURSOR csr_val_mar_status (l_bg_id NUMBER) IS