APPS.GML_RECV_TRANS_PKG dependencies on DUAL

Line 63: FROM sys.dual;

59: err_msg VARCHAR2(100);
60:
61: CURSOR RCV_HEADER_INT_CUR IS
62: SELECT RCV_HEADERS_INTERFACE_S.nextval
63: FROM sys.dual;
64:
65: CURSOR RCV_TRANS_INT_CUR IS
66: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval
67: FROM sys.dual;

Line 67: FROM sys.dual;

63: FROM sys.dual;
64:
65: CURSOR RCV_TRANS_INT_CUR IS
66: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval
67: FROM sys.dual;
68:
69: CURSOR RCV_INT_GROUPS_CUR IS
70: SELECT RCV_INTERFACE_GROUPS_S.nextval
71: FROM sys.dual;

Line 71: FROM sys.dual;

67: FROM sys.dual;
68:
69: CURSOR RCV_INT_GROUPS_CUR IS
70: SELECT RCV_INTERFACE_GROUPS_S.nextval
71: FROM sys.dual;
72:
73: v_rcv_receipt_num po_recv_hdr.recv_no%TYPE;
74: v_recv_exists VARCHAR2(100);
75:

Line 899: FROM sys.dual;

895:
896:
897: CURSOR RCV_TRANS_INT_CUR IS
898: SELECT RCV_TRANSACTIONS_INTERFACE_S.nextval
899: FROM sys.dual;
900:
901: CURSOR RCV_INT_GROUPS_CUR IS
902: SELECT RCV_INTERFACE_GROUPS_S.nextval
903: FROM sys.dual;

Line 903: FROM sys.dual;

899: FROM sys.dual;
900:
901: CURSOR RCV_INT_GROUPS_CUR IS
902: SELECT RCV_INTERFACE_GROUPS_S.nextval
903: FROM sys.dual;
904:
905: CURSOR opm_recv_no_cur(vc_recv_id NUMBER) IS
906: SELECT recv_no, shipvend_id,to_whse,recv_date,gross_wt,net_wt,tare_wt, substrb(waybill_no, 1, 20), /* Bug 2458366 - added waybill_no*/
907: bol_um,billing_currency