APPS.IEM_ROUTE_PVT dependencies on DUAL

Line 511: FROM dual;

507:
508: --get next sequential number for route_id
509: SELECT IEM_ROUTES_s1.nextval
510: INTO l_seq_id
511: FROM dual;
512:
513: G_ROUTE_ID := l_seq_id;
514:
515: INSERT INTO IEM_ROUTES

Line 735: FROM dual;

731:
732:
733: SELECT IEM_ROUTE_RULES_s1.nextval
734: INTO l_seq_id
735: FROM dual;
736:
737:
738:
739: INSERT INTO IEM_ROUTE_RULES

Line 911: FROM dual;

907:
908: --actual API begins here
909: SELECT IEM_ACCOUNT_ROUTES_s1.nextval
910: INTO l_seq_id
911: FROM dual;
912:
913: INSERT INTO IEM_ACCOUNT_ROUTES
914:
915: (