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

Line 49: FROM hr_organization_information inf

45: -- Cursor to return the current named hierarchy.
46: --
47: CURSOR c_hierarchy(p_organization_id NUMBER) IS
48: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
49: FROM hr_organization_information inf
50: ,hr_all_organization_units org
51: WHERE org.organization_id = p_organization_id
52: AND inf.organization_id = org.business_group_id
53: AND inf.org_information_context = 'SA_HR_BG_INFO'

Line 166: hr_organization_information hoi1,

162: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
163: p_bus_group_id hr_organization_units.organization_id%TYPE) is
164: select hou.name
165: from hr_organization_units hou,
166: hr_organization_information hoi1,
167: hr_organization_information hoi2
168: where (hou.business_group_id= p_bus_group_id
169: OR (hou.business_group_id=hou.organization_id and
170: hou.business_group_id <> p_bus_group_id )) and

Line 167: hr_organization_information hoi2

163: p_bus_group_id hr_organization_units.organization_id%TYPE) is
164: select hou.name
165: from hr_organization_units hou,
166: hr_organization_information hoi1,
167: hr_organization_information hoi2
168: where (hou.business_group_id= p_bus_group_id
169: OR (hou.business_group_id=hou.organization_id and
170: hou.business_group_id <> p_bus_group_id )) and
171: trunc(sysdate) between hou.date_from and nvl(hou.date_to,

Line 211: hr_organization_information hoi1,

207: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
208: p_bus_group_id hr_organization_units.organization_id%TYPE) is
209: select hou.name
210: from hr_organization_units hou,
211: hr_organization_information hoi1,
212: hr_organization_information hoi2
213: where (hou.business_group_id= p_bus_group_id
214: OR (hou.business_group_id=hou.organization_id and
215: hou.business_group_id <> p_bus_group_id )) and

Line 212: hr_organization_information hoi2

208: p_bus_group_id hr_organization_units.organization_id%TYPE) is
209: select hou.name
210: from hr_organization_units hou,
211: hr_organization_information hoi1,
212: hr_organization_information hoi2
213: where (hou.business_group_id= p_bus_group_id
214: OR (hou.business_group_id=hou.organization_id and
215: hou.business_group_id <> p_bus_group_id )) and
216: trunc(sysdate) between hou.date_from and nvl(hou.date_to,

Line 253: hr_organization_information hoi1,

249: cursor csr_employer (p_organization_id hr_organization_units.organization_id%TYPE,
250: p_bus_group_id hr_organization_units.organization_id%TYPE) is
251: select hou.name
252: from hr_organization_units hou,
253: hr_organization_information hoi1,
254: hr_organization_information hoi2
255: where (hou.business_group_id= p_bus_group_id
256: OR (hou.business_group_id=hou.organization_id and
257: hou.business_group_id <> p_bus_group_id )) and

Line 254: hr_organization_information hoi2

250: p_bus_group_id hr_organization_units.organization_id%TYPE) is
251: select hou.name
252: from hr_organization_units hou,
253: hr_organization_information hoi1,
254: hr_organization_information hoi2
255: where (hou.business_group_id= p_bus_group_id
256: OR (hou.business_group_id=hou.organization_id and
257: hou.business_group_id <> p_bus_group_id )) and
258: trunc(sysdate) between hou.date_from and nvl(hou.date_to,