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 226: --- this function also allow to extract the lookup code , the criteria is from hr lookups

222:
223: -----------------------------------------------------
224: --- This function is added to get the lookup code
225: --- so far the ldt extract the name that is creating a issue when the lookup meaning are changed
226: --- this function also allow to extract the lookup code , the criteria is from hr lookups
227: -- if the criteria from master tables like person name then return null for the code
228: ------------------------------------------------------
229:
230: Function get_lookup_code (p_crit_typ_cd in VARCHAR2

Line 239: select 'x' from hr_lookups

235:
236:
237:
238: cursor find_lookup ( p_lookup_type in varchar2) is
239: select 'x' from hr_lookups
240: where lookup_type = p_lookup_type
241: and lookup_code = p_val
242: ;
243:

Line 246: l_lookup_type hr_lookups.lookup_type%type ;

242: ;
243:
244: l_return_val varchar2(30) ;
245: l_dummy varchar2(1) ;
246: l_lookup_type hr_lookups.lookup_type%type ;
247:
248: Begin
249:
250:

Line 336: from hr_lookups

332: l_crit_cmbn varchar2(2000) := '';
333: --value varchar2(80) := ''; UTF8IK
334: value varchar2(240) := '';
335: cursor c1 is select meaning
336: from hr_lookups
337: where lookup_type = 'US_STATE'
338: and lookup_code = p_val;
339:
340:

Line 444: from hr_lookups

440: and rptg_grp_id = p_val;
441: */
442:
443: cursor cf is select meaning
444: from hr_lookups
445: where lookup_type = 'BEN_PER_IN_LER_STAT'
446: and lookup_code = p_val;
447:
448:

Line 450: from hr_lookups

446: and lookup_code = p_val;
447:
448:
449: cursor cg is select meaning
450: from hr_lookups
451: where lookup_type = 'BEN_EXT_SUSPEND'
452: and lookup_code = p_val;
453:
454: cursor ch is select name

Line 484: from hr_lookups

480: and rptg_grp_id = p_val;
481:
482:
483: cursor cl is select meaning
484: from hr_lookups
485: where lookup_type = 'BEN_EXT_CRIT_MISC'
486: and lookup_code = p_val;
487:
488:

Line 503: from hr_lookups

499: where business_group_id = p_business_group_id
500: and yr_perd_id = p_val;
501:
502: cursor co is select meaning
503: from hr_lookups
504: where lookup_type = 'BEN_EXT_CRIT_MISC'
505: and lookup_code = p_val;
506:
507: cursor cp is select meaning

Line 508: from hr_lookups

504: where lookup_type = 'BEN_EXT_CRIT_MISC'
505: and lookup_code = p_val;
506:
507: cursor cp is select meaning
508: from hr_lookups
509: where lookup_type = 'BEN_EXT_SUSPEND'
510: and lookup_code = p_val;
511:
512: cursor cq is select meaning

Line 513: from hr_lookups

509: where lookup_type = 'BEN_EXT_SUSPEND'
510: and lookup_code = p_val;
511:
512: cursor cq is select meaning
513: from hr_lookups
514: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
515: and lookup_code = p_val;
516:
517: cursor cr is select meaning

Line 518: from hr_lookups

514: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
515: and lookup_code = p_val;
516:
517: cursor cr is select meaning
518: from hr_lookups
519: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
520: and lookup_code = p_val;
521:
522: cursor cs is select meaning

Line 523: from hr_lookups

519: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
520: and lookup_code = p_val;
521:
522: cursor cs is select meaning
523: from hr_lookups
524: where lookup_type = 'BEN_EXT_DT'
525: and lookup_code = p_val;
526:
527: cursor ct is select name

Line 533: from hr_lookups

529: where actn_typ_id = p_val ;
530:
531:
532: cursor cu is select meaning
533: from hr_lookups
534: where lookup_type = 'BEN_EXT_DT'
535: and lookup_code = p_val
536: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
537: and nvl(end_date_active, trunc(sysdate))

Line 543: from hr_lookups

539:
540:
541:
542: cursor cv is select meaning
543: from hr_lookups
544: where lookup_type = 'BEN_EXT_DT'
545: and lookup_code = p_val
546: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
547: and nvl(end_date_active, trunc(sysdate))

Line 551: from hr_lookups

547: and nvl(end_date_active, trunc(sysdate))
548: ;
549:
550: cursor cw is select meaning
551: from hr_lookups
552: where lookup_type = 'BEN_EXT_CHG_EVT'
553: and lookup_code = p_val
554: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
555: and nvl(end_date_active, trunc(sysdate)) ;

Line 569: from hr_lookups

565: and trunc(sysdate) between nvl(start_date, trunc(sysdate))
566: and nvl(end_date, trunc(sysdate));
567:
568: cursor cy is select meaning
569: from hr_lookups
570: where lookup_type = 'BEN_EXT_DT'
571: and lookup_code = p_val
572: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
573: and nvl(end_date_active, trunc(sysdate))

Line 577: from hr_lookups

573: and nvl(end_date_active, trunc(sysdate))
574: ;
575:
576: cursor cz is select meaning
577: from hr_lookups
578: where lookup_type = 'BEN_EXT_DT'
579: and lookup_code = p_val
580: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
581: and nvl(end_date_active, trunc(sysdate))

Line 585: from hr_lookups

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

Line 593: from hr_lookups

589: and nvl(end_date_active, trunc(sysdate))
590: ;
591:
592: cursor cab is select meaning
593: from hr_lookups
594: where lookup_type = 'BEN_EXT_DT'
595: and lookup_code = p_val
596: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
597: and nvl(end_date_active, trunc(sysdate))

Line 601: from hr_lookups

597: and nvl(end_date_active, trunc(sysdate))
598: ;
599:
600: cursor cac is select meaning
601: from hr_lookups
602: where lookup_type = 'BEN_EXT_DT'
603: and lookup_code = p_val
604: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
605: and nvl(end_date_active, trunc(sysdate))

Line 609: from hr_lookups

605: and nvl(end_date_active, trunc(sysdate))
606: ;
607:
608: cursor cad is select meaning
609: from hr_lookups
610: where lookup_type = 'BEN_EXT_DT'
611: and lookup_code = p_val
612: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
613: and nvl(end_date_active, trunc(sysdate))

Line 617: from hr_lookups

613: and nvl(end_date_active, trunc(sysdate))
614: ;
615:
616: cursor cae is select meaning
617: from hr_lookups
618: where lookup_type = 'BEN_EXT_DT'
619: and lookup_code = p_val
620: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
621: and nvl(end_date_active, trunc(sysdate))

Line 625: from hr_lookups

621: and nvl(end_date_active, trunc(sysdate))
622: ;
623:
624: cursor caf is select meaning
625: from hr_lookups
626: where lookup_type = 'BEN_EXT_DT'
627: and lookup_code = p_val
628: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
629: and nvl(end_date_active, trunc(sysdate))

Line 633: from hr_lookups

629: and nvl(end_date_active, trunc(sysdate))
630: ;
631:
632: cursor cag is select meaning
633: from hr_lookups
634: where lookup_type = 'BEN_EXT_DT'
635: and lookup_code = p_val
636: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
637: and nvl(end_date_active, trunc(sysdate))

Line 642: from hr_lookups

638: ;
639:
640:
641: cursor cah is select meaning
642: from hr_lookups
643: where lookup_type = 'BEN_EXT_DT'
644: and lookup_code = p_val
645: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
646: and nvl(end_date_active, trunc(sysdate))

Line 653: from hr_lookups

649:
650: cursor c_val1_dt
651: is
652: select meaning
653: from hr_lookups
654: where lookup_type = 'BEN_EXT_DT'
655: and lookup_code = p_val;
656:
657: cursor c_val2_dt

Line 660: from hr_lookups

656:
657: cursor c_val2_dt
658: is
659: select meaning
660: from hr_lookups
661: where lookup_type = 'BEN_EXT_DT'
662: and lookup_code = p_val;
663:
664: cursor c_val1_chg_evt

Line 667: from hr_lookups

663:
664: cursor c_val1_chg_evt
665: is
666: select meaning
667: from hr_lookups
668: where lookup_type = 'BEN_EXT_CHG_EVT'
669: and lookup_code = p_val;
670:
671: cursor c_val2_chg_evt

Line 674: from hr_lookups

670:
671: cursor c_val2_chg_evt
672: is
673: select meaning
674: from hr_lookups
675: where lookup_type = 'BEN_EXT_CHG_EVT'
676: and lookup_code = p_val;
677:
678: cursor c_oper

Line 681: from hr_lookups

677:
678: cursor c_oper
679: is
680: select meaning
681: from hr_lookups
682: where lookup_type = 'BEN_EXT_TTL_COND_OPER'
683: and lookup_code = p_val; --p_oper_cd;
684:
685:

Line 689: from hr_lookups

685:
686: cursor c_pasu
687: is
688: select meaning
689: from hr_lookups
690: where lookup_type = 'BEN_EXT_ASMT_TO_USE'
691: and lookup_code = p_val; -- value for the criteria Person Assignment To Use
692:
693: CURSOR Cai IS

Line 695: from HR_LOOKUPS

691: and lookup_code = p_val; -- value for the criteria Person Assignment To Use
692:
693: CURSOR Cai IS
694: select MEANING
695: from HR_LOOKUPS
696: where LOOKUP_CODE = p_crit_typ_cd
697: and lookup_type = 'BEN_EXT_CRIT_TYP'
698: and substr(lookup_code, 1, 1) = 'C'
699: and lookup_code not in ('CBU')

Line 708: from hr_lookups

704:
705: cursor c_berenm
706: is
707: select meaning
708: from hr_lookups
709: where lookup_type = 'BEN_ENRT_MTHD'
710: and lookup_code = p_val; -- value for the criteria Enrollment method
711:
712:

Line 722: from hr_lookups

718:
719:
720: cursor c_lookup(p_type varchar2) is
721: select meaning
722: from hr_lookups
723: where lookup_type = p_type
724: and lookup_code = p_val; --
725:
726: cursor c_job is

Line 1085: from hr_lookups

1081: -- value varchar2(80) := ''; UTF8IK
1082: value varchar2(600):= '';
1083:
1084: cursor c1 is select lookup_code
1085: from hr_lookups
1086: where lookup_type = 'US_STATE'
1087: and meaning = p_meaning
1088: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1089: and nvl(end_date_active, trunc(sysdate))

Line 1210: from hr_lookups

1206: and rptg_grp_id = p_val_1;
1207: */
1208:
1209: cursor cf is select lookup_code
1210: from hr_lookups
1211: where lookup_type = 'BEN_PER_IN_LER_STAT'
1212: and meaning = p_meaning;
1213:
1214: cursor cg is select lookup_code

Line 1215: from hr_lookups

1211: where lookup_type = 'BEN_PER_IN_LER_STAT'
1212: and meaning = p_meaning;
1213:
1214: cursor cg is select lookup_code
1215: from hr_lookups
1216: where lookup_type = 'BEN_EXT_SUSPEND'
1217: and meaning = p_meaning;
1218:
1219: cursor ch is select name

Line 1248: from hr_lookups

1244: where business_group_id = p_business_group_id
1245: and name = p_meaning ;
1246:
1247: cursor cl is select lookup_code
1248: from hr_lookups
1249: where lookup_type = 'BEN_EXT_CRIT_MISC'
1250: and meaning = p_meaning;
1251:
1252:

Line 1267: from hr_lookups

1263: where business_group_id = p_business_group_id
1264: and start_date||' - '||end_date = p_meaning;
1265:
1266: cursor co is select lookup_code
1267: from hr_lookups
1268: where lookup_type = 'BEN_EXT_CRIT_MISC'
1269: and meaning = p_meaning;
1270:
1271: cursor cp is select lookup_code

Line 1272: from hr_lookups

1268: where lookup_type = 'BEN_EXT_CRIT_MISC'
1269: and meaning = p_meaning;
1270:
1271: cursor cp is select lookup_code
1272: from hr_lookups
1273: where lookup_type = 'BEN_EXT_SUSPEND'
1274: and meaning = p_meaning;
1275:
1276: cursor cq is select lookup_code

Line 1277: from hr_lookups

1273: where lookup_type = 'BEN_EXT_SUSPEND'
1274: and meaning = p_meaning;
1275:
1276: cursor cq is select lookup_code
1277: from hr_lookups
1278: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
1279: and meaning = p_meaning;
1280:
1281: cursor cr is select lookup_code

Line 1282: from hr_lookups

1278: where lookup_type = 'BEN_ENRT_RSLT_MTHD'
1279: and meaning = p_meaning;
1280:
1281: cursor cr is select lookup_code
1282: from hr_lookups
1283: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
1284: and meaning = p_meaning;
1285:
1286: cursor cs is select lookup_code

Line 1287: from hr_lookups

1283: where lookup_type = 'BEN_PRTT_ENRT_RSLT_STAT'
1284: and meaning = p_meaning;
1285:
1286: cursor cs is select lookup_code
1287: from hr_lookups
1288: where lookup_type = 'BEN_EXT_DT'
1289: and meaning = p_meaning;
1290:
1291: cursor ct is select actn_typ_id

Line 1298: from hr_lookups

1294:
1295:
1296:
1297: cursor cu is select lookup_code
1298: from hr_lookups
1299: where lookup_type = 'BEN_EXT_DT'
1300: and meaning = p_meaning
1301: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1302: and nvl(end_date_active, trunc(sysdate))

Line 1308: from hr_lookups

1304:
1305:
1306:
1307: cursor cv is select lookup_code
1308: from hr_lookups
1309: where lookup_type = 'BEN_EXT_DT'
1310: and meaning = p_meaning
1311: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1312: and nvl(end_date_active, trunc(sysdate))

Line 1316: from hr_lookups

1312: and nvl(end_date_active, trunc(sysdate))
1313: ;
1314:
1315: cursor cw is select lookup_code
1316: from hr_lookups
1317: where lookup_type = 'BEN_EXT_CHG_EVT'
1318: and meaning = p_meaning
1319: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1320: and nvl(end_date_active, trunc(sysdate))

Line 1336: from hr_lookups

1332: and trunc(sysdate) between nvl(start_date, trunc(sysdate))
1333: and nvl(end_date, trunc(sysdate));
1334:
1335: cursor cy is select lookup_code
1336: from hr_lookups
1337: where lookup_type = 'BEN_EXT_DT'
1338: and meaning = p_meaning
1339: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1340: and nvl(end_date_active, trunc(sysdate))

Line 1344: from hr_lookups

1340: and nvl(end_date_active, trunc(sysdate))
1341: ;
1342:
1343: cursor cz is select lookup_code
1344: from hr_lookups
1345: where lookup_type = 'BEN_EXT_DT'
1346: and meaning = p_meaning
1347: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1348: and nvl(end_date_active, trunc(sysdate))

Line 1352: from hr_lookups

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

Line 1360: from hr_lookups

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

Line 1369: from hr_lookups

1365: ;
1366:
1367:
1368: cursor cac is select lookup_code
1369: from hr_lookups
1370: where lookup_type = 'BEN_EXT_DT'
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 1377: from hr_lookups

1373: and nvl(end_date_active, trunc(sysdate))
1374: ;
1375:
1376: cursor cad is select lookup_code
1377: from hr_lookups
1378: where lookup_type = 'BEN_EXT_DT'
1379: and meaning = p_meaning
1380: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1381: and nvl(end_date_active, trunc(sysdate))

Line 1385: from hr_lookups

1381: and nvl(end_date_active, trunc(sysdate))
1382: ;
1383:
1384: cursor cae is select lookup_code
1385: from hr_lookups
1386: where lookup_type = 'BEN_EXT_DT'
1387: and meaning = p_meaning
1388: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1389: and nvl(end_date_active, trunc(sysdate))

Line 1393: from hr_lookups

1389: and nvl(end_date_active, trunc(sysdate))
1390: ;
1391:
1392: cursor caf is select lookup_code
1393: from hr_lookups
1394: where lookup_type = 'BEN_EXT_DT'
1395: and meaning = p_meaning
1396: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1397: and nvl(end_date_active, trunc(sysdate))

Line 1401: from hr_lookups

1397: and nvl(end_date_active, trunc(sysdate))
1398: ;
1399:
1400: cursor cag is select lookup_code
1401: from hr_lookups
1402: where lookup_type = 'BEN_EXT_DT'
1403: and meaning = p_meaning
1404: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1405: and nvl(end_date_active, trunc(sysdate))

Line 1410: from hr_lookups

1406: ;
1407:
1408:
1409: cursor cah is select lookup_code
1410: from hr_lookups
1411: where lookup_type = 'BEN_EXT_DT'
1412: and meaning = p_meaning
1413: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))
1414: and nvl(end_date_active, trunc(sysdate))

Line 1421: from hr_lookups

1417:
1418: cursor c_val1_dt
1419: is
1420: select lookup_code
1421: from hr_lookups
1422: where lookup_type = 'BEN_EXT_DT'
1423: and meaning = p_meaning;
1424:
1425: cursor c_val2_dt

Line 1428: from hr_lookups

1424:
1425: cursor c_val2_dt
1426: is
1427: select lookup_code
1428: from hr_lookups
1429: where lookup_type = 'BEN_EXT_DT'
1430: and meaning = p_meaning;
1431:
1432: cursor c_val1_chg_evt

Line 1435: from hr_lookups

1431:
1432: cursor c_val1_chg_evt
1433: is
1434: select lookup_code
1435: from hr_lookups
1436: where lookup_type = 'BEN_EXT_CHG_EVT'
1437: and meaning = p_meaning;
1438:
1439: cursor c_val2_chg_evt

Line 1442: from hr_lookups

1438:
1439: cursor c_val2_chg_evt
1440: is
1441: select lookup_code
1442: from hr_lookups
1443: where lookup_type = 'BEN_EXT_CHG_EVT'
1444: and meaning = p_meaning;
1445:
1446: cursor c_oper

Line 1449: from hr_lookups

1445:
1446: cursor c_oper
1447: is
1448: select lookup_code
1449: from hr_lookups
1450: where lookup_type = 'BEN_EXT_TTL_COND_OPER'
1451: and meaning = p_meaning; --p_oper_cd;
1452:
1453:

Line 1456: from HR_LOOKUPS

1452:
1453:
1454: CURSOR Cai IS
1455: select lookup_code
1456: from HR_LOOKUPS
1457: where LOOKUP_CODE = p_crit_typ_cd
1458: and lookup_type = 'BEN_EXT_CRIT_TYP'
1459: and substr(lookup_code, 1, 1) = 'C'
1460: and lookup_code not in ('CBU')

Line 1469: from hr_lookups

1465:
1466: cursor c_pasu
1467: is
1468: select lookup_code
1469: from hr_lookups
1470: where lookup_type = 'BEN_EXT_ASMT_TO_USE'
1471: and meaning = p_meaning; -- code for the criteria Person Assignment To Use
1472:
1473:

Line 1477: from hr_lookups

1473:
1474: cursor c_berenm
1475: is
1476: select lookup_code
1477: from hr_lookups
1478: where lookup_type = 'BEN_ENRT_MTHD'
1479: and meaning = p_meaning; -- value for the criteria Enrollment method
1480:
1481:

Line 1500: from hr_lookups

1496:
1497:
1498: cursor c_lookup(p_type varchar2) is
1499: select lookup_code
1500: from hr_lookups
1501: where lookup_type = p_type
1502: and meaning = p_meaning
1503: ; --
1504:

Line 3535: from hr_lookups

3531:
3532: --
3533: cursor cw (c_code varchar2)
3534: is select 'x'
3535: from hr_lookups
3536: where lookup_type = 'BEN_EXT_CHG_EVT'
3537: and lookup_code = c_code
3538: and enabled_flag = 'Y'
3539: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))

Line 3925: from hr_lookups

3921: ) IS
3922: --
3923: cursor cw (c_code varchar2)
3924: is select 'x'
3925: from hr_lookups
3926: where lookup_type = 'BEN_EXT_CHG_EVT'
3927: and lookup_code = c_code
3928: and enabled_flag = 'Y'
3929: and trunc(sysdate) between nvl(start_date_active, trunc(sysdate))