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_INFORMATION

Line 182: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE

178:
179: -- Archiving the data , as this will fire once
180:
181: Cursor csr_pension_provider
182: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
183: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE
184: ,csr_v_effective_date DATE )
185: IS
186: SELECT o1.name,

Line 183: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE

179: -- Archiving the data , as this will fire once
180:
181: Cursor csr_pension_provider
182: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
183: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE
184: ,csr_v_effective_date DATE )
185: IS
186: SELECT o1.name,
187: hoi2.ORG_INFORMATION3,

Line 192: , hr_organization_information hoi1

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
196: AND hoi1.organization_id = csr_v_legal_emp_id

Line 193: , hr_organization_information hoi2

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
196: AND hoi1.organization_id = csr_v_legal_emp_id
197: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 207: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE

203:
204: lr_pension_provider csr_pension_provider%ROWTYPE;
205:
206: CURSOR csr_pension_provider_details (
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

Line 212: , hr_organization_information hoi1

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
216: AND hoi1.org_information_context = 'CLASS'

Line 223: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE

219: lr_pension_provider_details csr_pension_provider_details%ROWTYPE;
220:
221: /*
222: CURSOR csr_Pension_group_code (
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

Line 228: , hr_organization_information hoi1

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
232: AND hoi1.organization_id = csr_v_pension_provider_id

Line 229: , hr_organization_information hoi2

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
232: AND hoi1.organization_id = csr_v_pension_provider_id
233: AND hoi1.org_information_context = 'CLASS'

Line 242: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE

238:
239: Lr_Pension_group_code csr_Pension_group_code%ROWTYPE;
240:
241: CURSOR csr_Department_code (
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

Line 247: , hr_organization_information hoi1

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
251: AND hoi1.organization_id = csr_v_pension_provider_id

Line 248: , hr_organization_information hoi2

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
251: AND hoi1.organization_id = csr_v_pension_provider_id
252: AND hoi1.org_information_context = 'CLASS'

Line 260: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)

256:
257: lr_Department_code csr_Department_code%ROWTYPE;
258: */
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

Line 264: , hr_organization_information hoi1

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
268: AND hoi1.organization_id = csr_v_local_unit_id

Line 265: , hr_organization_information hoi2

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
268: AND hoi1.organization_id = csr_v_local_unit_id
269: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 277: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE )

273:
274: lr_Local_Unit_Details csr_Local_Unit_Details%rowtype;
275:
276: CURSOR csr_all_local_unit_details (
277: csr_v_legal_employer_id hr_organization_information.organization_id%TYPE )
278: IS
279: SELECT hoi_le.org_information1 local_unit_id,
280: hou_lu.NAME local_unit_name,
281: hoi_lu.org_information1

Line 283: hr_organization_information hoi_le,

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
287: AND hou_le.organization_id = csr_v_legal_employer_id

Line 285: hr_organization_information hoi_lu

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'
289: AND hou_lu.organization_id = hoi_le.org_information1

Line 294: csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE

290: AND hou_lu.organization_id = hoi_lu.organization_id
291: AND hoi_lu.org_information_context = 'FI_LOCAL_UNIT_DETAILS';
292:
293: Cursor csr_lu_pp_dtls (
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

Line 295: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE)

291: AND hoi_lu.org_information_context = 'FI_LOCAL_UNIT_DETAILS';
292:
293: Cursor csr_lu_pp_dtls (
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

Line 299: , hr_organization_information hoi1

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
303: AND hoi1.organization_id = csr_v_local_unit_id

Line 300: , hr_organization_information hoi2

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
303: AND hoi1.organization_id = csr_v_local_unit_id
304: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 752: l_pension_type hr_organization_information.org_information1%TYPE ;

748: l_prev_prepay NUMBER := 0;
749:
750: l_canonical_start_date DATE;
751: l_canonical_end_date DATE;
752: l_pension_type hr_organization_information.org_information1%TYPE ;
753:
754:
755: l_prepay_action_id NUMBER;
756: l_actid NUMBER;

Line 1099: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE

1095:
1096: --
1097: -- Cursor to pick up
1098: Cursor csr_pension_provider
1099: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
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

Line 1100: , csr_v_pension_ins_num hr_organization_information.org_information1%TYPE

1096: --
1097: -- Cursor to pick up
1098: Cursor csr_pension_provider
1099: ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE
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

Line 1105: , hr_organization_information hoi1

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
1109: AND hoi1.organization_id = csr_v_legal_emp_id

Line 1106: , hr_organization_information hoi2

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
1109: AND hoi1.organization_id = csr_v_legal_emp_id
1110: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1164: Cursor csr_Local_Unit_Details ( csr_v_local_unit_id hr_organization_information.ORGANIZATION_ID%TYPE)

1160:
1161: lr_get_Segment2 csr_get_Segment2%ROWTYPE;
1162:
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

Line 1168: , hr_organization_information hoi1

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
1172: AND hoi1.organization_id = csr_v_local_unit_id

Line 1169: , hr_organization_information hoi2

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
1172: AND hoi1.organization_id = csr_v_local_unit_id
1173: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 1228: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,

1224: AND PERSON_ID = CSR_V_PERSON_ID;
1225:
1226:
1227: CURSOR csr_Department_code (
1228: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,
1229: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE
1230: )
1231: IS
1232: SELECT hoi2.ORG_INFORMATION3

Line 1229: csr_v_Local_unit_id hr_organization_information.ORG_INFORMATION2%TYPE

1225:
1226:
1227: CURSOR csr_Department_code (
1228: csr_v_pension_provider_id hr_organization_information.organization_id%TYPE,
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

Line 1234: , hr_organization_information hoi1

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
1238: AND hoi1.organization_id = csr_v_pension_provider_id

Line 1235: , hr_organization_information hoi2

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
1238: AND hoi1.organization_id = csr_v_pension_provider_id
1239: AND hoi1.org_information_context = 'CLASS'