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

Line 191: FROM hr_organization_units o1

187: hoi2.ORG_INFORMATION3,
188: hoi2.ORG_INFORMATION4,
189: hoi2.ORG_INFORMATION5,
190: hoi2.ORG_INFORMATION8
191: FROM hr_organization_units o1
192: , hr_organization_information hoi1
193: , hr_organization_information hoi2
194: WHERE o1.business_group_id =g_business_group_id
195: AND hoi1.organization_id = o1.organization_id

Line 211: FROM hr_organization_units o1

207: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE
208: )
209: IS
210: SELECT o1.NAME
211: FROM hr_organization_units o1
212: , hr_organization_information hoi1
213: WHERE o1.business_group_id =g_business_group_id
214: AND hoi1.organization_id = o1.organization_id
215: AND hoi1.organization_id = csr_v_pension_provider_id

Line 227: FROM hr_organization_units o1

223: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE
224: )
225: IS
226: SELECT o1.NAME,hoi2.ORG_INFORMATION2
227: FROM hr_organization_units o1
228: , hr_organization_information hoi1
229: , hr_organization_information hoi2
230: WHERE o1.business_group_id =g_business_group_id
231: AND hoi1.organization_id = o1.organization_id

Line 246: FROM hr_organization_units o1

242: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE
243: )
244: IS
245: SELECT hoi2.ORG_INFORMATION3
246: FROM hr_organization_units o1
247: , hr_organization_information hoi1
248: , hr_organization_information hoi2
249: WHERE o1.business_group_id =g_business_group_id
250: AND hoi1.organization_id = o1.organization_id

Line 263: FROM hr_organization_units o1

259: -- Cursor to pick up Local Unit Details
260: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
261: IS
262: SELECT o1.name , hoi2.ORG_INFORMATION1
263: FROM hr_organization_units o1
264: , hr_organization_information hoi1
265: , hr_organization_information hoi2
266: WHERE o1.business_group_id =g_business_group_id
267: AND hoi1.organization_id = o1.organization_id

Line 282: FROM hr_organization_units hou_le,

278: IS
279: SELECT hoi_le.org_information1 local_unit_id,
280: hou_lu.NAME local_unit_name,
281: hoi_lu.org_information1
282: FROM hr_organization_units hou_le,
283: hr_organization_information hoi_le,
284: hr_organization_units hou_lu,
285: hr_organization_information hoi_lu
286: WHERE hoi_le.organization_id = hou_le.organization_id

Line 284: hr_organization_units hou_lu,

280: hou_lu.NAME local_unit_name,
281: hoi_lu.org_information1
282: FROM hr_organization_units hou_le,
283: hr_organization_information hoi_le,
284: hr_organization_units hou_lu,
285: hr_organization_information hoi_lu
286: WHERE hoi_le.organization_id = hou_le.organization_id
287: AND hou_le.organization_id = csr_v_legal_employer_id
288: AND hoi_le.org_information_context = 'FI_LOCAL_UNITS'

Line 298: FROM hr_organization_units o1

294: csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE
295: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE)
296: IS
297: SELECT hoi2.ORG_INFORMATION2
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id =l_business_group_id
302: AND hoi1.organization_id = o1.organization_id

Line 1104: FROM hr_organization_units o1

1100: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE
1101: ,csr_v_effective_date DATE )
1102: IS
1103: SELECT hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION8, hoi2.ORG_INFORMATION10
1104: FROM hr_organization_units o1
1105: , hr_organization_information hoi1
1106: , hr_organization_information hoi2
1107: WHERE o1.business_group_id =g_business_group_id
1108: AND hoi1.organization_id = o1.organization_id

Line 1167: FROM hr_organization_units o1

1163: -- Cursor to pick up Local Unit Details
1164: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)
1165: IS
1166: SELECT o1.name , hoi2.ORG_INFORMATION1
1167: FROM hr_organization_units o1
1168: , hr_organization_information hoi1
1169: , hr_organization_information hoi2
1170: WHERE o1.business_group_id =g_business_group_id
1171: AND hoi1.organization_id = o1.organization_id

Line 1233: FROM hr_organization_units o1

1229: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE
1230: )
1231: IS
1232: SELECT hoi2.ORG_INFORMATION3
1233: FROM hr_organization_units o1
1234: , hr_organization_information hoi1
1235: , hr_organization_information hoi2
1236: WHERE o1.business_group_id =g_business_group_id
1237: AND hoi1.organization_id = o1.organization_id