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

Line 10: from hr_organization_information org, per_all_people_f p

6:
7: cursor get_NIE_value is
8: select per_information2 identifier_type,
9: per_information3 identifier_value
10: from hr_organization_information org, per_all_people_f p
11: where p.person_id = p_person_id
12: and org.organization_id = p.business_group_id
13: and org.org_information_context = 'Business Group Information'
14: and org.org_information9 = 'ES';

Line 53: from hr_organization_information org, per_all_people_f p

49: where person_id = p_person_id ;
50:
51: CURSOR get_legislation_code IS
52: select org_information9
53: from hr_organization_information org, per_all_people_f p
54: where org.org_information_context = 'Business Group Information'
55: and org.organization_id = p.business_group_id
56: and p.person_id = p_person_id ;
57: