DBA Data[Home] [Help]

APPS.PA_STATUS_LIST_ITEMS_PKG dependencies on DUAL

Line 22: SELECT pa_status_list_items_s.nextval into l_status_list_item_id FROM dual;

18: l_status_list_item_id NUMBER;
19: begin
20: l_status_list_item_id := x_status_list_item_id; --Added for bug 4565156
21: IF (X_STATUS_LIST_ITEM_ID = -99) THEN
22: SELECT pa_status_list_items_s.nextval into l_status_list_item_id FROM dual;
23: X_STATUS_LIST_ITEM_ID := l_status_list_item_id;
24: END IF;
25:
26: insert into PA_STATUS_LIST_ITEMS (