APPS.GMD_ROUTING_DESIGNER_PKG dependencies on DUAL

Line 1165: FROM FND_DUAL;

1161:
1162:
1163: CURSOR Cur_routing_id IS
1164: SELECT gem5_routing_id_s.NEXTVAL
1165: FROM FND_DUAL;
1166:
1167: l_return_status VARCHAR2(5);
1168: l_owner_orgn_id VARCHAR2(4);
1169: l_timestamp DATE;

Line 1483: FROM FND_DUAL;

1479: x_error_msg OUT NOCOPY VARCHAR2) IS
1480:
1481: CURSOR Cur_routing_id IS
1482: SELECT gem5_routing_id_s.NEXTVAL
1483: FROM FND_DUAL;
1484:
1485: CURSOR Cur_get_hdr IS
1486: SELECT *
1487: FROM gmd_routings

Line 1508: FROM sys.dual;

1504: line_no <> -1;
1505:
1506: CURSOR Get_text_code IS
1507: SELECT gem5_text_code_s.NEXTVAL
1508: FROM sys.dual;
1509:
1510: CURSOR Get_RoutingStepId IS
1511: SELECT gem5_routingstep_id_s.NEXTVAL
1512: FROM sys.dual;

Line 1512: FROM sys.dual;

1508: FROM sys.dual;
1509:
1510: CURSOR Get_RoutingStepId IS
1511: SELECT gem5_routingstep_id_s.NEXTVAL
1512: FROM sys.dual;
1513:
1514: TYPE detail_tab IS TABLE OF Cur_get_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
1515: TYPE dep_tab IS TABLE OF Cur_get_dep%ROWTYPE INDEX BY BINARY_INTEGER;
1516: TYPE text_tab IS TABLE OF Get_Text%ROWTYPE INDEX BY BINARY_INTEGER;