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.

[Home] [Help]

APPS.PY_W2_DBITEMS dependencies on FF_ROUTES_S

Line 25: select ff_routes_s.currval,

21: insert into ff_route_context_usages
22: (route_id,
23: context_id,
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; -- ]

Line 59: ff_routes_s.currval,

55: --
56: values (ff_user_entities_s.nextval,
57: null,
58: 'US',
59: ff_routes_s.currval,
60: 'N',
61: p_user_entity_name ,
62: 0,
63: 'SEH', /* SEH */

Line 175: values (ff_routes_s.nextval,

171: last_updated_by,
172: last_update_login,
173: created_by,
174: creation_date)
175: values (ff_routes_s.nextval,
176: p_route_name,
177: 'N',
178: p_description,
179: p_text,

Line 481: values (ff_routes_s.nextval,

477: last_updated_by,
478: last_update_login,
479: created_by,
480: creation_date)
481: values (ff_routes_s.nextval,
482: 'EMPLOYER_ARCHIVE',
483: 'N',
484: 'sql to retrieve GRE based archived items',
485: l_text,

Line 502: ff_routes_s.currval,

498: DATA_TYPE,
499: PARAMETER_NAME,
500: SEQUENCE_NO )
501: select ff_route_parameters_s.nextval,
502: ff_routes_s.currval,
503: 'N',
504: 'User Entity ID',
505: 1 from dual;
506:

Line 515: select ff_routes_s.currval,

511: insert into ff_route_context_usages
512: (route_id,
513: context_id,
514: sequence_no)
515: select ff_routes_s.currval,
516: l_payroll_action_context_id,
517: 1
518: from dual;
519:

Line 526: select ff_routes_s.currval,

522: insert into ff_route_context_usages
523: (route_id,
524: context_id,
525: sequence_no)
526: select ff_routes_s.currval,
527: l_tax_unit_context_id,
528: 2
529: from dual;
530:

Line 595: values (ff_routes_s.nextval,

591: last_updated_by,
592: last_update_login,
593: created_by,
594: creation_date)
595: values (ff_routes_s.nextval,
596: 'EMPLOYER_ARCHIVE_DATE',
597: 'N',
598: 'sql to retrieve GRE based date archived items',
599: l_text,

Line 615: ff_routes_s.currval,

611: DATA_TYPE,
612: PARAMETER_NAME,
613: SEQUENCE_NO )
614: select ff_route_parameters_s.nextval,
615: ff_routes_s.currval,
616: 'N',
617: 'User Entity ID',
618: 1 from dual;
619:

Line 626: select ff_routes_s.currval,

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

Line 635: select ff_routes_s.currval,

631: insert into ff_route_context_usages
632: (route_id,
633: context_id,
634: sequence_no)
635: select ff_routes_s.currval,
636: l_tax_unit_context_id,
637: 2
638: from dual;
639:

Line 706: values (ff_routes_s.nextval,

702: last_updated_by,
703: last_update_login,
704: created_by,
705: creation_date)
706: values (ff_routes_s.nextval,
707: 'EMPLOYER_ARCHIVE_NUMBER',
708: 'N',
709: 'sql to retrieve GRE based numeric archived items',
710: l_text,

Line 726: ff_routes_s.currval,

722: DATA_TYPE,
723: PARAMETER_NAME,
724: SEQUENCE_NO )
725: select ff_route_parameters_s.nextval,
726: ff_routes_s.currval,
727: 'N',
728: 'User Entity ID',
729: 1 from dual;
730:

Line 737: select ff_routes_s.currval,

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

Line 746: select ff_routes_s.currval,

742: insert into ff_route_context_usages
743: (route_id,
744: context_id,
745: sequence_no)
746: select ff_routes_s.currval,
747: l_tax_unit_context_id,
748: 2
749: from dual;
750:

Line 829: values (ff_routes_s.nextval,

825: last_updated_by,
826: last_update_login,
827: created_by,
828: creation_date)
829: values (ff_routes_s.nextval,
830: 'EMPLOYER_TAX_UNIT_ARCHIVE_DATE',
831: 'N',
832: 'sql to retrieve GRE based employer archived items',
833: l_text,

Line 848: ff_routes_s.currval,

844: DATA_TYPE,
845: PARAMETER_NAME,
846: SEQUENCE_NO )
847: select ff_route_parameters_s.nextval,
848: ff_routes_s.currval,
849: 'N',
850: 'User Entity ID',
851: 1 from dual;
852:

Line 859: select ff_routes_s.currval,

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

Line 868: select ff_routes_s.currval,

864: insert into ff_route_context_usages
865: (route_id,
866: context_id,
867: sequence_no)
868: select ff_routes_s.currval,
869: l_tax_unit_context_id,
870: 2
871: from dual;
872:

Line 961: values (ff_routes_s.nextval,

957: last_updated_by,
958: last_update_login,
959: created_by,
960: creation_date)
961: values (ff_routes_s.nextval,
962: 'EMPLOYER_TAX_UNIT_ARCHIVE_NUMBER',
963: 'N',
964: 'sql to retrieve GRE based employer archived items',
965: l_text,

Line 980: ff_routes_s.currval,

976: DATA_TYPE,
977: PARAMETER_NAME,
978: SEQUENCE_NO )
979: select ff_route_parameters_s.nextval,
980: ff_routes_s.currval,
981: 'N',
982: 'User Entity ID',
983: 1 from dual;
984:

Line 991: select ff_routes_s.currval,

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

Line 1000: select ff_routes_s.currval,

996: insert into ff_route_context_usages
997: (route_id,
998: context_id,
999: sequence_no)
1000: select ff_routes_s.currval,
1001: l_tax_unit_context_id,
1002: 2
1003: from dual;
1004:

Line 1088: values (ff_routes_s.nextval,

1084: last_updated_by,
1085: last_update_login,
1086: created_by,
1087: creation_date)
1088: values (ff_routes_s.nextval,
1089: 'EMPLOYER_TAX_UNIT_ARCHIVE',
1090: 'N',
1091: 'sql to retrieve GRE based employer archived items',
1092: l_text,

Line 1107: ff_routes_s.currval,

1103: DATA_TYPE,
1104: PARAMETER_NAME,
1105: SEQUENCE_NO )
1106: select ff_route_parameters_s.nextval,
1107: ff_routes_s.currval,
1108: 'N',
1109: 'User Entity ID',
1110: 1 from dual;
1111:

Line 1118: select ff_routes_s.currval,

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

Line 1127: select ff_routes_s.currval,

1123: insert into ff_route_context_usages
1124: (route_id,
1125: context_id,
1126: sequence_no)
1127: select ff_routes_s.currval,
1128: l_tax_unit_context_id,
1129: 2
1130: from dual;
1131:

Line 1220: values (ff_routes_s.nextval,

1216: last_updated_by,
1217: last_update_login,
1218: created_by,
1219: creation_date)
1220: values (ff_routes_s.nextval,
1221: 'EMPLOYER_JURSD_ARCHIVE',
1222: 'N',
1223: 'sql to retrieve GRE based employer archived items',
1224: l_text,

Line 1239: ff_routes_s.currval,

1235: DATA_TYPE,
1236: PARAMETER_NAME,
1237: SEQUENCE_NO )
1238: select ff_route_parameters_s.nextval,
1239: ff_routes_s.currval,
1240: 'N',
1241: 'User Entity ID',
1242: 1 from dual;
1243:

Line 1250: select ff_routes_s.currval,

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

Line 1259: select ff_routes_s.currval,

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

Line 1268: select ff_routes_s.currval,

1264: insert into ff_route_context_usages
1265: (route_id,
1266: context_id,
1267: sequence_no)
1268: select ff_routes_s.currval,
1269: l_jurisdiction_context_id,
1270: 3
1271: from dual;
1272: END;

Line 1360: values (ff_routes_s.nextval,

1356: last_updated_by,
1357: last_update_login,
1358: created_by,
1359: creation_date)
1360: values (ff_routes_s.nextval,
1361: 'EMPLOYER_JURSD_ARCHIVE_DATE',
1362: 'N',
1363: 'sql to retrieve GRE based employer archived items',
1364: l_text,

Line 1379: ff_routes_s.currval,

1375: DATA_TYPE,
1376: PARAMETER_NAME,
1377: SEQUENCE_NO )
1378: select ff_route_parameters_s.nextval,
1379: ff_routes_s.currval,
1380: 'N',
1381: 'User Entity ID',
1382: 1 from dual;
1383:

Line 1390: select ff_routes_s.currval,

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

Line 1399: select ff_routes_s.currval,

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

Line 1408: select ff_routes_s.currval,

1404: insert into ff_route_context_usages
1405: (route_id,
1406: context_id,
1407: sequence_no)
1408: select ff_routes_s.currval,
1409: l_jurisdiction_context_id,
1410: 3
1411: from dual;
1412: END;

Line 1500: values (ff_routes_s.nextval,

1496: last_updated_by,
1497: last_update_login,
1498: created_by,
1499: creation_date)
1500: values (ff_routes_s.nextval,
1501: 'EMPLOYER_JURSD_ARCHIVE_NUMBER',
1502: 'N',
1503: 'sql to retrieve GRE based employer archived items',
1504: l_text,

Line 1519: ff_routes_s.currval,

1515: DATA_TYPE,
1516: PARAMETER_NAME,
1517: SEQUENCE_NO )
1518: select ff_route_parameters_s.nextval,
1519: ff_routes_s.currval,
1520: 'N',
1521: 'User Entity ID',
1522: 1 from dual;
1523:

Line 1530: select ff_routes_s.currval,

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

Line 1539: select ff_routes_s.currval,

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

Line 1548: select ff_routes_s.currval,

1544: insert into ff_route_context_usages
1545: (route_id,
1546: context_id,
1547: sequence_no)
1548: select ff_routes_s.currval,
1549: l_jurisdiction_context_id,
1550: 3
1551: from dual;
1552: END;

Line 1584: values (ff_routes_s.nextval,

1580: last_updated_by,
1581: last_update_login,
1582: created_by,
1583: creation_date)
1584: values (ff_routes_s.nextval,
1585: 'ASSIGNMENT_ARCHIVE',
1586: 'N',
1587: 'sql to retrieve Assignment based archived items',
1588: l_text,

Line 1603: ff_routes_s.currval,

1599: DATA_TYPE,
1600: PARAMETER_NAME,
1601: SEQUENCE_NO )
1602: select ff_route_parameters_s.nextval,
1603: ff_routes_s.currval,
1604: 'N',
1605: 'User Entity ID',
1606: 1 from dual;
1607:

Line 1614: select ff_routes_s.currval,

1610: insert into ff_route_context_usages
1611: (route_id,
1612: context_id,
1613: sequence_no)
1614: select ff_routes_s.currval,
1615: l_assignment_action_context_id,
1616: 1
1617: from dual;
1618:

Line 1651: values (ff_routes_s.nextval,

1647: last_updated_by,
1648: last_update_login,
1649: created_by,
1650: creation_date)
1651: values (ff_routes_s.nextval,
1652: 'ASSIGNMENT_ARCHIVE_DATE',
1653: 'N',
1654: 'sql to retrieve Assignment based archived items',
1655: l_text,

Line 1670: ff_routes_s.currval,

1666: DATA_TYPE,
1667: PARAMETER_NAME,
1668: SEQUENCE_NO )
1669: select ff_route_parameters_s.nextval,
1670: ff_routes_s.currval,
1671: 'N',
1672: 'User Entity ID',
1673: 1 from dual;
1674:

Line 1681: select ff_routes_s.currval,

1677: insert into ff_route_context_usages
1678: (route_id,
1679: context_id,
1680: sequence_no)
1681: select ff_routes_s.currval,
1682: l_assignment_action_context_id,
1683: 1
1684: from dual;
1685:

Line 1718: values (ff_routes_s.nextval,

1714: last_updated_by,
1715: last_update_login,
1716: created_by,
1717: creation_date)
1718: values (ff_routes_s.nextval,
1719: 'ASSIGNMENT_ARCHIVE_NUMBER', 'N',
1720: 'sql to retrieve Assignment based archived items',
1721: l_text,
1722: sysdate,

Line 1736: ff_routes_s.currval,

1732: DATA_TYPE,
1733: PARAMETER_NAME,
1734: SEQUENCE_NO )
1735: select ff_route_parameters_s.nextval,
1736: ff_routes_s.currval,
1737: 'N',
1738: 'User Entity ID',
1739: 1 from dual;
1740:

Line 1747: select ff_routes_s.currval,

1743: insert into ff_route_context_usages
1744: (route_id,
1745: context_id,
1746: sequence_no)
1747: select ff_routes_s.currval,
1748: l_assignment_action_context_id,
1749: 1
1750: from dual;
1751: END;

Line 1794: values (ff_routes_s.nextval,

1790: last_updated_by,
1791: last_update_login,
1792: created_by,
1793: creation_date)
1794: values (ff_routes_s.nextval,
1795: 'ASSIGNMENT_GRE_ARCHIVE',
1796: 'N',
1797: 'sql to retrieve Assignment and GRE based archived items',
1798: l_text,

Line 1813: ff_routes_s.currval,

1809: DATA_TYPE,
1810: PARAMETER_NAME,
1811: SEQUENCE_NO )
1812: values (ff_route_parameters_s.nextval,
1813: ff_routes_s.currval,
1814: 'N',
1815: 'User Entity ID',
1816: 1);
1817:

Line 1824: values (ff_routes_s.currval,

1820: insert into ff_route_context_usages
1821: (route_id,
1822: context_id,
1823: sequence_no)
1824: values (ff_routes_s.currval,
1825: l_assignment_action_context_id,
1826: 1);
1827:
1828: insert into ff_route_context_usages

Line 1832: values (ff_routes_s.currval,

1828: insert into ff_route_context_usages
1829: (route_id,
1830: context_id,
1831: sequence_no)
1832: values (ff_routes_s.currval,
1833: l_tax_unit_context_id,
1834: 2);
1835:
1836: END;

Line 1880: values (ff_routes_s.nextval,

1876: last_updated_by,
1877: last_update_login,
1878: created_by,
1879: creation_date)
1880: values (ff_routes_s.nextval,
1881: 'ASSIGNMENT_JD_ARCHIVE',
1882: 'N',
1883: 'sql to retrieve Assignment and JD based archived items',
1884: l_text,

Line 1899: ff_routes_s.currval,

1895: DATA_TYPE,
1896: PARAMETER_NAME,
1897: SEQUENCE_NO )
1898: values (ff_route_parameters_s.nextval,
1899: ff_routes_s.currval,
1900: 'N',
1901: 'User Entity ID',
1902: 1);
1903:

Line 1910: values (ff_routes_s.currval,

1906: insert into ff_route_context_usages
1907: (route_id,
1908: context_id,
1909: sequence_no)
1910: values (ff_routes_s.currval,
1911: l_assignment_action_context_id,
1912: 1);
1913:
1914: insert into ff_route_context_usages

Line 1918: values (ff_routes_s.currval,

1914: insert into ff_route_context_usages
1915: (route_id,
1916: context_id,
1917: sequence_no)
1918: values (ff_routes_s.currval,
1919: l_jurisdiction_context_id,
1920: 2);
1921:
1922: END;

Line 1972: values (ff_routes_s.nextval,

1968: last_updated_by,
1969: last_update_login,
1970: created_by,
1971: creation_date)
1972: values (ff_routes_s.nextval,
1973: 'ASSIGNMENT_GRE_CITY_JD_ARCHIVE',
1974: 'N',
1975: 'sql to retrieve Assignment,GRE and city JD based archived items',
1976: l_text,

Line 1991: ff_routes_s.currval,

1987: DATA_TYPE,
1988: PARAMETER_NAME,
1989: SEQUENCE_NO )
1990: values (ff_route_parameters_s.nextval,
1991: ff_routes_s.currval,
1992: 'N',
1993: 'User Entity ID',
1994: 1);
1995:

Line 2002: values (ff_routes_s.currval,

1998: insert into ff_route_context_usages
1999: (route_id,
2000: context_id,
2001: sequence_no)
2002: values (ff_routes_s.currval,
2003: l_assignment_action_context_id,
2004: 1);
2005:
2006: insert into ff_route_context_usages

Line 2010: values (ff_routes_s.currval,

2006: insert into ff_route_context_usages
2007: (route_id,
2008: context_id,
2009: sequence_no)
2010: values (ff_routes_s.currval,
2011: l_tax_unit_context_id,
2012: 2);
2013:
2014: insert into ff_route_context_usages

Line 2018: values (ff_routes_s.currval,

2014: insert into ff_route_context_usages
2015: (route_id,
2016: context_id,
2017: sequence_no)
2018: values (ff_routes_s.currval,
2019: l_jurisdiction_context_id,
2020: 3);
2021:
2022:

Line 2072: values (ff_routes_s.nextval,

2068: last_updated_by,
2069: last_update_login,
2070: created_by,
2071: creation_date)
2072: values (ff_routes_s.nextval,
2073: 'ASSIGNMENT_GRE_COUNTY_JD_ARCHIVE',
2074: 'N',
2075: 'sql to retrieve Assignment,GRE and county JD based archived items',
2076: l_text,

Line 2091: ff_routes_s.currval,

2087: DATA_TYPE,
2088: PARAMETER_NAME,
2089: SEQUENCE_NO )
2090: values (ff_route_parameters_s.nextval,
2091: ff_routes_s.currval,
2092: 'N',
2093: 'User Entity ID',
2094: 1);
2095:

Line 2102: values (ff_routes_s.currval,

2098: insert into ff_route_context_usages
2099: (route_id,
2100: context_id,
2101: sequence_no)
2102: values (ff_routes_s.currval,
2103: l_assignment_action_context_id,
2104: 1);
2105:
2106: insert into ff_route_context_usages

Line 2110: values (ff_routes_s.currval,

2106: insert into ff_route_context_usages
2107: (route_id,
2108: context_id,
2109: sequence_no)
2110: values (ff_routes_s.currval,
2111: l_tax_unit_context_id,
2112: 2);
2113:
2114: insert into ff_route_context_usages

Line 2118: values (ff_routes_s.currval,

2114: insert into ff_route_context_usages
2115: (route_id,
2116: context_id,
2117: sequence_no)
2118: values (ff_routes_s.currval,
2119: l_jurisdiction_context_id,
2120: 3);
2121:
2122: END;

Line 2171: values (ff_routes_s.nextval,

2167: last_updated_by,
2168: last_update_login,
2169: created_by,
2170: creation_date)
2171: values (ff_routes_s.nextval,
2172: 'ASSIGNMENT_GRE_STATE_JD_ARCHIVE',
2173: 'N',
2174: 'sql to retrieve Assignment,GRE and state JD based archived items',
2175: l_text,

Line 2190: ff_routes_s.currval,

2186: DATA_TYPE,
2187: PARAMETER_NAME,
2188: SEQUENCE_NO )
2189: values (ff_route_parameters_s.nextval,
2190: ff_routes_s.currval,
2191: 'N',
2192: 'User Entity ID',
2193: 1);
2194:

Line 2201: values (ff_routes_s.currval,

2197: insert into ff_route_context_usages
2198: (route_id,
2199: context_id,
2200: sequence_no)
2201: values (ff_routes_s.currval,
2202: l_assignment_action_context_id,
2203: 1);
2204:
2205: insert into ff_route_context_usages

Line 2209: values (ff_routes_s.currval,

2205: insert into ff_route_context_usages
2206: (route_id,
2207: context_id,
2208: sequence_no)
2209: values (ff_routes_s.currval,
2210: l_tax_unit_context_id,
2211: 2);
2212:
2213: insert into ff_route_context_usages

Line 2217: values (ff_routes_s.currval,

2213: insert into ff_route_context_usages
2214: (route_id,
2215: context_id,
2216: sequence_no)
2217: values (ff_routes_s.currval,
2218: l_jurisdiction_context_id,
2219: 3);
2220:
2221: END;

Line 2270: values (ff_routes_s.nextval,

2266: last_updated_by,
2267: last_update_login,
2268: created_by,
2269: creation_date)
2270: values (ff_routes_s.nextval,
2271: 'ASSIGNMENT_GRE_SCHOOL_JD_ARCHIVE',
2272: 'N',
2273: 'sql to retrieve Assignment,GRE and school JD based archived items',
2274: l_text,

Line 2289: ff_routes_s.currval,

2285: DATA_TYPE,
2286: PARAMETER_NAME,
2287: SEQUENCE_NO )
2288: values (ff_route_parameters_s.nextval,
2289: ff_routes_s.currval,
2290: 'N',
2291: 'User Entity ID',
2292: 1);
2293:

Line 2300: values (ff_routes_s.currval,

2296: insert into ff_route_context_usages
2297: (route_id,
2298: context_id,
2299: sequence_no)
2300: values (ff_routes_s.currval,
2301: l_assignment_action_context_id,
2302: 1);
2303:
2304: insert into ff_route_context_usages

Line 2308: values (ff_routes_s.currval,

2304: insert into ff_route_context_usages
2305: (route_id,
2306: context_id,
2307: sequence_no)
2308: values (ff_routes_s.currval,
2309: l_tax_unit_context_id,
2310: 2);
2311:
2312: insert into ff_route_context_usages

Line 2316: values (ff_routes_s.currval,

2312: insert into ff_route_context_usages
2313: (route_id,
2314: context_id,
2315: sequence_no)
2316: values (ff_routes_s.currval,
2317: l_jurisdiction_context_id,
2318: 3);
2319:
2320: