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.BEN_EXTRACT_SEED dependencies on HR_LOOKUPS

Line 279: --- this function also allow to extract the lookup code , the criteria is from hr lookups

275:
276: -----------------------------------------------------
277: --- This function is added to get the lookup code
278: --- so far the ldt extract the name that is creating a issue when the lookup meaning are changed
279: --- this function also allow to extract the lookup code , the criteria is from hr lookups
280: -- if the criteria from master tables like person name then return null for the code
281: ------------------------------------------------------
282:
283: Function get_lookup_code (p_crit_typ_cd in VARCHAR2

Line 292: select 'x' from hr_lookups

288:
289:
290:
291: cursor find_lookup ( p_lookup_type in varchar2) is
292: select 'x' from hr_lookups
293: where lookup_type = p_lookup_type
294: and lookup_code = p_val
295: ;
296:

Line 299: l_lookup_type hr_lookups.lookup_type%type ;

295: ;
296:
297: l_return_val varchar2(30) ;
298: l_dummy varchar2(1) ;
299: l_lookup_type hr_lookups.lookup_type%type ;
300:
301: Begin
302:
303:

Line 389: from hr_lookups

385: l_crit_cmbn varchar2(2000) := '';
386: --value varchar2(80) := ''; UTF8IK
387: value varchar2(240) := '';
388: cursor c1 is select meaning
389: from hr_lookups
390: where lookup_type = 'US_STATE'
391: and lookup_code = p_val;
392:
393:

Line 497: from hr_lookups

493: and rptg_grp_id = p_val;
494: */
495:
496: cursor cf is select meaning
497: from hr_lookups
498: where lookup_type = 'BEN_PER_IN_LER_STAT'
499: and lookup_code = p_val;
500:
501:

Line 503: from hr_lookups

499: and lookup_code = p_val;
500:
501:
502: cursor cg is select meaning
503: from hr_lookups
504: where lookup_type = 'BEN_EXT_SUSPEND'
505: and lookup_code = p_val;
506:
507: cursor ch is select name

Line 537: from hr_lookups

533: and rptg_grp_id = p_val;
534:
535:
536: cursor cl is select meaning
537: from hr_lookups
538: where lookup_type = 'BEN_EXT_CRIT_MISC'
539: and lookup_code = p_val;
540:
541:

Line 556: from hr_lookups

552: where business_group_id = p_business_group_id
553: and yr_perd_id = p_val;
554:
555: cursor co is select meaning
556: from hr_lookups
557: where lookup_type = 'BEN_EXT_CRIT_MISC'
558: and lookup_code = p_val;
559:
560: cursor cp is select meaning

Line 561: from hr_lookups

557: where lookup_type = 'BEN_EXT_CRIT_MISC'
558: and lookup_code = p_val;
559:
560: cursor cp is select meaning
561: from hr_lookups
562: where lookup_type = 'BEN_EXT_SUSPEND'
563: and lookup_code = p_val;
564:
565: cursor cq is select meaning

Line 566: from hr_lookups

562: where lookup_type = 'BEN_EXT_SUSPEND'
563: and lookup_code = p_val;
564:
565: cursor cq is select meaning
566: from hr_lookups
567: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
568: and lookup_code = p_val;
569:
570: cursor cr is select meaning

Line 571: from hr_lookups

567: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
568: and lookup_code = p_val;
569:
570: cursor cr is select meaning
571: from hr_lookups
572: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
573: and lookup_code = p_val;
574:
575: cursor cs is select meaning

Line 576: from hr_lookups

572: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
573: and lookup_code = p_val;
574:
575: cursor cs is select meaning
576: from hr_lookups
577: where lookup_type = 'BEN_EXT_DT'
578: and lookup_code = p_val;
579:
580: cursor ct is select name

Line 586: from hr_lookups

582: where actn_typ_id = p_val ;
583:
584:
585: cursor cu is select meaning
586: from hr_lookups
587: where lookup_type = 'BEN_EXT_DT'
588: and lookup_code = p_val
589: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
590: and nvl(end_date_active, trunc(sysdate))

Line 596: from hr_lookups

592:
593:
594:
595: cursor cv is select meaning
596: from hr_lookups
597: where lookup_type = 'BEN_EXT_DT'
598: and lookup_code = p_val
599: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
600: and nvl(end_date_active, trunc(sysdate))

Line 604: from hr_lookups

600: and nvl(end_date_active, trunc(sysdate))
601: ;
602:
603: cursor cw is select meaning
604: from hr_lookups
605: where lookup_type = 'BEN_EXT_CHG_EVT'
606: and lookup_code = p_val
607: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
608: and nvl(end_date_active, trunc(sysdate)) ;

Line 622: from hr_lookups

618: and trunc(sysdate) between nvl(start_date, trunc(sysdate))
619: and nvl(end_date, trunc(sysdate));
620:
621: cursor cy is select meaning
622: from hr_lookups
623: where lookup_type = 'BEN_EXT_DT'
624: and lookup_code = p_val
625: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
626: and nvl(end_date_active, trunc(sysdate))

Line 630: from hr_lookups

626: and nvl(end_date_active, trunc(sysdate))
627: ;
628:
629: cursor cz is select meaning
630: from hr_lookups
631: where lookup_type = 'BEN_EXT_DT'
632: and lookup_code = p_val
633: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
634: and nvl(end_date_active, trunc(sysdate))

Line 638: from hr_lookups

634: and nvl(end_date_active, trunc(sysdate))
635: ;
636:
637: cursor caa is select meaning
638: from hr_lookups
639: where lookup_type = 'BEN_EXT_DT'
640: and lookup_code = p_val
641: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
642: and nvl(end_date_active, trunc(sysdate))

Line 646: from hr_lookups

642: and nvl(end_date_active, trunc(sysdate))
643: ;
644:
645: cursor cab is select meaning
646: from hr_lookups
647: where lookup_type = 'BEN_EXT_DT'
648: and lookup_code = p_val
649: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
650: and nvl(end_date_active, trunc(sysdate))

Line 654: from hr_lookups

650: and nvl(end_date_active, trunc(sysdate))
651: ;
652:
653: cursor cac is select meaning
654: from hr_lookups
655: where lookup_type = 'BEN_EXT_DT'
656: and lookup_code = p_val
657: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
658: and nvl(end_date_active, trunc(sysdate))

Line 662: from hr_lookups

658: and nvl(end_date_active, trunc(sysdate))
659: ;
660:
661: cursor cad is select meaning
662: from hr_lookups
663: where lookup_type = 'BEN_EXT_DT'
664: and lookup_code = p_val
665: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
666: and nvl(end_date_active, trunc(sysdate))

Line 670: from hr_lookups

666: and nvl(end_date_active, trunc(sysdate))
667: ;
668:
669: cursor cae is select meaning
670: from hr_lookups
671: where lookup_type = 'BEN_EXT_DT'
672: and lookup_code = p_val
673: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
674: and nvl(end_date_active, trunc(sysdate))

Line 678: from hr_lookups

674: and nvl(end_date_active, trunc(sysdate))
675: ;
676:
677: cursor caf is select meaning
678: from hr_lookups
679: where lookup_type = 'BEN_EXT_DT'
680: and lookup_code = p_val
681: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
682: and nvl(end_date_active, trunc(sysdate))

Line 686: from hr_lookups

682: and nvl(end_date_active, trunc(sysdate))
683: ;
684:
685: cursor cag is select meaning
686: from hr_lookups
687: where lookup_type = 'BEN_EXT_DT'
688: and lookup_code = p_val
689: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
690: and nvl(end_date_active, trunc(sysdate))

Line 695: from hr_lookups

691: ;
692:
693:
694: cursor cah is select meaning
695: from hr_lookups
696: where lookup_type = 'BEN_EXT_DT'
697: and lookup_code = p_val
698: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
699: and nvl(end_date_active, trunc(sysdate))

Line 706: from hr_lookups

702:
703: cursor c_val1_dt
704: is
705: select meaning
706: from hr_lookups
707: where lookup_type = 'BEN_EXT_DT'
708: and lookup_code = p_val;
709:
710: cursor c_val2_dt

Line 713: from hr_lookups

709:
710: cursor c_val2_dt
711: is
712: select meaning
713: from hr_lookups
714: where lookup_type = 'BEN_EXT_DT'
715: and lookup_code = p_val;
716:
717: cursor c_val1_chg_evt

Line 720: from hr_lookups

716:
717: cursor c_val1_chg_evt
718: is
719: select meaning
720: from hr_lookups
721: where lookup_type = 'BEN_EXT_CHG_EVT'
722: and lookup_code = p_val;
723:
724: cursor c_val2_chg_evt

Line 727: from hr_lookups

723:
724: cursor c_val2_chg_evt
725: is
726: select meaning
727: from hr_lookups
728: where lookup_type = 'BEN_EXT_CHG_EVT'
729: and lookup_code = p_val;
730:
731: cursor c_oper

Line 734: from hr_lookups

730:
731: cursor c_oper
732: is
733: select meaning
734: from hr_lookups
735: where lookup_type = 'BEN_EXT_TTL_COND_OPER'
736: and lookup_code = p_val; --p_oper_cd;
737:
738:

Line 742: from hr_lookups

738:
739: cursor c_pasu
740: is
741: select meaning
742: from hr_lookups
743: where lookup_type = 'BEN_EXT_ASMT_TO_USE'
744: and lookup_code = p_val; -- value for the criteria Person Assignment To Use
745:
746: CURSOR Cai IS

Line 748: from HR_LOOKUPS

744: and lookup_code = p_val; -- value for the criteria Person Assignment To Use
745:
746: CURSOR Cai IS
747: select MEANING
748: from HR_LOOKUPS
749: where LOOKUP_CODE = p_crit_typ_cd
750: and lookup_type = 'BEN_EXT_CRIT_TYP'
751: and substr(lookup_code, 1, 1) = 'C'
752: and lookup_code not in ('CBU')

Line 761: from hr_lookups

757:
758: cursor c_berenm
759: is
760: select meaning
761: from hr_lookups
762: where lookup_type = 'BEN_ENRT_MTHD'
763: and lookup_code = p_val; -- value for the criteria Enrollment method
764:
765:

Line 775: from hr_lookups

771:
772:
773: cursor c_lookup(p_type varchar2) is
774: select meaning
775: from hr_lookups
776: where lookup_type = p_type
777: and lookup_code = p_val; --
778:
779: cursor c_job is

Line 1138: from hr_lookups

1134: -- value varchar2(80) := ''; UTF8IK
1135: value varchar2(600):= '';
1136:
1137: cursor c1 is select lookup_code
1138: from hr_lookups
1139: where lookup_type = 'US_STATE'
1140: and meaning = p_meaning
1141: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1142: and nvl(end_date_active, trunc(sysdate))

Line 1263: from hr_lookups

1259: and rptg_grp_id = p_val_1;
1260: */
1261:
1262: cursor cf is select lookup_code
1263: from hr_lookups
1264: where lookup_type = 'BEN_PER_IN_LER_STAT'
1265: and meaning = p_meaning;
1266:
1267: cursor cg is select lookup_code

Line 1268: from hr_lookups

1264: where lookup_type = 'BEN_PER_IN_LER_STAT'
1265: and meaning = p_meaning;
1266:
1267: cursor cg is select lookup_code
1268: from hr_lookups
1269: where lookup_type = 'BEN_EXT_SUSPEND'
1270: and meaning = p_meaning;
1271:
1272: cursor ch is select name

Line 1301: from hr_lookups

1297: where business_group_id = p_business_group_id
1298: and name = p_meaning ;
1299:
1300: cursor cl is select lookup_code
1301: from hr_lookups
1302: where lookup_type = 'BEN_EXT_CRIT_MISC'
1303: and meaning = p_meaning;
1304:
1305:

Line 1320: from hr_lookups

1316: where business_group_id = p_business_group_id
1317: and start_date||' - '||end_date = p_meaning;
1318:
1319: cursor co is select lookup_code
1320: from hr_lookups
1321: where lookup_type = 'BEN_EXT_CRIT_MISC'
1322: and meaning = p_meaning;
1323:
1324: cursor cp is select lookup_code

Line 1325: from hr_lookups

1321: where lookup_type = 'BEN_EXT_CRIT_MISC'
1322: and meaning = p_meaning;
1323:
1324: cursor cp is select lookup_code
1325: from hr_lookups
1326: where lookup_type = 'BEN_EXT_SUSPEND'
1327: and meaning = p_meaning;
1328:
1329: cursor cq is select lookup_code

Line 1330: from hr_lookups

1326: where lookup_type = 'BEN_EXT_SUSPEND'
1327: and meaning = p_meaning;
1328:
1329: cursor cq is select lookup_code
1330: from hr_lookups
1331: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
1332: and meaning = p_meaning;
1333:
1334: cursor cr is select lookup_code

Line 1335: from hr_lookups

1331: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
1332: and meaning = p_meaning;
1333:
1334: cursor cr is select lookup_code
1335: from hr_lookups
1336: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
1337: and meaning = p_meaning;
1338:
1339: cursor cs is select lookup_code

Line 1340: from hr_lookups

1336: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
1337: and meaning = p_meaning;
1338:
1339: cursor cs is select lookup_code
1340: from hr_lookups
1341: where lookup_type = 'BEN_EXT_DT'
1342: and meaning = p_meaning;
1343:
1344: cursor ct is select actn_typ_id

Line 1351: from hr_lookups

1347:
1348:
1349:
1350: cursor cu is select lookup_code
1351: from hr_lookups
1352: where lookup_type = 'BEN_EXT_DT'
1353: and meaning = p_meaning
1354: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1355: and nvl(end_date_active, trunc(sysdate))

Line 1361: from hr_lookups

1357:
1358:
1359:
1360: cursor cv is select lookup_code
1361: from hr_lookups
1362: where lookup_type = 'BEN_EXT_DT'
1363: and meaning = p_meaning
1364: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1365: and nvl(end_date_active, trunc(sysdate))

Line 1369: from hr_lookups

1365: and nvl(end_date_active, trunc(sysdate))
1366: ;
1367:
1368: cursor cw is select lookup_code
1369: from hr_lookups
1370: where lookup_type = 'BEN_EXT_CHG_EVT'
1371: and meaning = p_meaning
1372: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1373: and nvl(end_date_active, trunc(sysdate))

Line 1389: from hr_lookups

1385: and trunc(sysdate) between nvl(start_date, trunc(sysdate))
1386: and nvl(end_date, trunc(sysdate));
1387:
1388: cursor cy is select lookup_code
1389: from hr_lookups
1390: where lookup_type = 'BEN_EXT_DT'
1391: and meaning = p_meaning
1392: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1393: and nvl(end_date_active, trunc(sysdate))

Line 1397: from hr_lookups

1393: and nvl(end_date_active, trunc(sysdate))
1394: ;
1395:
1396: cursor cz is select lookup_code
1397: from hr_lookups
1398: where lookup_type = 'BEN_EXT_DT'
1399: and meaning = p_meaning
1400: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1401: and nvl(end_date_active, trunc(sysdate))

Line 1405: from hr_lookups

1401: and nvl(end_date_active, trunc(sysdate))
1402: ;
1403:
1404: cursor caa is select lookup_code
1405: from hr_lookups
1406: where lookup_type = 'BEN_EXT_DT'
1407: and meaning = p_meaning
1408: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1409: and nvl(end_date_active, trunc(sysdate))

Line 1413: from hr_lookups

1409: and nvl(end_date_active, trunc(sysdate))
1410: ;
1411:
1412: cursor cab is select lookup_code
1413: from hr_lookups
1414: where lookup_type = 'BEN_EXT_DT'
1415: and meaning = p_meaning
1416: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1417: and nvl(end_date_active, trunc(sysdate))

Line 1422: from hr_lookups

1418: ;
1419:
1420:
1421: cursor cac is select lookup_code
1422: from hr_lookups
1423: where lookup_type = 'BEN_EXT_DT'
1424: and meaning = p_meaning
1425: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1426: and nvl(end_date_active, trunc(sysdate))

Line 1430: from hr_lookups

1426: and nvl(end_date_active, trunc(sysdate))
1427: ;
1428:
1429: cursor cad is select lookup_code
1430: from hr_lookups
1431: where lookup_type = 'BEN_EXT_DT'
1432: and meaning = p_meaning
1433: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1434: and nvl(end_date_active, trunc(sysdate))

Line 1438: from hr_lookups

1434: and nvl(end_date_active, trunc(sysdate))
1435: ;
1436:
1437: cursor cae is select lookup_code
1438: from hr_lookups
1439: where lookup_type = 'BEN_EXT_DT'
1440: and meaning = p_meaning
1441: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1442: and nvl(end_date_active, trunc(sysdate))

Line 1446: from hr_lookups

1442: and nvl(end_date_active, trunc(sysdate))
1443: ;
1444:
1445: cursor caf is select lookup_code
1446: from hr_lookups
1447: where lookup_type = 'BEN_EXT_DT'
1448: and meaning = p_meaning
1449: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1450: and nvl(end_date_active, trunc(sysdate))

Line 1454: from hr_lookups

1450: and nvl(end_date_active, trunc(sysdate))
1451: ;
1452:
1453: cursor cag is select lookup_code
1454: from hr_lookups
1455: where lookup_type = 'BEN_EXT_DT'
1456: and meaning = p_meaning
1457: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1458: and nvl(end_date_active, trunc(sysdate))

Line 1463: from hr_lookups

1459: ;
1460:
1461:
1462: cursor cah is select lookup_code
1463: from hr_lookups
1464: where lookup_type = 'BEN_EXT_DT'
1465: and meaning = p_meaning
1466: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1467: and nvl(end_date_active, trunc(sysdate))

Line 1474: from hr_lookups

1470:
1471: cursor c_val1_dt
1472: is
1473: select lookup_code
1474: from hr_lookups
1475: where lookup_type = 'BEN_EXT_DT'
1476: and meaning = p_meaning;
1477:
1478: cursor c_val2_dt

Line 1481: from hr_lookups

1477:
1478: cursor c_val2_dt
1479: is
1480: select lookup_code
1481: from hr_lookups
1482: where lookup_type = 'BEN_EXT_DT'
1483: and meaning = p_meaning;
1484:
1485: cursor c_val1_chg_evt

Line 1488: from hr_lookups

1484:
1485: cursor c_val1_chg_evt
1486: is
1487: select lookup_code
1488: from hr_lookups
1489: where lookup_type = 'BEN_EXT_CHG_EVT'
1490: and meaning = p_meaning;
1491:
1492: cursor c_val2_chg_evt

Line 1495: from hr_lookups

1491:
1492: cursor c_val2_chg_evt
1493: is
1494: select lookup_code
1495: from hr_lookups
1496: where lookup_type = 'BEN_EXT_CHG_EVT'
1497: and meaning = p_meaning;
1498:
1499: cursor c_oper

Line 1502: from hr_lookups

1498:
1499: cursor c_oper
1500: is
1501: select lookup_code
1502: from hr_lookups
1503: where lookup_type = 'BEN_EXT_TTL_COND_OPER'
1504: and meaning = p_meaning; --p_oper_cd;
1505:
1506:

Line 1509: from HR_LOOKUPS

1505:
1506:
1507: CURSOR Cai IS
1508: select lookup_code
1509: from HR_LOOKUPS
1510: where LOOKUP_CODE = p_crit_typ_cd
1511: and lookup_type = 'BEN_EXT_CRIT_TYP'
1512: and substr(lookup_code, 1, 1) = 'C'
1513: and lookup_code not in ('CBU')

Line 1522: from hr_lookups

1518:
1519: cursor c_pasu
1520: is
1521: select lookup_code
1522: from hr_lookups
1523: where lookup_type = 'BEN_EXT_ASMT_TO_USE'
1524: and meaning = p_meaning; -- code for the criteria Person Assignment To Use
1525:
1526:

Line 1530: from hr_lookups

1526:
1527: cursor c_berenm
1528: is
1529: select lookup_code
1530: from hr_lookups
1531: where lookup_type = 'BEN_ENRT_MTHD'
1532: and meaning = p_meaning; -- value for the criteria Enrollment method
1533:
1534:

Line 1553: from hr_lookups

1549:
1550:
1551: cursor c_lookup(p_type varchar2) is
1552: select lookup_code
1553: from hr_lookups
1554: where lookup_type = p_type
1555: and meaning = p_meaning
1556: ; --
1557:

Line 3591: from hr_lookups

3587:
3588: --
3589: cursor cw (c_code varchar2)
3590: is select 'x'
3591: from hr_lookups
3592: where lookup_type = 'BEN_EXT_CHG_EVT'
3593: and lookup_code = c_code
3594: and enabled_flag = 'Y'
3595: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))

Line 3981: from hr_lookups

3977: ) IS
3978: --
3979: cursor cw (c_code varchar2)
3980: is select 'x'
3981: from hr_lookups
3982: where lookup_type = 'BEN_EXT_CHG_EVT'
3983: and lookup_code = c_code
3984: and enabled_flag = 'Y'
3985: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))