APPS.CZ_REFS dependencies on DUAL

Line 62: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO m_RUN_ID FROM dual;

58:
59: PROCEDURE Initialize IS
60: BEGIN
61: FND_MSG_PUB.initialize;
62: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO m_RUN_ID FROM dual;
63: END Initialize;
64:
65: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
66: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 188: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;

184:
185: FUNCTION allocate_Expl_Id RETURN NUMBER IS
186: v_next_id NUMBER;
187: BEGIN
188: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;
189: RETURN v_next_id;
190: END allocate_Expl_Id;
191:
192: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 216: SELECT YES_FLAG INTO p_circularity_exists FROM dual WHERE

212:
213: p_circularity_exists VARCHAR2(1):=NO_FLAG;
214:
215: BEGIN
216: SELECT YES_FLAG INTO p_circularity_exists FROM dual WHERE
217: EXISTS
218: (SELECT component_id FROM CZ_MODEL_REF_EXPLS
219: WHERE model_id=p_target_model_id AND deleted_flag=NO_FLAG
220: AND ps_node_type IN (REFERENCE_TYPE,CONNECTOR_TYPE) AND component_id=p_source_model_id) OR

Line 332: SELECT 1 INTO v_iret FROM dual

328: RETURN FALSE;
329: END IF;
330: /* old code
331: BEGIN
332: SELECT 1 INTO v_iret FROM dual
333: WHERE
334: EXISTS(SELECT NULL FROM cz_expression_nodes x
335: WHERE deleted_flag = NO_FLAG
336: AND consequent_flag =YES_FLAG

Line 1081: SELECT YES_FLAG INTO v_connector_parent_exists FROM dual

1077: LOOP
1078:
1079: BEGIN
1080: v_connector_parent_exists:=NO_FLAG;
1081: SELECT YES_FLAG INTO v_connector_parent_exists FROM dual
1082: WHERE EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS
1083: WHERE ps_node_type=CONNECTOR_TYPE
1084: START WITH model_ref_expl_id=m.model_ref_expl_id
1085: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG AND deleted_flag=NO_FLAG);

Line 1945: FROM dual WHERE

1941: AND PRIOR ps_node_type IN(BOM_MODEL_TYPE,COMPONENT_TYPE,REFERENCE_TYPE))
1942: LOOP
1943: BEGIN
1944: SELECT '1' INTO v_exist_bom_nodes
1945: FROM dual WHERE
1946: EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=i.component_id
1947: AND ps_node_type=436 AND deleted_flag=NO_FLAG);
1948:
1949: IF i.referring_node_id IS NOT NULL THEN

Line 4172: SELECT '1' INTO v_ib_trackable FROM dual

4168:
4169: IF SQL%ROWCOUNT=0 THEN
4170: BEGIN
4171: v_ib_trackable:=NO_FLAG;
4172: SELECT '1' INTO v_ib_trackable FROM dual
4173: WHERE EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=t_m_chain_tbl(i)
4174: AND deleted_flag=NO_FLAG AND ib_trackable='1');
4175: v_ib_trackable:='1';
4176: t_trk_tbl(t_trk_tbl.COUNT+1):=t_m_chain_tbl(i);