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.PER_IE_ORG_INFO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 14: hr_all_organization_units hou

10:
11: CURSOR get_unique is
12: SELECT 'x', hoi.org_information2
13: FROM hr_organization_information hoi,
14: hr_all_organization_units hou
15: WHERE hoi.org_information_context ='IE_ORG_INFORMATION'
16: AND hou.organization_id = hoi.organization_id
17: AND hoi.org_information2 = p_org_information2
18: AND hou.business_group_id =p_business_group_id

Line 63: hr_all_organization_units hou

59:
60: CURSOR get_unique is
61: SELECT 'x', hoi.org_information2
62: FROM hr_organization_information hoi,
63: hr_all_organization_units hou
64: WHERE hoi.org_information_context ='IE_EMPLOYER_INFO'
65: AND hou.organization_id = hoi.organization_id
66: AND hoi.org_information2 = p_org_information2
67: AND hou.business_group_id =p_business_group_id

Line 179: from hr_all_organization_units

175: ) is
176:
177: CURSOR get_business_group is
178: SELECT business_group_id
179: from hr_all_organization_units
180: where organization_id=p_organization_id;
181:
182: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
183: BEGIN

Line 182: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

178: SELECT business_group_id
179: from hr_all_organization_units
180: where organization_id=p_organization_id;
181:
182: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
183: BEGIN
184:
185: /* Added for GSI Bug 5472781 */
186: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN

Line 221: from hr_all_organization_units hou,hr_organization_information hoi

217: ) is
218:
219: CURSOR get_business_group is
220: SELECT business_group_id
221: from hr_all_organization_units hou,hr_organization_information hoi
222: where hoi.org_information_id=p_org_information_id
223: and hoi.organization_id=hou.organization_id;
224:
225: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

Line 225: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

221: from hr_all_organization_units hou,hr_organization_information hoi
222: where hoi.org_information_id=p_org_information_id
223: and hoi.organization_id=hou.organization_id;
224:
225: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
226: BEGIN
227:
228: /* Added for GSI Bug 5472781 */
229: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN

Line 274: from hr_all_organization_units

270:
271: is
272: CURSOR get_business_group is
273: SELECT business_group_id
274: from hr_all_organization_units
275: where organization_id=p_organization_id;
276:
277: cursor csr_chk_er_change(p_payroll_id number,
278: p_segment4 varchar2,

Line 315: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;
312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
313: l_person_id per_all_people_f.person_id%type;
314: l_assignment_id per_all_assignments_f.assignment_id%type;
315: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
316: l_er_exists number;
317:
318: BEGIN
319: