DBA Data[Home] [Help]

APPS.PA_EXPENDITURE_ITEMS_PKG dependencies on PA_EXPENDITURE_ITEMS_S

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

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