APPS.CZ_XML dependencies on DUAL

Line 123: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;

119: -------------------------------------------------------------------
120:
121: PROCEDURE Initialize(x_run_id OUT NOCOPY NUMBER) IS
122: BEGIN
123: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;
124: x_run_id := G_RUN_ID;
125: END Initialize;
126:
127: PROCEDURE Initialize

Line 134: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;

130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2) IS
132:
133: BEGIN
134: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO G_RUN_ID FROM dual;
135: x_run_id := G_RUN_ID;
136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137: x_msg_count := 0;
138: x_msg_data := NULL;

Line 1502: SELECT p_ui_def_id FROM dual) )

1498: START WITH ui_def_id = p_ui_def_id
1499: CONNECT by PRIOR ref_ui_def_id = ui_def_id AND
1500: deleted_flag = '0')
1501: UNION
1502: SELECT p_ui_def_id FROM dual) )
1503: LOOP
1504: Open_Parser();
1505: BEGIN
1506: restore_Parent_Elements(p_ui_def_id => i.ui_def_id);

Line 1944: SELECT CZ_UI_PAGE_ELEMENTS_S.NEXTVAL INTO l_element_id FROM dual;

1940:
1941: SELECT * INTO l_ui_node FROM CZ_UI_PAGE_ELEMENTS
1942: WHERE ui_def_id=i.ui_def_id AND page_id=j.page_id AND element_id=l_parent_element_id;
1943:
1944: SELECT CZ_UI_PAGE_ELEMENTS_S.NEXTVAL INTO l_element_id FROM dual;
1945:
1946: FOR templ IN(SELECT template_id,template_name FROM CZ_UI_TEMPLATES
1947: WHERE ui_def_id=0 AND jrad_doc=l_attribute_value AND deleted_flag='0')
1948: LOOP