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 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 1973: values (ff_routes_s.nextval,

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

Line 1992: ff_routes_s.currval,

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

Line 2003: values (ff_routes_s.currval,

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

Line 2011: values (ff_routes_s.currval,

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

Line 2019: values (ff_routes_s.currval,

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

Line 2074: values (ff_routes_s.nextval,

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

Line 2093: ff_routes_s.currval,

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

Line 2104: values (ff_routes_s.currval,

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

Line 2112: values (ff_routes_s.currval,

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

Line 2120: values (ff_routes_s.currval,

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

Line 2174: values (ff_routes_s.nextval,

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

Line 2193: ff_routes_s.currval,

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

Line 2204: values (ff_routes_s.currval,

2200: insert into ff_route_context_usages
2201: (route_id,
2202: context_id,
2203: sequence_no)
2204: values (ff_routes_s.currval,
2205: l_assignment_action_context_id,
2206: 1);
2207:
2208: insert into ff_route_context_usages

Line 2212: values (ff_routes_s.currval,

2208: insert into ff_route_context_usages
2209: (route_id,
2210: context_id,
2211: sequence_no)
2212: values (ff_routes_s.currval,
2213: l_tax_unit_context_id,
2214: 2);
2215:
2216: insert into ff_route_context_usages

Line 2220: values (ff_routes_s.currval,

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

Line 2274: values (ff_routes_s.nextval,

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

Line 2293: ff_routes_s.currval,

2289: DATA_TYPE,
2290: PARAMETER_NAME,
2291: SEQUENCE_NO )
2292: values (ff_route_parameters_s.nextval,
2293: ff_routes_s.currval,
2294: 'N',
2295: 'User Entity ID',
2296: 1);
2297:

Line 2304: values (ff_routes_s.currval,

2300: insert into ff_route_context_usages
2301: (route_id,
2302: context_id,
2303: sequence_no)
2304: values (ff_routes_s.currval,
2305: l_assignment_action_context_id,
2306: 1);
2307:
2308: insert into ff_route_context_usages

Line 2312: values (ff_routes_s.currval,

2308: insert into ff_route_context_usages
2309: (route_id,
2310: context_id,
2311: sequence_no)
2312: values (ff_routes_s.currval,
2313: l_tax_unit_context_id,
2314: 2);
2315:
2316: insert into ff_route_context_usages

Line 2320: values (ff_routes_s.currval,

2316: insert into ff_route_context_usages
2317: (route_id,
2318: context_id,
2319: sequence_no)
2320: values (ff_routes_s.currval,
2321: l_jurisdiction_context_id,
2322: 3);
2323:
2324:

Line 2377: values (ff_routes_s.nextval,

2373: last_updated_by,
2374: last_update_login,
2375: created_by,
2376: creation_date)
2377: values (ff_routes_s.nextval,
2378: 'ASSIGNMENT_GRE_PSD_JD_ARCHIVE',
2379: 'N',
2380: 'sql to retrieve Assignment,GRE and PSD JD based archived items',
2381: l_text,

Line 2396: ff_routes_s.currval,

2392: DATA_TYPE,
2393: PARAMETER_NAME,
2394: SEQUENCE_NO )
2395: values (ff_route_parameters_s.nextval,
2396: ff_routes_s.currval,
2397: 'N',
2398: 'User Entity ID',
2399: 1);
2400:

Line 2407: values (ff_routes_s.currval,

2403: insert into ff_route_context_usages
2404: (route_id,
2405: context_id,
2406: sequence_no)
2407: values (ff_routes_s.currval,
2408: l_assignment_action_context_id,
2409: 1);
2410:
2411: insert into ff_route_context_usages

Line 2415: values (ff_routes_s.currval,

2411: insert into ff_route_context_usages
2412: (route_id,
2413: context_id,
2414: sequence_no)
2415: values (ff_routes_s.currval,
2416: l_tax_unit_context_id,
2417: 2);
2418:
2419: insert into ff_route_context_usages

Line 2423: values (ff_routes_s.currval,

2419: insert into ff_route_context_usages
2420: (route_id,
2421: context_id,
2422: sequence_no)
2423: values (ff_routes_s.currval,
2424: l_jurisdiction_context_id,
2425: 3);
2426:
2427: