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

Line 189: l_org_information1 hr_organization_information.org_information1%TYPE;

185:
186: l_business_group_id hr_organization_units.business_group_id%TYPE;
187: l_count NUMBER ;
188: l_field VARCHAR2(300) := NULL;
189: l_org_information1 hr_organization_information.org_information1%TYPE;
190: l_main_lc_status hr_organization_information.org_information6%TYPE;
191:
192: UNIQUE_AST_NUMBER EXCEPTION;
193: UNIQUE_ORG_NUMBER EXCEPTION;

Line 190: l_main_lc_status hr_organization_information.org_information6%TYPE;

186: l_business_group_id hr_organization_units.business_group_id%TYPE;
187: l_count NUMBER ;
188: l_field VARCHAR2(300) := NULL;
189: l_org_information1 hr_organization_information.org_information1%TYPE;
190: l_main_lc_status hr_organization_information.org_information6%TYPE;
191:
192: UNIQUE_AST_NUMBER EXCEPTION;
193: UNIQUE_ORG_NUMBER EXCEPTION;
194: UNIQUE_MAIN_LOCAL_UNIT EXCEPTION;

Line 230: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s

226: WHERE organization_id = p_organization_id;
227: /*
228: CURSOR orglocalunit IS
229: select o.organization_id
230: from hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
231: where o.organization_id = hoi.organization_id
232: and hoi.org_information_context = 'CLASS'
233: and hoi.org_information1 = 'SE_LOCAL_UNIT'
234: and to_char(o.organization_id) in

Line 237: from hr_organization_units org, hr_organization_information hoinf

233: and hoi.org_information1 = 'SE_LOCAL_UNIT'
234: and to_char(o.organization_id) in
235: (
236: select hoinf.org_information1
237: from hr_organization_units org, hr_organization_information hoinf
238: where org.business_group_id = l_business_group_id
239: and org.organization_id = hoinf.organization_id
240: and hoinf.org_information_context = 'SE_LOCAL_UNITS'
241: )

Line 249: hr_organization_information hoi,

245: */
246: CURSOR orglocalunit IS
247: select o.organization_id
248: from hr_organization_units o ,
249: hr_organization_information hoi,
250: hr_organization_information hoinf,
251: FND_SESSIONS s
252: where o.organization_id = hoi.organization_id
253: and o.business_group_id = l_business_group_id

Line 250: hr_organization_information hoinf,

246: CURSOR orglocalunit IS
247: select o.organization_id
248: from hr_organization_units o ,
249: hr_organization_information hoi,
250: hr_organization_information hoinf,
251: FND_SESSIONS s
252: where o.organization_id = hoi.organization_id
253: and o.business_group_id = l_business_group_id
254: and hoi.org_information_context = 'CLASS'

Line 266: , HR_ORGANIZATION_INFORMATION hoi1

262: /*
263: CURSOR ast_number IS
264: select count(hoi2.org_information1)
265: from HR_ORGANIZATION_UNITS o1
266: , HR_ORGANIZATION_INFORMATION hoi1
267: , HR_ORGANIZATION_INFORMATION hoi2
268: WHERE o1.business_group_id =l_business_group_id
269: and hoi1.organization_id = o1.organization_id
270: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 267: , HR_ORGANIZATION_INFORMATION hoi2

263: CURSOR ast_number IS
264: select count(hoi2.org_information1)
265: from HR_ORGANIZATION_UNITS o1
266: , HR_ORGANIZATION_INFORMATION hoi1
267: , HR_ORGANIZATION_INFORMATION hoi2
268: WHERE o1.business_group_id =l_business_group_id
269: and hoi1.organization_id = o1.organization_id
270: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
271: and hoi1.org_information_context = 'CLASS'

Line 278: , HR_ORGANIZATION_INFORMATION hoi1

274: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
275: and hoi1.organization_id in
276: (select hoi1.organization_id
277: from HR_ORGANIZATION_UNITS o1
278: , HR_ORGANIZATION_INFORMATION hoi1
279: , HR_ORGANIZATION_INFORMATION hoi2
280: , HR_ORGANIZATION_INFORMATION hoi3
281: WHERE o1.business_group_id =l_business_group_id
282: and hoi1.organization_id = o1.organization_id

Line 279: , HR_ORGANIZATION_INFORMATION hoi2

275: and hoi1.organization_id in
276: (select hoi1.organization_id
277: from HR_ORGANIZATION_UNITS o1
278: , HR_ORGANIZATION_INFORMATION hoi1
279: , HR_ORGANIZATION_INFORMATION hoi2
280: , HR_ORGANIZATION_INFORMATION hoi3
281: WHERE o1.business_group_id =l_business_group_id
282: and hoi1.organization_id = o1.organization_id
283: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 280: , HR_ORGANIZATION_INFORMATION hoi3

276: (select hoi1.organization_id
277: from HR_ORGANIZATION_UNITS o1
278: , HR_ORGANIZATION_INFORMATION hoi1
279: , HR_ORGANIZATION_INFORMATION hoi2
280: , HR_ORGANIZATION_INFORMATION hoi3
281: WHERE o1.business_group_id =l_business_group_id
282: and hoi1.organization_id = o1.organization_id
283: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
284: and hoi1.org_information_context = 'CLASS'

Line 293: , HR_ORGANIZATION_INFORMATION hoi1

289: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
290: AND hoi3.organization_id IN
291: (select hoi3.organization_id
292: from HR_ORGANIZATION_UNITS o1
293: , HR_ORGANIZATION_INFORMATION hoi1
294: , HR_ORGANIZATION_INFORMATION hoi2
295: , HR_ORGANIZATION_INFORMATION hoi3
296: WHERE o1.business_group_id =l_business_group_id
297: and hoi1.organization_id = o1.organization_id

Line 294: , HR_ORGANIZATION_INFORMATION hoi2

290: AND hoi3.organization_id IN
291: (select hoi3.organization_id
292: from HR_ORGANIZATION_UNITS o1
293: , HR_ORGANIZATION_INFORMATION hoi1
294: , HR_ORGANIZATION_INFORMATION hoi2
295: , HR_ORGANIZATION_INFORMATION hoi3
296: WHERE o1.business_group_id =l_business_group_id
297: and hoi1.organization_id = o1.organization_id
298: and hoi1.organization_id = p_organization_id

Line 295: , HR_ORGANIZATION_INFORMATION hoi3

291: (select hoi3.organization_id
292: from HR_ORGANIZATION_UNITS o1
293: , HR_ORGANIZATION_INFORMATION hoi1
294: , HR_ORGANIZATION_INFORMATION hoi2
295: , HR_ORGANIZATION_INFORMATION hoi3
296: WHERE o1.business_group_id =l_business_group_id
297: and hoi1.organization_id = o1.organization_id
298: and hoi1.organization_id = p_organization_id
299: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 313: , HR_ORGANIZATION_INFORMATION hoi1

309:
310: CURSOR FIND_LEGAL_EMPLOYER IS
311: select hoi3.organization_id
312: from HR_ALL_ORGANIZATION_UNITS o1
313: , HR_ORGANIZATION_INFORMATION hoi1
314: , HR_ORGANIZATION_INFORMATION hoi2
315: , HR_ORGANIZATION_INFORMATION hoi3
316: WHERE o1.business_group_id =l_business_group_id
317: and hoi1.organization_id = o1.organization_id

Line 314: , HR_ORGANIZATION_INFORMATION hoi2

310: CURSOR FIND_LEGAL_EMPLOYER IS
311: select hoi3.organization_id
312: from HR_ALL_ORGANIZATION_UNITS o1
313: , HR_ORGANIZATION_INFORMATION hoi1
314: , HR_ORGANIZATION_INFORMATION hoi2
315: , HR_ORGANIZATION_INFORMATION hoi3
316: WHERE o1.business_group_id =l_business_group_id
317: and hoi1.organization_id = o1.organization_id
318: and hoi1.organization_id = p_organization_id

Line 315: , HR_ORGANIZATION_INFORMATION hoi3

311: select hoi3.organization_id
312: from HR_ALL_ORGANIZATION_UNITS o1
313: , HR_ORGANIZATION_INFORMATION hoi1
314: , HR_ORGANIZATION_INFORMATION hoi2
315: , HR_ORGANIZATION_INFORMATION hoi3
316: WHERE o1.business_group_id =l_business_group_id
317: and hoi1.organization_id = o1.organization_id
318: and hoi1.organization_id = p_organization_id
319: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 331: , HR_ORGANIZATION_INFORMATION hoi1

327: L_LEGAL_EMPLOYER NUMBER;
328: CURSOR ast_number IS
329: select count(hoi2.org_information1)
330: from HR_ALL_ORGANIZATION_UNITS o1
331: , HR_ORGANIZATION_INFORMATION hoi1
332: , HR_ORGANIZATION_INFORMATION hoi2
333: , HR_ORGANIZATION_INFORMATION hoi3
334: , HR_ORGANIZATION_INFORMATION hoi4
335: WHERE o1.business_group_id =l_business_group_id

Line 332: , HR_ORGANIZATION_INFORMATION hoi2

328: CURSOR ast_number IS
329: select count(hoi2.org_information1)
330: from HR_ALL_ORGANIZATION_UNITS o1
331: , HR_ORGANIZATION_INFORMATION hoi1
332: , HR_ORGANIZATION_INFORMATION hoi2
333: , HR_ORGANIZATION_INFORMATION hoi3
334: , HR_ORGANIZATION_INFORMATION hoi4
335: WHERE o1.business_group_id =l_business_group_id
336: and hoi1.organization_id = o1.organization_id

Line 333: , HR_ORGANIZATION_INFORMATION hoi3

329: select count(hoi2.org_information1)
330: from HR_ALL_ORGANIZATION_UNITS o1
331: , HR_ORGANIZATION_INFORMATION hoi1
332: , HR_ORGANIZATION_INFORMATION hoi2
333: , HR_ORGANIZATION_INFORMATION hoi3
334: , HR_ORGANIZATION_INFORMATION hoi4
335: WHERE o1.business_group_id =l_business_group_id
336: and hoi1.organization_id = o1.organization_id
337: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 334: , HR_ORGANIZATION_INFORMATION hoi4

330: from HR_ALL_ORGANIZATION_UNITS o1
331: , HR_ORGANIZATION_INFORMATION hoi1
332: , HR_ORGANIZATION_INFORMATION hoi2
333: , HR_ORGANIZATION_INFORMATION hoi3
334: , HR_ORGANIZATION_INFORMATION hoi4
335: WHERE o1.business_group_id =l_business_group_id
336: and hoi1.organization_id = o1.organization_id
337: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
338: and hoi1.org_information_context = 'CLASS'

Line 352: , HR_ORGANIZATION_INFORMATION hoi1

348:
349: /* CURSOR main_lc IS
350: select count(hoi2.org_information6)
351: from HR_ORGANIZATION_UNITS o1
352: , HR_ORGANIZATION_INFORMATION hoi1
353: , HR_ORGANIZATION_INFORMATION hoi2
354: WHERE o1.business_group_id =l_business_group_id
355: and hoi1.organization_id = o1.organization_id
356: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 353: , HR_ORGANIZATION_INFORMATION hoi2

349: /* CURSOR main_lc IS
350: select count(hoi2.org_information6)
351: from HR_ORGANIZATION_UNITS o1
352: , HR_ORGANIZATION_INFORMATION hoi1
353: , HR_ORGANIZATION_INFORMATION hoi2
354: WHERE o1.business_group_id =l_business_group_id
355: and hoi1.organization_id = o1.organization_id
356: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
357: and hoi1.org_information_context = 'CLASS'

Line 364: , HR_ORGANIZATION_INFORMATION hoi1

360: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
361: and hoi1.organization_id in
362: (select hoi1.organization_id
363: from HR_ORGANIZATION_UNITS o1
364: , HR_ORGANIZATION_INFORMATION hoi1
365: , HR_ORGANIZATION_INFORMATION hoi2
366: , HR_ORGANIZATION_INFORMATION hoi3
367: WHERE o1.business_group_id =l_business_group_id
368: and hoi1.organization_id = o1.organization_id

Line 365: , HR_ORGANIZATION_INFORMATION hoi2

361: and hoi1.organization_id in
362: (select hoi1.organization_id
363: from HR_ORGANIZATION_UNITS o1
364: , HR_ORGANIZATION_INFORMATION hoi1
365: , HR_ORGANIZATION_INFORMATION hoi2
366: , HR_ORGANIZATION_INFORMATION hoi3
367: WHERE o1.business_group_id =l_business_group_id
368: and hoi1.organization_id = o1.organization_id
369: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 366: , HR_ORGANIZATION_INFORMATION hoi3

362: (select hoi1.organization_id
363: from HR_ORGANIZATION_UNITS o1
364: , HR_ORGANIZATION_INFORMATION hoi1
365: , HR_ORGANIZATION_INFORMATION hoi2
366: , HR_ORGANIZATION_INFORMATION hoi3
367: WHERE o1.business_group_id =l_business_group_id
368: and hoi1.organization_id = o1.organization_id
369: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
370: and hoi1.org_information_context = 'CLASS'

Line 379: , HR_ORGANIZATION_INFORMATION hoi1

375: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
376: AND hoi3.organization_id IN
377: (select hoi3.organization_id
378: from HR_ORGANIZATION_UNITS o1
379: , HR_ORGANIZATION_INFORMATION hoi1
380: , HR_ORGANIZATION_INFORMATION hoi2
381: , HR_ORGANIZATION_INFORMATION hoi3
382: WHERE o1.business_group_id =l_business_group_id
383: and hoi1.organization_id = o1.organization_id

Line 380: , HR_ORGANIZATION_INFORMATION hoi2

376: AND hoi3.organization_id IN
377: (select hoi3.organization_id
378: from HR_ORGANIZATION_UNITS o1
379: , HR_ORGANIZATION_INFORMATION hoi1
380: , HR_ORGANIZATION_INFORMATION hoi2
381: , HR_ORGANIZATION_INFORMATION hoi3
382: WHERE o1.business_group_id =l_business_group_id
383: and hoi1.organization_id = o1.organization_id
384: and hoi1.organization_id = p_organization_id

Line 381: , HR_ORGANIZATION_INFORMATION hoi3

377: (select hoi3.organization_id
378: from HR_ORGANIZATION_UNITS o1
379: , HR_ORGANIZATION_INFORMATION hoi1
380: , HR_ORGANIZATION_INFORMATION hoi2
381: , HR_ORGANIZATION_INFORMATION hoi3
382: WHERE o1.business_group_id =l_business_group_id
383: and hoi1.organization_id = o1.organization_id
384: and hoi1.organization_id = p_organization_id
385: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 396: , HR_ORGANIZATION_INFORMATION hoi1

392:
393: CURSOR main_lc IS
394: select count(hoi2.org_information6)
395: from HR_ALL_ORGANIZATION_UNITS o1
396: , HR_ORGANIZATION_INFORMATION hoi1
397: , HR_ORGANIZATION_INFORMATION hoi2
398: , HR_ORGANIZATION_INFORMATION hoi3
399: , HR_ORGANIZATION_INFORMATION hoi4
400: WHERE o1.business_group_id =l_business_group_id

Line 397: , HR_ORGANIZATION_INFORMATION hoi2

393: CURSOR main_lc IS
394: select count(hoi2.org_information6)
395: from HR_ALL_ORGANIZATION_UNITS o1
396: , HR_ORGANIZATION_INFORMATION hoi1
397: , HR_ORGANIZATION_INFORMATION hoi2
398: , HR_ORGANIZATION_INFORMATION hoi3
399: , HR_ORGANIZATION_INFORMATION hoi4
400: WHERE o1.business_group_id =l_business_group_id
401: and hoi1.organization_id = o1.organization_id

Line 398: , HR_ORGANIZATION_INFORMATION hoi3

394: select count(hoi2.org_information6)
395: from HR_ALL_ORGANIZATION_UNITS o1
396: , HR_ORGANIZATION_INFORMATION hoi1
397: , HR_ORGANIZATION_INFORMATION hoi2
398: , HR_ORGANIZATION_INFORMATION hoi3
399: , HR_ORGANIZATION_INFORMATION hoi4
400: WHERE o1.business_group_id =l_business_group_id
401: and hoi1.organization_id = o1.organization_id
402: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 399: , HR_ORGANIZATION_INFORMATION hoi4

395: from HR_ALL_ORGANIZATION_UNITS o1
396: , HR_ORGANIZATION_INFORMATION hoi1
397: , HR_ORGANIZATION_INFORMATION hoi2
398: , HR_ORGANIZATION_INFORMATION hoi3
399: , HR_ORGANIZATION_INFORMATION hoi4
400: WHERE o1.business_group_id =l_business_group_id
401: and hoi1.organization_id = o1.organization_id
402: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
403: and hoi1.org_information_context = 'CLASS'

Line 418: , HR_ORGANIZATION_INFORMATION hoi1

414: /*
415: CURSOR main_lc_le IS
416: select count(hoi2.org_information6)
417: from HR_ORGANIZATION_UNITS o1
418: , HR_ORGANIZATION_INFORMATION hoi1
419: , HR_ORGANIZATION_INFORMATION hoi2
420: WHERE o1.business_group_id =l_business_group_id
421: and hoi1.organization_id = o1.organization_id
422: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 419: , HR_ORGANIZATION_INFORMATION hoi2

415: CURSOR main_lc_le IS
416: select count(hoi2.org_information6)
417: from HR_ORGANIZATION_UNITS o1
418: , HR_ORGANIZATION_INFORMATION hoi1
419: , HR_ORGANIZATION_INFORMATION hoi2
420: WHERE o1.business_group_id =l_business_group_id
421: and hoi1.organization_id = o1.organization_id
422: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
423: and hoi1.org_information_context = 'CLASS'

Line 431: , HR_ORGANIZATION_INFORMATION hoi1

427: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
428: and hoi1.organization_id in
429: (select hoi1.organization_id
430: from HR_ORGANIZATION_UNITS o1
431: , HR_ORGANIZATION_INFORMATION hoi1
432: , HR_ORGANIZATION_INFORMATION hoi2
433: , HR_ORGANIZATION_INFORMATION hoi3
434: WHERE o1.business_group_id =l_business_group_id
435: and hoi1.organization_id = o1.organization_id

Line 432: , HR_ORGANIZATION_INFORMATION hoi2

428: and hoi1.organization_id in
429: (select hoi1.organization_id
430: from HR_ORGANIZATION_UNITS o1
431: , HR_ORGANIZATION_INFORMATION hoi1
432: , HR_ORGANIZATION_INFORMATION hoi2
433: , HR_ORGANIZATION_INFORMATION hoi3
434: WHERE o1.business_group_id =l_business_group_id
435: and hoi1.organization_id = o1.organization_id
436: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 433: , HR_ORGANIZATION_INFORMATION hoi3

429: (select hoi1.organization_id
430: from HR_ORGANIZATION_UNITS o1
431: , HR_ORGANIZATION_INFORMATION hoi1
432: , HR_ORGANIZATION_INFORMATION hoi2
433: , HR_ORGANIZATION_INFORMATION hoi3
434: WHERE o1.business_group_id =l_business_group_id
435: and hoi1.organization_id = o1.organization_id
436: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
437: and hoi1.org_information_context = 'CLASS'

Line 447: , HR_ORGANIZATION_INFORMATION hoi1

443: AND hoi3.organization_id = p_organization_id );
444: */
445: CURSOR main_lc_le IS select count(hoi2.org_information6)
446: from HR_ALL_ORGANIZATION_UNITS o1
447: , HR_ORGANIZATION_INFORMATION hoi1
448: , HR_ORGANIZATION_INFORMATION hoi2
449: , HR_ORGANIZATION_INFORMATION hoi3
450: , HR_ORGANIZATION_INFORMATION hoi4
451: WHERE o1.business_group_id =l_business_group_id

Line 448: , HR_ORGANIZATION_INFORMATION hoi2

444: */
445: CURSOR main_lc_le IS select count(hoi2.org_information6)
446: from HR_ALL_ORGANIZATION_UNITS o1
447: , HR_ORGANIZATION_INFORMATION hoi1
448: , HR_ORGANIZATION_INFORMATION hoi2
449: , HR_ORGANIZATION_INFORMATION hoi3
450: , HR_ORGANIZATION_INFORMATION hoi4
451: WHERE o1.business_group_id =l_business_group_id
452: and hoi1.organization_id = o1.organization_id

Line 449: , HR_ORGANIZATION_INFORMATION hoi3

445: CURSOR main_lc_le IS select count(hoi2.org_information6)
446: from HR_ALL_ORGANIZATION_UNITS o1
447: , HR_ORGANIZATION_INFORMATION hoi1
448: , HR_ORGANIZATION_INFORMATION hoi2
449: , HR_ORGANIZATION_INFORMATION hoi3
450: , HR_ORGANIZATION_INFORMATION hoi4
451: WHERE o1.business_group_id =l_business_group_id
452: and hoi1.organization_id = o1.organization_id
453: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 450: , HR_ORGANIZATION_INFORMATION hoi4

446: from HR_ALL_ORGANIZATION_UNITS o1
447: , HR_ORGANIZATION_INFORMATION hoi1
448: , HR_ORGANIZATION_INFORMATION hoi2
449: , HR_ORGANIZATION_INFORMATION hoi3
450: , HR_ORGANIZATION_INFORMATION hoi4
451: WHERE o1.business_group_id =l_business_group_id
452: and hoi1.organization_id = o1.organization_id
453: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
454: and hoi1.org_information_context = 'CLASS'

Line 470: , HR_ORGANIZATION_INFORMATION hoi1

466: /*
467: CURSOR ast_number_le IS
468: select count(hoi2.org_information1)
469: from HR_ORGANIZATION_UNITS o1
470: , HR_ORGANIZATION_INFORMATION hoi1
471: , HR_ORGANIZATION_INFORMATION hoi2
472: WHERE o1.business_group_id =l_business_group_id
473: and hoi1.organization_id = o1.organization_id
474: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 471: , HR_ORGANIZATION_INFORMATION hoi2

467: CURSOR ast_number_le IS
468: select count(hoi2.org_information1)
469: from HR_ORGANIZATION_UNITS o1
470: , HR_ORGANIZATION_INFORMATION hoi1
471: , HR_ORGANIZATION_INFORMATION hoi2
472: WHERE o1.business_group_id =l_business_group_id
473: and hoi1.organization_id = o1.organization_id
474: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
475: and hoi1.org_information_context = 'CLASS'

Line 482: , HR_ORGANIZATION_INFORMATION hoi1

478: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
479: and hoi2.org_information1 in
480: (select hoi2.org_information1
481: from HR_ORGANIZATION_UNITS o1
482: , HR_ORGANIZATION_INFORMATION hoi1
483: , HR_ORGANIZATION_INFORMATION hoi2
484: WHERE o1.business_group_id =l_business_group_id
485: and hoi1.organization_id = o1.organization_id
486: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 483: , HR_ORGANIZATION_INFORMATION hoi2

479: and hoi2.org_information1 in
480: (select hoi2.org_information1
481: from HR_ORGANIZATION_UNITS o1
482: , HR_ORGANIZATION_INFORMATION hoi1
483: , HR_ORGANIZATION_INFORMATION hoi2
484: WHERE o1.business_group_id =l_business_group_id
485: and hoi1.organization_id = o1.organization_id
486: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
487: and hoi1.org_information_context = 'CLASS'

Line 495: , HR_ORGANIZATION_INFORMATION hoi1

491: )
492: and hoi1.organization_id in
493: (select hoi1.organization_id
494: from HR_ORGANIZATION_UNITS o1
495: , HR_ORGANIZATION_INFORMATION hoi1
496: , HR_ORGANIZATION_INFORMATION hoi2
497: , HR_ORGANIZATION_INFORMATION hoi3
498: WHERE o1.business_group_id =l_business_group_id
499: and hoi1.organization_id = o1.organization_id

Line 496: , HR_ORGANIZATION_INFORMATION hoi2

492: and hoi1.organization_id in
493: (select hoi1.organization_id
494: from HR_ORGANIZATION_UNITS o1
495: , HR_ORGANIZATION_INFORMATION hoi1
496: , HR_ORGANIZATION_INFORMATION hoi2
497: , HR_ORGANIZATION_INFORMATION hoi3
498: WHERE o1.business_group_id =l_business_group_id
499: and hoi1.organization_id = o1.organization_id
500: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 497: , HR_ORGANIZATION_INFORMATION hoi3

493: (select hoi1.organization_id
494: from HR_ORGANIZATION_UNITS o1
495: , HR_ORGANIZATION_INFORMATION hoi1
496: , HR_ORGANIZATION_INFORMATION hoi2
497: , HR_ORGANIZATION_INFORMATION hoi3
498: WHERE o1.business_group_id =l_business_group_id
499: and hoi1.organization_id = o1.organization_id
500: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
501: and hoi1.org_information_context = 'CLASS'

Line 512: , HR_ORGANIZATION_INFORMATION hoi1

508: */
509: CURSOR ast_number_le IS
510: select count(hoi2.org_information1)
511: from HR_ALL_ORGANIZATION_UNITS o1
512: , HR_ORGANIZATION_INFORMATION hoi1
513: , HR_ORGANIZATION_INFORMATION hoi2
514: , HR_ORGANIZATION_INFORMATION hoi3
515: , HR_ORGANIZATION_INFORMATION hoi4
516: , HR_ORGANIZATION_INFORMATION hoi5

Line 513: , HR_ORGANIZATION_INFORMATION hoi2

509: CURSOR ast_number_le IS
510: select count(hoi2.org_information1)
511: from HR_ALL_ORGANIZATION_UNITS o1
512: , HR_ORGANIZATION_INFORMATION hoi1
513: , HR_ORGANIZATION_INFORMATION hoi2
514: , HR_ORGANIZATION_INFORMATION hoi3
515: , HR_ORGANIZATION_INFORMATION hoi4
516: , HR_ORGANIZATION_INFORMATION hoi5
517: WHERE o1.business_group_id =l_business_group_id

Line 514: , HR_ORGANIZATION_INFORMATION hoi3

510: select count(hoi2.org_information1)
511: from HR_ALL_ORGANIZATION_UNITS o1
512: , HR_ORGANIZATION_INFORMATION hoi1
513: , HR_ORGANIZATION_INFORMATION hoi2
514: , HR_ORGANIZATION_INFORMATION hoi3
515: , HR_ORGANIZATION_INFORMATION hoi4
516: , HR_ORGANIZATION_INFORMATION hoi5
517: WHERE o1.business_group_id =l_business_group_id
518: and hoi1.organization_id = o1.organization_id

Line 515: , HR_ORGANIZATION_INFORMATION hoi4

511: from HR_ALL_ORGANIZATION_UNITS o1
512: , HR_ORGANIZATION_INFORMATION hoi1
513: , HR_ORGANIZATION_INFORMATION hoi2
514: , HR_ORGANIZATION_INFORMATION hoi3
515: , HR_ORGANIZATION_INFORMATION hoi4
516: , HR_ORGANIZATION_INFORMATION hoi5
517: WHERE o1.business_group_id =l_business_group_id
518: and hoi1.organization_id = o1.organization_id
519: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 516: , HR_ORGANIZATION_INFORMATION hoi5

512: , HR_ORGANIZATION_INFORMATION hoi1
513: , HR_ORGANIZATION_INFORMATION hoi2
514: , HR_ORGANIZATION_INFORMATION hoi3
515: , HR_ORGANIZATION_INFORMATION hoi4
516: , HR_ORGANIZATION_INFORMATION hoi5
517: WHERE o1.business_group_id =l_business_group_id
518: and hoi1.organization_id = o1.organization_id
519: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
520: and hoi1.org_information_context = 'CLASS'

Line 537: , HR_ORGANIZATION_INFORMATION hoi1

533:
534: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
535: select count(hoi1.org_information1)
536: from HR_ALL_ORGANIZATION_UNITS o1
537: , HR_ORGANIZATION_INFORMATION hoi1
538: , HR_ORGANIZATION_INFORMATION hoi2
539: WHERE o1.business_group_id =l_business_group_id
540: and o1.organization_id=hoi1.organization_id
541: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 538: , HR_ORGANIZATION_INFORMATION hoi2

534: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
535: select count(hoi1.org_information1)
536: from HR_ALL_ORGANIZATION_UNITS o1
537: , HR_ORGANIZATION_INFORMATION hoi1
538: , HR_ORGANIZATION_INFORMATION hoi2
539: WHERE o1.business_group_id =l_business_group_id
540: and o1.organization_id=hoi1.organization_id
541: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
542: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 552: , HR_ORGANIZATION_INFORMATION hoi1

548:
549: CURSOR absence_cat_limit(l_param1 varchar2) IS
550: select count(hoi1.org_information1)
551: from HR_ALL_ORGANIZATION_UNITS o1
552: , HR_ORGANIZATION_INFORMATION hoi1
553: , HR_ORGANIZATION_INFORMATION hoi2
554: WHERE o1.business_group_id =l_business_group_id
555: and o1.organization_id=hoi1.organization_id
556: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 553: , HR_ORGANIZATION_INFORMATION hoi2

549: CURSOR absence_cat_limit(l_param1 varchar2) IS
550: select count(hoi1.org_information1)
551: from HR_ALL_ORGANIZATION_UNITS o1
552: , HR_ORGANIZATION_INFORMATION hoi1
553: , HR_ORGANIZATION_INFORMATION hoi2
554: WHERE o1.business_group_id =l_business_group_id
555: and o1.organization_id=hoi1.organization_id
556: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
557: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 566: , HR_ORGANIZATION_INFORMATION hoi1

562:
563: CURSOR org_number IS
564: select count(hoi2.org_information2)
565: from HR_ALL_ORGANIZATION_UNITS o1
566: , HR_ORGANIZATION_INFORMATION hoi1
567: , HR_ORGANIZATION_INFORMATION hoi2
568: WHERE o1.business_group_id =l_business_group_id
569: and hoi1.organization_id = o1.organization_id
570: and hoi1.org_information_context = 'CLASS'

Line 567: , HR_ORGANIZATION_INFORMATION hoi2

563: CURSOR org_number IS
564: select count(hoi2.org_information2)
565: from HR_ALL_ORGANIZATION_UNITS o1
566: , HR_ORGANIZATION_INFORMATION hoi1
567: , HR_ORGANIZATION_INFORMATION hoi2
568: WHERE o1.business_group_id =l_business_group_id
569: and hoi1.organization_id = o1.organization_id
570: and hoi1.org_information_context = 'CLASS'
571: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 580: , HR_ORGANIZATION_INFORMATION hoi1

576:
577: CURSOR main_lc_status IS
578: select hoi2.org_information6
579: from HR_ALL_ORGANIZATION_UNITS o1
580: , HR_ORGANIZATION_INFORMATION hoi1
581: , HR_ORGANIZATION_INFORMATION hoi2
582: WHERE o1.business_group_id =l_business_group_id
583: and hoi1.organization_id = o1.organization_id
584: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 581: , HR_ORGANIZATION_INFORMATION hoi2

577: CURSOR main_lc_status IS
578: select hoi2.org_information6
579: from HR_ALL_ORGANIZATION_UNITS o1
580: , HR_ORGANIZATION_INFORMATION hoi1
581: , HR_ORGANIZATION_INFORMATION hoi2
582: WHERE o1.business_group_id =l_business_group_id
583: and hoi1.organization_id = o1.organization_id
584: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
585: and hoi1.org_information_context = 'CLASS'

Line 594: FROM hr_organization_information hoi, hr_all_organization_units ou

590:
591:
592: CURSOR c_ins_le_ap_dtls IS
593: SELECT COUNT(*)
594: FROM hr_organization_information hoi, hr_all_organization_units ou
595: WHERE (hoi.org_information_context = 'SE_COMPANY_MILEAGE_RATES')
596: AND ou.organization_id = hoi.organization_id
597: AND ou.organization_id = nvl(p_organization_id , 0)
598: AND ou.business_group_id = l_business_group_id

Line 631: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s

627: l_agreement_meaning varchar2(50);
628:
629: CURSOR csr_year IS
630: SELECT count(*)
631: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
632: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
633: AND ou.organization_id = hoi.organization_id
634: AND ou.organization_id = nvl (p_organization_id, 0)
635: AND ou.business_group_id = l_business_group_id

Line 1034: l_org_information1 hr_organization_information.org_information1%TYPE;

1030: ) IS
1031:
1032: l_count NUMBER ;
1033: l_business_group_id hr_organization_units.business_group_id%TYPE;
1034: l_org_information1 hr_organization_information.org_information1%TYPE;
1035: l_field VARCHAR2(300) := NULL;
1036: l_organization_id hr_organization_information.organization_id%TYPE;
1037: l_main_lc_status hr_organization_information.org_information6%TYPE;
1038:

Line 1036: l_organization_id hr_organization_information.organization_id%TYPE;

1032: l_count NUMBER ;
1033: l_business_group_id hr_organization_units.business_group_id%TYPE;
1034: l_org_information1 hr_organization_information.org_information1%TYPE;
1035: l_field VARCHAR2(300) := NULL;
1036: l_organization_id hr_organization_information.organization_id%TYPE;
1037: l_main_lc_status hr_organization_information.org_information6%TYPE;
1038:
1039: l_token varchar2(300);
1040: l_prev_holiday_start varchar2(30);

Line 1037: l_main_lc_status hr_organization_information.org_information6%TYPE;

1033: l_business_group_id hr_organization_units.business_group_id%TYPE;
1034: l_org_information1 hr_organization_information.org_information1%TYPE;
1035: l_field VARCHAR2(300) := NULL;
1036: l_organization_id hr_organization_information.organization_id%TYPE;
1037: l_main_lc_status hr_organization_information.org_information6%TYPE;
1038:
1039: l_token varchar2(300);
1040: l_prev_holiday_start varchar2(30);
1041: l_prev_holiday_end varchar2(30);

Line 1079: FROM hr_organization_information

1075: where organization_id = l_organization_id;
1076:
1077: CURSOR getorgid IS
1078: SELECT organization_id
1079: FROM hr_organization_information
1080: WHERE org_information_id = p_org_information_id;
1081:
1082: /*
1083: CURSOR orglocalunit IS

Line 1085: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s

1081:
1082: /*
1083: CURSOR orglocalunit IS
1084: SELECT o.organization_id
1085: FROM hr_organization_units o , hr_organization_information hoi , FND_SESSIONS s
1086: WHERE o.organization_id = hoi.organization_id
1087: AND hoi.org_information_context = 'CLASS'
1088: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1089: AND to_char(o.organization_id) IN

Line 1092: FROM hr_organization_units org, hr_organization_information hoinf

1088: AND hoi.org_information1 = 'SE_LOCAL_UNIT'
1089: AND to_char(o.organization_id) IN
1090: (
1091: SELECT hoinf.org_information1
1092: FROM hr_organization_units org, hr_organization_information hoinf
1093: WHERE org.business_group_id = l_business_group_id
1094: AND org.organization_id = hoinf.organization_id
1095: AND org.organization_id <> l_organization_id
1096: AND hoinf.org_information_context = 'SE_LOCAL_UNITS'

Line 1105: hr_organization_information hoi,

1101: */
1102:
1103: CURSOR orglocalunit IS select o.organization_id
1104: from hr_organization_units o ,
1105: hr_organization_information hoi,
1106: hr_organization_information hoinf,
1107: FND_SESSIONS s
1108: where o.organization_id = hoi.organization_id
1109: and o.business_group_id = l_business_group_id

Line 1106: hr_organization_information hoinf,

1102:
1103: CURSOR orglocalunit IS select o.organization_id
1104: from hr_organization_units o ,
1105: hr_organization_information hoi,
1106: hr_organization_information hoinf,
1107: FND_SESSIONS s
1108: where o.organization_id = hoi.organization_id
1109: and o.business_group_id = l_business_group_id
1110: and hoi.org_information_context = 'CLASS'

Line 1122: , HR_ORGANIZATION_INFORMATION hoi1

1118: /*
1119: CURSOR ast_number IS
1120: select count(hoi2.org_information1)
1121: from HR_ORGANIZATION_UNITS o1
1122: , HR_ORGANIZATION_INFORMATION hoi1
1123: , HR_ORGANIZATION_INFORMATION hoi2
1124: WHERE o1.business_group_id =l_business_group_id
1125: and hoi1.organization_id = o1.organization_id
1126: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1123: , HR_ORGANIZATION_INFORMATION hoi2

1119: CURSOR ast_number IS
1120: select count(hoi2.org_information1)
1121: from HR_ORGANIZATION_UNITS o1
1122: , HR_ORGANIZATION_INFORMATION hoi1
1123: , HR_ORGANIZATION_INFORMATION hoi2
1124: WHERE o1.business_group_id =l_business_group_id
1125: and hoi1.organization_id = o1.organization_id
1126: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1127: and hoi1.org_information_context = 'CLASS'

Line 1135: , HR_ORGANIZATION_INFORMATION hoi1

1131: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1132: and hoi1.organization_id in
1133: (select hoi1.organization_id
1134: from HR_ORGANIZATION_UNITS o1
1135: , HR_ORGANIZATION_INFORMATION hoi1
1136: , HR_ORGANIZATION_INFORMATION hoi2
1137: , HR_ORGANIZATION_INFORMATION hoi3
1138: WHERE o1.business_group_id =l_business_group_id
1139: and hoi1.organization_id = o1.organization_id

Line 1136: , HR_ORGANIZATION_INFORMATION hoi2

1132: and hoi1.organization_id in
1133: (select hoi1.organization_id
1134: from HR_ORGANIZATION_UNITS o1
1135: , HR_ORGANIZATION_INFORMATION hoi1
1136: , HR_ORGANIZATION_INFORMATION hoi2
1137: , HR_ORGANIZATION_INFORMATION hoi3
1138: WHERE o1.business_group_id =l_business_group_id
1139: and hoi1.organization_id = o1.organization_id
1140: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1137: , HR_ORGANIZATION_INFORMATION hoi3

1133: (select hoi1.organization_id
1134: from HR_ORGANIZATION_UNITS o1
1135: , HR_ORGANIZATION_INFORMATION hoi1
1136: , HR_ORGANIZATION_INFORMATION hoi2
1137: , HR_ORGANIZATION_INFORMATION hoi3
1138: WHERE o1.business_group_id =l_business_group_id
1139: and hoi1.organization_id = o1.organization_id
1140: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1141: and hoi1.org_information_context = 'CLASS'

Line 1150: , HR_ORGANIZATION_INFORMATION hoi1

1146: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1147: AND hoi3.organization_id IN
1148: (select hoi3.organization_id
1149: from HR_ORGANIZATION_UNITS o1
1150: , HR_ORGANIZATION_INFORMATION hoi1
1151: , HR_ORGANIZATION_INFORMATION hoi2
1152: , HR_ORGANIZATION_INFORMATION hoi3
1153: WHERE o1.business_group_id =l_business_group_id
1154: and hoi1.organization_id = o1.organization_id

Line 1151: , HR_ORGANIZATION_INFORMATION hoi2

1147: AND hoi3.organization_id IN
1148: (select hoi3.organization_id
1149: from HR_ORGANIZATION_UNITS o1
1150: , HR_ORGANIZATION_INFORMATION hoi1
1151: , HR_ORGANIZATION_INFORMATION hoi2
1152: , HR_ORGANIZATION_INFORMATION hoi3
1153: WHERE o1.business_group_id =l_business_group_id
1154: and hoi1.organization_id = o1.organization_id
1155: and hoi1.organization_id = l_organization_id

Line 1152: , HR_ORGANIZATION_INFORMATION hoi3

1148: (select hoi3.organization_id
1149: from HR_ORGANIZATION_UNITS o1
1150: , HR_ORGANIZATION_INFORMATION hoi1
1151: , HR_ORGANIZATION_INFORMATION hoi2
1152: , HR_ORGANIZATION_INFORMATION hoi3
1153: WHERE o1.business_group_id =l_business_group_id
1154: and hoi1.organization_id = o1.organization_id
1155: and hoi1.organization_id = l_organization_id
1156: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1167: , HR_ORGANIZATION_INFORMATION hoi1

1163: */
1164: CURSOR FIND_LEGAL_EMPLOYER IS
1165: select hoi3.organization_id
1166: from HR_ALL_ORGANIZATION_UNITS o1
1167: , HR_ORGANIZATION_INFORMATION hoi1
1168: , HR_ORGANIZATION_INFORMATION hoi2
1169: , HR_ORGANIZATION_INFORMATION hoi3
1170: WHERE o1.business_group_id =l_business_group_id
1171: and hoi1.organization_id = o1.organization_id

Line 1168: , HR_ORGANIZATION_INFORMATION hoi2

1164: CURSOR FIND_LEGAL_EMPLOYER IS
1165: select hoi3.organization_id
1166: from HR_ALL_ORGANIZATION_UNITS o1
1167: , HR_ORGANIZATION_INFORMATION hoi1
1168: , HR_ORGANIZATION_INFORMATION hoi2
1169: , HR_ORGANIZATION_INFORMATION hoi3
1170: WHERE o1.business_group_id =l_business_group_id
1171: and hoi1.organization_id = o1.organization_id
1172: and hoi1.organization_id = l_organization_id

Line 1169: , HR_ORGANIZATION_INFORMATION hoi3

1165: select hoi3.organization_id
1166: from HR_ALL_ORGANIZATION_UNITS o1
1167: , HR_ORGANIZATION_INFORMATION hoi1
1168: , HR_ORGANIZATION_INFORMATION hoi2
1169: , HR_ORGANIZATION_INFORMATION hoi3
1170: WHERE o1.business_group_id =l_business_group_id
1171: and hoi1.organization_id = o1.organization_id
1172: and hoi1.organization_id = l_organization_id
1173: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1185: , HR_ORGANIZATION_INFORMATION hoi1

1181: L_LEGAL_EMPLOYER NUMBER;
1182: CURSOR ast_number IS
1183: select count(hoi2.org_information1)
1184: from HR_ALL_ORGANIZATION_UNITS o1
1185: , HR_ORGANIZATION_INFORMATION hoi1
1186: , HR_ORGANIZATION_INFORMATION hoi2
1187: , HR_ORGANIZATION_INFORMATION hoi3
1188: , HR_ORGANIZATION_INFORMATION hoi4
1189: WHERE o1.business_group_id =l_business_group_id

Line 1186: , HR_ORGANIZATION_INFORMATION hoi2

1182: CURSOR ast_number IS
1183: select count(hoi2.org_information1)
1184: from HR_ALL_ORGANIZATION_UNITS o1
1185: , HR_ORGANIZATION_INFORMATION hoi1
1186: , HR_ORGANIZATION_INFORMATION hoi2
1187: , HR_ORGANIZATION_INFORMATION hoi3
1188: , HR_ORGANIZATION_INFORMATION hoi4
1189: WHERE o1.business_group_id =l_business_group_id
1190: and hoi1.organization_id = o1.organization_id

Line 1187: , HR_ORGANIZATION_INFORMATION hoi3

1183: select count(hoi2.org_information1)
1184: from HR_ALL_ORGANIZATION_UNITS o1
1185: , HR_ORGANIZATION_INFORMATION hoi1
1186: , HR_ORGANIZATION_INFORMATION hoi2
1187: , HR_ORGANIZATION_INFORMATION hoi3
1188: , HR_ORGANIZATION_INFORMATION hoi4
1189: WHERE o1.business_group_id =l_business_group_id
1190: and hoi1.organization_id = o1.organization_id
1191: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1188: , HR_ORGANIZATION_INFORMATION hoi4

1184: from HR_ALL_ORGANIZATION_UNITS o1
1185: , HR_ORGANIZATION_INFORMATION hoi1
1186: , HR_ORGANIZATION_INFORMATION hoi2
1187: , HR_ORGANIZATION_INFORMATION hoi3
1188: , HR_ORGANIZATION_INFORMATION hoi4
1189: WHERE o1.business_group_id =l_business_group_id
1190: and hoi1.organization_id = o1.organization_id
1191: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1192: and hoi1.org_information_context = 'CLASS'

Line 1209: , HR_ORGANIZATION_INFORMATION hoi1

1205: /*
1206: CURSOR main_lc IS
1207: select count(hoi2.org_information6)
1208: from HR_ORGANIZATION_UNITS o1
1209: , HR_ORGANIZATION_INFORMATION hoi1
1210: , HR_ORGANIZATION_INFORMATION hoi2
1211: WHERE o1.business_group_id =l_business_group_id
1212: and hoi1.organization_id = o1.organization_id
1213: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1210: , HR_ORGANIZATION_INFORMATION hoi2

1206: CURSOR main_lc IS
1207: select count(hoi2.org_information6)
1208: from HR_ORGANIZATION_UNITS o1
1209: , HR_ORGANIZATION_INFORMATION hoi1
1210: , HR_ORGANIZATION_INFORMATION hoi2
1211: WHERE o1.business_group_id =l_business_group_id
1212: and hoi1.organization_id = o1.organization_id
1213: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1214: and hoi1.org_information_context = 'CLASS'

Line 1222: , HR_ORGANIZATION_INFORMATION hoi1

1218: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1219: and hoi1.organization_id in
1220: (select hoi1.organization_id
1221: from HR_ORGANIZATION_UNITS o1
1222: , HR_ORGANIZATION_INFORMATION hoi1
1223: , HR_ORGANIZATION_INFORMATION hoi2
1224: , HR_ORGANIZATION_INFORMATION hoi3
1225: WHERE o1.business_group_id =l_business_group_id
1226: and hoi1.organization_id = o1.organization_id

Line 1223: , HR_ORGANIZATION_INFORMATION hoi2

1219: and hoi1.organization_id in
1220: (select hoi1.organization_id
1221: from HR_ORGANIZATION_UNITS o1
1222: , HR_ORGANIZATION_INFORMATION hoi1
1223: , HR_ORGANIZATION_INFORMATION hoi2
1224: , HR_ORGANIZATION_INFORMATION hoi3
1225: WHERE o1.business_group_id =l_business_group_id
1226: and hoi1.organization_id = o1.organization_id
1227: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1224: , HR_ORGANIZATION_INFORMATION hoi3

1220: (select hoi1.organization_id
1221: from HR_ORGANIZATION_UNITS o1
1222: , HR_ORGANIZATION_INFORMATION hoi1
1223: , HR_ORGANIZATION_INFORMATION hoi2
1224: , HR_ORGANIZATION_INFORMATION hoi3
1225: WHERE o1.business_group_id =l_business_group_id
1226: and hoi1.organization_id = o1.organization_id
1227: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1228: and hoi1.org_information_context = 'CLASS'

Line 1237: , HR_ORGANIZATION_INFORMATION hoi1

1233: and hoi3.org_information1 = 'HR_LEGAL_EMPLOYER'
1234: AND hoi3.organization_id IN
1235: (select hoi3.organization_id
1236: from HR_ORGANIZATION_UNITS o1
1237: , HR_ORGANIZATION_INFORMATION hoi1
1238: , HR_ORGANIZATION_INFORMATION hoi2
1239: , HR_ORGANIZATION_INFORMATION hoi3
1240: WHERE o1.business_group_id =l_business_group_id
1241: and hoi1.organization_id = o1.organization_id

Line 1238: , HR_ORGANIZATION_INFORMATION hoi2

1234: AND hoi3.organization_id IN
1235: (select hoi3.organization_id
1236: from HR_ORGANIZATION_UNITS o1
1237: , HR_ORGANIZATION_INFORMATION hoi1
1238: , HR_ORGANIZATION_INFORMATION hoi2
1239: , HR_ORGANIZATION_INFORMATION hoi3
1240: WHERE o1.business_group_id =l_business_group_id
1241: and hoi1.organization_id = o1.organization_id
1242: and hoi1.organization_id = l_organization_id

Line 1239: , HR_ORGANIZATION_INFORMATION hoi3

1235: (select hoi3.organization_id
1236: from HR_ORGANIZATION_UNITS o1
1237: , HR_ORGANIZATION_INFORMATION hoi1
1238: , HR_ORGANIZATION_INFORMATION hoi2
1239: , HR_ORGANIZATION_INFORMATION hoi3
1240: WHERE o1.business_group_id =l_business_group_id
1241: and hoi1.organization_id = o1.organization_id
1242: and hoi1.organization_id = l_organization_id
1243: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1254: , HR_ORGANIZATION_INFORMATION hoi1

1250:
1251: */ CURSOR main_lc IS
1252: select count(hoi2.org_information6)
1253: from HR_ALL_ORGANIZATION_UNITS o1
1254: , HR_ORGANIZATION_INFORMATION hoi1
1255: , HR_ORGANIZATION_INFORMATION hoi2
1256: , HR_ORGANIZATION_INFORMATION hoi3
1257: , HR_ORGANIZATION_INFORMATION hoi4
1258: WHERE o1.business_group_id =l_business_group_id

Line 1255: , HR_ORGANIZATION_INFORMATION hoi2

1251: */ CURSOR main_lc IS
1252: select count(hoi2.org_information6)
1253: from HR_ALL_ORGANIZATION_UNITS o1
1254: , HR_ORGANIZATION_INFORMATION hoi1
1255: , HR_ORGANIZATION_INFORMATION hoi2
1256: , HR_ORGANIZATION_INFORMATION hoi3
1257: , HR_ORGANIZATION_INFORMATION hoi4
1258: WHERE o1.business_group_id =l_business_group_id
1259: and hoi1.organization_id = o1.organization_id

Line 1256: , HR_ORGANIZATION_INFORMATION hoi3

1252: select count(hoi2.org_information6)
1253: from HR_ALL_ORGANIZATION_UNITS o1
1254: , HR_ORGANIZATION_INFORMATION hoi1
1255: , HR_ORGANIZATION_INFORMATION hoi2
1256: , HR_ORGANIZATION_INFORMATION hoi3
1257: , HR_ORGANIZATION_INFORMATION hoi4
1258: WHERE o1.business_group_id =l_business_group_id
1259: and hoi1.organization_id = o1.organization_id
1260: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1257: , HR_ORGANIZATION_INFORMATION hoi4

1253: from HR_ALL_ORGANIZATION_UNITS o1
1254: , HR_ORGANIZATION_INFORMATION hoi1
1255: , HR_ORGANIZATION_INFORMATION hoi2
1256: , HR_ORGANIZATION_INFORMATION hoi3
1257: , HR_ORGANIZATION_INFORMATION hoi4
1258: WHERE o1.business_group_id =l_business_group_id
1259: and hoi1.organization_id = o1.organization_id
1260: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1261: and hoi1.org_information_context = 'CLASS'

Line 1277: , HR_ORGANIZATION_INFORMATION hoi1

1273:
1274: CURSOR main_lc_le IS
1275: select count(hoi2.org_information6)
1276: from HR_ORGANIZATION_UNITS o1
1277: , HR_ORGANIZATION_INFORMATION hoi1
1278: , HR_ORGANIZATION_INFORMATION hoi2
1279: WHERE o1.business_group_id =l_business_group_id
1280: and hoi1.organization_id = o1.organization_id
1281: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1278: , HR_ORGANIZATION_INFORMATION hoi2

1274: CURSOR main_lc_le IS
1275: select count(hoi2.org_information6)
1276: from HR_ORGANIZATION_UNITS o1
1277: , HR_ORGANIZATION_INFORMATION hoi1
1278: , HR_ORGANIZATION_INFORMATION hoi2
1279: WHERE o1.business_group_id =l_business_group_id
1280: and hoi1.organization_id = o1.organization_id
1281: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1282: and hoi1.org_information_context = 'CLASS'

Line 1290: , HR_ORGANIZATION_INFORMATION hoi1

1286: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1287: and hoi1.organization_id in
1288: (select hoi1.organization_id
1289: from HR_ORGANIZATION_UNITS o1
1290: , HR_ORGANIZATION_INFORMATION hoi1
1291: , HR_ORGANIZATION_INFORMATION hoi2
1292: , HR_ORGANIZATION_INFORMATION hoi3
1293: WHERE o1.business_group_id =l_business_group_id
1294: and hoi1.organization_id = o1.organization_id

Line 1291: , HR_ORGANIZATION_INFORMATION hoi2

1287: and hoi1.organization_id in
1288: (select hoi1.organization_id
1289: from HR_ORGANIZATION_UNITS o1
1290: , HR_ORGANIZATION_INFORMATION hoi1
1291: , HR_ORGANIZATION_INFORMATION hoi2
1292: , HR_ORGANIZATION_INFORMATION hoi3
1293: WHERE o1.business_group_id =l_business_group_id
1294: and hoi1.organization_id = o1.organization_id
1295: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1292: , HR_ORGANIZATION_INFORMATION hoi3

1288: (select hoi1.organization_id
1289: from HR_ORGANIZATION_UNITS o1
1290: , HR_ORGANIZATION_INFORMATION hoi1
1291: , HR_ORGANIZATION_INFORMATION hoi2
1292: , HR_ORGANIZATION_INFORMATION hoi3
1293: WHERE o1.business_group_id =l_business_group_id
1294: and hoi1.organization_id = o1.organization_id
1295: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1296: and hoi1.org_information_context = 'CLASS'

Line 1306: , HR_ORGANIZATION_INFORMATION hoi1

1302: and hoi2.org_information_id <> p_org_information_id
1303: AND hoi3.organization_id = l_organization_id );*/
1304: CURSOR main_lc_le IS select count(hoi2.org_information6)
1305: from HR_ALL_ORGANIZATION_UNITS o1
1306: , HR_ORGANIZATION_INFORMATION hoi1
1307: , HR_ORGANIZATION_INFORMATION hoi2
1308: , HR_ORGANIZATION_INFORMATION hoi3
1309: , HR_ORGANIZATION_INFORMATION hoi4
1310: WHERE o1.business_group_id =l_business_group_id

Line 1307: , HR_ORGANIZATION_INFORMATION hoi2

1303: AND hoi3.organization_id = l_organization_id );*/
1304: CURSOR main_lc_le IS select count(hoi2.org_information6)
1305: from HR_ALL_ORGANIZATION_UNITS o1
1306: , HR_ORGANIZATION_INFORMATION hoi1
1307: , HR_ORGANIZATION_INFORMATION hoi2
1308: , HR_ORGANIZATION_INFORMATION hoi3
1309: , HR_ORGANIZATION_INFORMATION hoi4
1310: WHERE o1.business_group_id =l_business_group_id
1311: and hoi1.organization_id = o1.organization_id

Line 1308: , HR_ORGANIZATION_INFORMATION hoi3

1304: CURSOR main_lc_le IS select count(hoi2.org_information6)
1305: from HR_ALL_ORGANIZATION_UNITS o1
1306: , HR_ORGANIZATION_INFORMATION hoi1
1307: , HR_ORGANIZATION_INFORMATION hoi2
1308: , HR_ORGANIZATION_INFORMATION hoi3
1309: , HR_ORGANIZATION_INFORMATION hoi4
1310: WHERE o1.business_group_id =l_business_group_id
1311: and hoi1.organization_id = o1.organization_id
1312: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1309: , HR_ORGANIZATION_INFORMATION hoi4

1305: from HR_ALL_ORGANIZATION_UNITS o1
1306: , HR_ORGANIZATION_INFORMATION hoi1
1307: , HR_ORGANIZATION_INFORMATION hoi2
1308: , HR_ORGANIZATION_INFORMATION hoi3
1309: , HR_ORGANIZATION_INFORMATION hoi4
1310: WHERE o1.business_group_id =l_business_group_id
1311: and hoi1.organization_id = o1.organization_id
1312: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1313: and hoi1.org_information_context = 'CLASS'

Line 1329: , HR_ORGANIZATION_INFORMATION hoi1

1325: /*
1326: CURSOR ast_number_le IS
1327: select count(hoi2.org_information1)
1328: from HR_ORGANIZATION_UNITS o1
1329: , HR_ORGANIZATION_INFORMATION hoi1
1330: , HR_ORGANIZATION_INFORMATION hoi2
1331: WHERE o1.business_group_id =l_business_group_id
1332: and hoi1.organization_id = o1.organization_id
1333: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1330: , HR_ORGANIZATION_INFORMATION hoi2

1326: CURSOR ast_number_le IS
1327: select count(hoi2.org_information1)
1328: from HR_ORGANIZATION_UNITS o1
1329: , HR_ORGANIZATION_INFORMATION hoi1
1330: , HR_ORGANIZATION_INFORMATION hoi2
1331: WHERE o1.business_group_id =l_business_group_id
1332: and hoi1.organization_id = o1.organization_id
1333: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1334: and hoi1.org_information_context = 'CLASS'

Line 1341: , HR_ORGANIZATION_INFORMATION hoi1

1337: and hoi2.ORG_INFORMATION_CONTEXT='SE_LOCAL_UNIT_DETAILS'
1338: and hoi2.org_information1 in
1339: (select hoi2.org_information1
1340: from HR_ORGANIZATION_UNITS o1
1341: , HR_ORGANIZATION_INFORMATION hoi1
1342: , HR_ORGANIZATION_INFORMATION hoi2
1343: WHERE o1.business_group_id =l_business_group_id
1344: and hoi1.organization_id = o1.organization_id
1345: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1342: , HR_ORGANIZATION_INFORMATION hoi2

1338: and hoi2.org_information1 in
1339: (select hoi2.org_information1
1340: from HR_ORGANIZATION_UNITS o1
1341: , HR_ORGANIZATION_INFORMATION hoi1
1342: , HR_ORGANIZATION_INFORMATION hoi2
1343: WHERE o1.business_group_id =l_business_group_id
1344: and hoi1.organization_id = o1.organization_id
1345: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1346: and hoi1.org_information_context = 'CLASS'

Line 1354: , HR_ORGANIZATION_INFORMATION hoi1

1350: )
1351: and hoi1.organization_id in
1352: (select hoi1.organization_id
1353: from HR_ORGANIZATION_UNITS o1
1354: , HR_ORGANIZATION_INFORMATION hoi1
1355: , HR_ORGANIZATION_INFORMATION hoi2
1356: , HR_ORGANIZATION_INFORMATION hoi3
1357: WHERE o1.business_group_id =l_business_group_id
1358: and hoi1.organization_id = o1.organization_id

Line 1355: , HR_ORGANIZATION_INFORMATION hoi2

1351: and hoi1.organization_id in
1352: (select hoi1.organization_id
1353: from HR_ORGANIZATION_UNITS o1
1354: , HR_ORGANIZATION_INFORMATION hoi1
1355: , HR_ORGANIZATION_INFORMATION hoi2
1356: , HR_ORGANIZATION_INFORMATION hoi3
1357: WHERE o1.business_group_id =l_business_group_id
1358: and hoi1.organization_id = o1.organization_id
1359: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1356: , HR_ORGANIZATION_INFORMATION hoi3

1352: (select hoi1.organization_id
1353: from HR_ORGANIZATION_UNITS o1
1354: , HR_ORGANIZATION_INFORMATION hoi1
1355: , HR_ORGANIZATION_INFORMATION hoi2
1356: , HR_ORGANIZATION_INFORMATION hoi3
1357: WHERE o1.business_group_id =l_business_group_id
1358: and hoi1.organization_id = o1.organization_id
1359: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1360: and hoi1.org_information_context = 'CLASS'

Line 1372: , HR_ORGANIZATION_INFORMATION hoi1

1368: */
1369: CURSOR ast_number_le IS
1370: select count(hoi2.org_information1)
1371: from HR_ALL_ORGANIZATION_UNITS o1
1372: , HR_ORGANIZATION_INFORMATION hoi1
1373: , HR_ORGANIZATION_INFORMATION hoi2
1374: , HR_ORGANIZATION_INFORMATION hoi3
1375: , HR_ORGANIZATION_INFORMATION hoi4
1376: , HR_ORGANIZATION_INFORMATION hoi5

Line 1373: , HR_ORGANIZATION_INFORMATION hoi2

1369: CURSOR ast_number_le IS
1370: select count(hoi2.org_information1)
1371: from HR_ALL_ORGANIZATION_UNITS o1
1372: , HR_ORGANIZATION_INFORMATION hoi1
1373: , HR_ORGANIZATION_INFORMATION hoi2
1374: , HR_ORGANIZATION_INFORMATION hoi3
1375: , HR_ORGANIZATION_INFORMATION hoi4
1376: , HR_ORGANIZATION_INFORMATION hoi5
1377: WHERE o1.business_group_id =l_business_group_id

Line 1374: , HR_ORGANIZATION_INFORMATION hoi3

1370: select count(hoi2.org_information1)
1371: from HR_ALL_ORGANIZATION_UNITS o1
1372: , HR_ORGANIZATION_INFORMATION hoi1
1373: , HR_ORGANIZATION_INFORMATION hoi2
1374: , HR_ORGANIZATION_INFORMATION hoi3
1375: , HR_ORGANIZATION_INFORMATION hoi4
1376: , HR_ORGANIZATION_INFORMATION hoi5
1377: WHERE o1.business_group_id =l_business_group_id
1378: and hoi1.organization_id = o1.organization_id

Line 1375: , HR_ORGANIZATION_INFORMATION hoi4

1371: from HR_ALL_ORGANIZATION_UNITS o1
1372: , HR_ORGANIZATION_INFORMATION hoi1
1373: , HR_ORGANIZATION_INFORMATION hoi2
1374: , HR_ORGANIZATION_INFORMATION hoi3
1375: , HR_ORGANIZATION_INFORMATION hoi4
1376: , HR_ORGANIZATION_INFORMATION hoi5
1377: WHERE o1.business_group_id =l_business_group_id
1378: and hoi1.organization_id = o1.organization_id
1379: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1376: , HR_ORGANIZATION_INFORMATION hoi5

1372: , HR_ORGANIZATION_INFORMATION hoi1
1373: , HR_ORGANIZATION_INFORMATION hoi2
1374: , HR_ORGANIZATION_INFORMATION hoi3
1375: , HR_ORGANIZATION_INFORMATION hoi4
1376: , HR_ORGANIZATION_INFORMATION hoi5
1377: WHERE o1.business_group_id =l_business_group_id
1378: and hoi1.organization_id = o1.organization_id
1379: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1380: and hoi1.org_information_context = 'CLASS'

Line 1398: ,HR_ORGANIZATION_INFORMATION hoi1

1394:
1395: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
1396: select count(hoi1.org_information1)
1397: from HR_ALL_ORGANIZATION_UNITS o1
1398: ,HR_ORGANIZATION_INFORMATION hoi1
1399: ,HR_ORGANIZATION_INFORMATION hoi2
1400: WHERE o1.business_group_id =l_business_group_id
1401: and o1.organization_id=hoi1.organization_id
1402: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 1399: ,HR_ORGANIZATION_INFORMATION hoi2

1395: CURSOR tax_lc(l_param1 varchar2,l_param2 number) IS
1396: select count(hoi1.org_information1)
1397: from HR_ALL_ORGANIZATION_UNITS o1
1398: ,HR_ORGANIZATION_INFORMATION hoi1
1399: ,HR_ORGANIZATION_INFORMATION hoi2
1400: WHERE o1.business_group_id =l_business_group_id
1401: and o1.organization_id=hoi1.organization_id
1402: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
1403: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1414: ,HR_ORGANIZATION_INFORMATION hoi1

1410:
1411: CURSOR absence_cat_limit(l_param1 varchar2) IS
1412: select count(hoi1.org_information1)
1413: from HR_ALL_ORGANIZATION_UNITS o1
1414: ,HR_ORGANIZATION_INFORMATION hoi1
1415: ,HR_ORGANIZATION_INFORMATION hoi2
1416: WHERE o1.business_group_id =l_business_group_id
1417: and o1.organization_id=hoi1.organization_id
1418: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'

Line 1415: ,HR_ORGANIZATION_INFORMATION hoi2

1411: CURSOR absence_cat_limit(l_param1 varchar2) IS
1412: select count(hoi1.org_information1)
1413: from HR_ALL_ORGANIZATION_UNITS o1
1414: ,HR_ORGANIZATION_INFORMATION hoi1
1415: ,HR_ORGANIZATION_INFORMATION hoi2
1416: WHERE o1.business_group_id =l_business_group_id
1417: and o1.organization_id=hoi1.organization_id
1418: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'
1419: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1429: , HR_ORGANIZATION_INFORMATION hoi1

1425:
1426: CURSOR org_number IS
1427: select count(hoi2.org_information2)
1428: from HR_ALL_ORGANIZATION_UNITS o1
1429: , HR_ORGANIZATION_INFORMATION hoi1
1430: , HR_ORGANIZATION_INFORMATION hoi2
1431: WHERE o1.business_group_id =l_business_group_id
1432: and hoi1.organization_id = o1.organization_id
1433: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 1430: , HR_ORGANIZATION_INFORMATION hoi2

1426: CURSOR org_number IS
1427: select count(hoi2.org_information2)
1428: from HR_ALL_ORGANIZATION_UNITS o1
1429: , HR_ORGANIZATION_INFORMATION hoi1
1430: , HR_ORGANIZATION_INFORMATION hoi2
1431: WHERE o1.business_group_id =l_business_group_id
1432: and hoi1.organization_id = o1.organization_id
1433: and hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
1434: and hoi1.org_information_context = 'CLASS'

Line 1444: , HR_ORGANIZATION_INFORMATION hoi1

1440:
1441: CURSOR main_lc_status IS
1442: select hoi2.org_information6
1443: from HR_ALL_ORGANIZATION_UNITS o1
1444: , HR_ORGANIZATION_INFORMATION hoi1
1445: , HR_ORGANIZATION_INFORMATION hoi2
1446: WHERE o1.business_group_id =l_business_group_id
1447: and hoi1.organization_id = o1.organization_id
1448: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 1445: , HR_ORGANIZATION_INFORMATION hoi2

1441: CURSOR main_lc_status IS
1442: select hoi2.org_information6
1443: from HR_ALL_ORGANIZATION_UNITS o1
1444: , HR_ORGANIZATION_INFORMATION hoi1
1445: , HR_ORGANIZATION_INFORMATION hoi2
1446: WHERE o1.business_group_id =l_business_group_id
1447: and hoi1.organization_id = o1.organization_id
1448: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
1449: and hoi1.org_information_context = 'CLASS'

Line 1460: FROM hr_organization_information hoi, hr_all_organization_units ou

1456:
1457:
1458: CURSOR c_upd_le_ap_dtls IS
1459: SELECT COUNT(*)
1460: FROM hr_organization_information hoi, hr_all_organization_units ou
1461: WHERE (hoi.org_information_context = 'SE_COMPANY_MILEAGE_RATES')
1462: AND ou.organization_id = hoi.organization_id
1463: AND ou.organization_id = nvl(l_organization_id , 0)
1464: AND ou.business_group_id = l_business_group_id

Line 1478: FROM hr_organization_information

1474:
1475: CURSOR c_legal IS
1476: SELECT ORG_INFORMATION1,ORG_INFORMATION2,
1477: ORG_INFORMATION3,ORG_INFORMATION4
1478: FROM hr_organization_information
1479: WHERE org_information_id=p_org_information_id;
1480:
1481: CURSOR csr_global(csr_v_global VARCHAR2 )IS
1482: SELECT nvl(global_value,0) FROM ff_globals_f,

Line 1503: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s

1499: l_agreement_meaning varchar2(50);
1500:
1501: CURSOR csr_year IS
1502: SELECT count(*)
1503: FROM hr_organization_information hoi, hr_organization_units ou, fnd_sessions s
1504: WHERE hoi.org_information_context = 'SE_STD_WORK_DETAILS'
1505: AND ou.organization_id = hoi.organization_id
1506: AND ou.organization_id = nvl (l_organization_id, 0)
1507: AND ou.business_group_id = l_business_group_id