DBA Data[Home] [Help]

APPS.PA_EXPENDITURE_ITEMS_PKG dependencies on DUAL

Line 113: cursor get_itemid is select pa_expenditure_items_s.nextval from sys.dual;

109: ) is
110:
111: cursor return_rowid is select rowid from pa_expenditure_items
112: where expenditure_item_id = x_expenditure_item_id;
113: cursor get_itemid is select pa_expenditure_items_s.nextval from sys.dual;
114:
115: status NUMBER;
116: l_rowid VARCHAR2(1000);
117: l_expenditure_item_id NUMBER;