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.PY_W2_DBITEMS dependencies on DUAL

Line 28: from dual;

24: sequence_no)
25: select ff_routes_s.currval,
26: p_context_id,
27: p_sequence_no
28: from dual;
29: end insert_route_context_usages; -- ]
30: --
31: -- ******** local procedure : insert_user_entity ********
32: --

Line 505: 1 from dual;

501: select ff_route_parameters_s.nextval,
502: ff_routes_s.currval,
503: 'N',
504: 'User Entity ID',
505: 1 from dual;
506:
507: -- define the route_context usage
508:
509: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');

Line 518: from dual;

514: sequence_no)
515: select ff_routes_s.currval,
516: l_payroll_action_context_id,
517: 1
518: from dual;
519:
520: hr_utility.trace('inserting ff_route_context_usages for EMPLOYER_ARCHIVE');
521:
522: insert into ff_route_context_usages

Line 529: from dual;

525: sequence_no)
526: select ff_routes_s.currval,
527: l_tax_unit_context_id,
528: 2
529: from dual;
530:
531: END;
532:
533: BEGIN

Line 618: 1 from dual;

614: select ff_route_parameters_s.nextval,
615: ff_routes_s.currval,
616: 'N',
617: 'User Entity ID',
618: 1 from dual;
619:
620: -- define the route_context usage
621:
622: insert into ff_route_context_usages

Line 629: from dual;

625: sequence_no)
626: select ff_routes_s.currval,
627: l_payroll_action_context_id,
628: 1
629: from dual;
630:
631: insert into ff_route_context_usages
632: (route_id,
633: context_id,

Line 638: from dual;

634: sequence_no)
635: select ff_routes_s.currval,
636: l_tax_unit_context_id,
637: 2
638: from dual;
639:
640: END;
641:
642: BEGIN

Line 729: 1 from dual;

725: select ff_route_parameters_s.nextval,
726: ff_routes_s.currval,
727: 'N',
728: 'User Entity ID',
729: 1 from dual;
730:
731: -- define the route_context usage
732:
733: insert into ff_route_context_usages

Line 740: from dual;

736: sequence_no)
737: select ff_routes_s.currval,
738: l_payroll_action_context_id,
739: 1
740: from dual;
741:
742: insert into ff_route_context_usages
743: (route_id,
744: context_id,

Line 749: from dual;

745: sequence_no)
746: select ff_routes_s.currval,
747: l_tax_unit_context_id,
748: 2
749: from dual;
750:
751: END;
752:
753: BEGIN

Line 851: 1 from dual;

847: select ff_route_parameters_s.nextval,
848: ff_routes_s.currval,
849: 'N',
850: 'User Entity ID',
851: 1 from dual;
852:
853: -- define the route_context usage
854:
855: insert into ff_route_context_usages

Line 862: from dual;

858: sequence_no)
859: select ff_routes_s.currval,
860: l_payroll_action_context_id,
861: 1
862: from dual;
863:
864: insert into ff_route_context_usages
865: (route_id,
866: context_id,

Line 871: from dual;

867: sequence_no)
868: select ff_routes_s.currval,
869: l_tax_unit_context_id,
870: 2
871: from dual;
872:
873: END;
874:
875:

Line 983: 1 from dual;

979: select ff_route_parameters_s.nextval,
980: ff_routes_s.currval,
981: 'N',
982: 'User Entity ID',
983: 1 from dual;
984:
985: -- define the route_context usage
986:
987: insert into ff_route_context_usages

Line 994: from dual;

990: sequence_no)
991: select ff_routes_s.currval,
992: l_payroll_action_context_id,
993: 1
994: from dual;
995:
996: insert into ff_route_context_usages
997: (route_id,
998: context_id,

Line 1003: from dual;

999: sequence_no)
1000: select ff_routes_s.currval,
1001: l_tax_unit_context_id,
1002: 2
1003: from dual;
1004:
1005: END;
1006:
1007: BEGIN

Line 1110: 1 from dual;

1106: select ff_route_parameters_s.nextval,
1107: ff_routes_s.currval,
1108: 'N',
1109: 'User Entity ID',
1110: 1 from dual;
1111:
1112: -- define the route_context usage
1113:
1114: insert into ff_route_context_usages

Line 1121: from dual;

1117: sequence_no)
1118: select ff_routes_s.currval,
1119: l_payroll_action_context_id,
1120: 1
1121: from dual;
1122:
1123: insert into ff_route_context_usages
1124: (route_id,
1125: context_id,

Line 1130: from dual;

1126: sequence_no)
1127: select ff_routes_s.currval,
1128: l_tax_unit_context_id,
1129: 2
1130: from dual;
1131:
1132: END;
1133:
1134:

Line 1242: 1 from dual;

1238: select ff_route_parameters_s.nextval,
1239: ff_routes_s.currval,
1240: 'N',
1241: 'User Entity ID',
1242: 1 from dual;
1243:
1244: -- define the route_context usage
1245:
1246: insert into ff_route_context_usages

Line 1253: from dual;

1249: sequence_no)
1250: select ff_routes_s.currval,
1251: l_payroll_action_context_id,
1252: 1
1253: from dual;
1254:
1255: insert into ff_route_context_usages
1256: (route_id,
1257: context_id,

Line 1262: from dual;

1258: sequence_no)
1259: select ff_routes_s.currval,
1260: l_tax_unit_context_id,
1261: 2
1262: from dual;
1263:
1264: insert into ff_route_context_usages
1265: (route_id,
1266: context_id,

Line 1271: from dual;

1267: sequence_no)
1268: select ff_routes_s.currval,
1269: l_jurisdiction_context_id,
1270: 3
1271: from dual;
1272: END;
1273:
1274:
1275: BEGIN

Line 1382: 1 from dual;

1378: select ff_route_parameters_s.nextval,
1379: ff_routes_s.currval,
1380: 'N',
1381: 'User Entity ID',
1382: 1 from dual;
1383:
1384: -- define the route_context usage
1385:
1386: insert into ff_route_context_usages

Line 1393: from dual;

1389: sequence_no)
1390: select ff_routes_s.currval,
1391: l_payroll_action_context_id,
1392: 1
1393: from dual;
1394:
1395: insert into ff_route_context_usages
1396: (route_id,
1397: context_id,

Line 1402: from dual;

1398: sequence_no)
1399: select ff_routes_s.currval,
1400: l_tax_unit_context_id,
1401: 2
1402: from dual;
1403:
1404: insert into ff_route_context_usages
1405: (route_id,
1406: context_id,

Line 1411: from dual;

1407: sequence_no)
1408: select ff_routes_s.currval,
1409: l_jurisdiction_context_id,
1410: 3
1411: from dual;
1412: END;
1413:
1414:
1415: BEGIN

Line 1522: 1 from dual;

1518: select ff_route_parameters_s.nextval,
1519: ff_routes_s.currval,
1520: 'N',
1521: 'User Entity ID',
1522: 1 from dual;
1523:
1524: -- define the route_context usage
1525:
1526: insert into ff_route_context_usages

Line 1533: from dual;

1529: sequence_no)
1530: select ff_routes_s.currval,
1531: l_payroll_action_context_id,
1532: 1
1533: from dual;
1534:
1535: insert into ff_route_context_usages
1536: (route_id,
1537: context_id,

Line 1542: from dual;

1538: sequence_no)
1539: select ff_routes_s.currval,
1540: l_tax_unit_context_id,
1541: 2
1542: from dual;
1543:
1544: insert into ff_route_context_usages
1545: (route_id,
1546: context_id,

Line 1551: from dual;

1547: sequence_no)
1548: select ff_routes_s.currval,
1549: l_jurisdiction_context_id,
1550: 3
1551: from dual;
1552: END;
1553:
1554: BEGIN
1555:

Line 1606: 1 from dual;

1602: select ff_route_parameters_s.nextval,
1603: ff_routes_s.currval,
1604: 'N',
1605: 'User Entity ID',
1606: 1 from dual;
1607:
1608: -- define the route_context usage
1609:
1610: insert into ff_route_context_usages

Line 1617: from dual;

1613: sequence_no)
1614: select ff_routes_s.currval,
1615: l_assignment_action_context_id,
1616: 1
1617: from dual;
1618:
1619: END;
1620:
1621: BEGIN

Line 1673: 1 from dual;

1669: select ff_route_parameters_s.nextval,
1670: ff_routes_s.currval,
1671: 'N',
1672: 'User Entity ID',
1673: 1 from dual;
1674:
1675: -- define the route_context usage
1676:
1677: insert into ff_route_context_usages

Line 1684: from dual;

1680: sequence_no)
1681: select ff_routes_s.currval,
1682: l_assignment_action_context_id,
1683: 1
1684: from dual;
1685:
1686: END;
1687:
1688: BEGIN

Line 1739: 1 from dual;

1735: select ff_route_parameters_s.nextval,
1736: ff_routes_s.currval,
1737: 'N',
1738: 'User Entity ID',
1739: 1 from dual;
1740:
1741: -- define the route_context usage
1742:
1743: insert into ff_route_context_usages

Line 1750: from dual;

1746: sequence_no)
1747: select ff_routes_s.currval,
1748: l_assignment_action_context_id,
1749: 1
1750: from dual;
1751: END;
1752:
1753: /* For EOY */
1754:

Line 2379: from dual;

2375: and rc.route_id = l_live_route_id
2376: and context_name like 'ASSIGNMENT%';
2377:
2378: select ff_user_entities_s.nextval into l_user_entity_seq
2379: from dual;
2380:
2381:
2382: select route_id into l_er_archive_route_id
2383: from ff_routes where

Line 2874: from dual;

2870: else
2871:
2872: select ff_user_entities_s.nextval
2873: into l_user_entity_seq
2874: from dual;
2875:
2876: insert into ff_user_entities
2877: (user_entity_id,
2878: business_group_id,