APPS.CZ_REFS dependencies on DUAL

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

62:
63: PROCEDURE Initialize IS
64: BEGIN
65: FND_MSG_PUB.initialize;
66: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO m_RUN_ID FROM dual;
67: END Initialize;
68:
69: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
70: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

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

188:
189: FUNCTION allocate_Expl_Id RETURN NUMBER IS
190: v_next_id NUMBER;
191: BEGIN
192: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;
193: RETURN v_next_id;
194: END allocate_Expl_Id;
195:
196: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 220: SELECT YES_FLAG INTO p_circularity_exists FROM dual WHERE

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

Line 398: SELECT 1 INTO v_iret FROM dual

394: RETURN FALSE;
395: END IF;
396: /* old code
397: BEGIN
398: SELECT 1 INTO v_iret FROM dual
399: WHERE
400: EXISTS(SELECT NULL FROM cz_expression_nodes x
401: WHERE deleted_flag = NO_FLAG
402: AND consequent_flag =YES_FLAG

Line 1147: SELECT YES_FLAG INTO v_connector_parent_exists FROM dual

1143: LOOP
1144:
1145: BEGIN
1146: v_connector_parent_exists:=NO_FLAG;
1147: SELECT YES_FLAG INTO v_connector_parent_exists FROM dual
1148: WHERE EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS
1149: WHERE ps_node_type=CONNECTOR_TYPE
1150: START WITH model_ref_expl_id=m.model_ref_expl_id
1151: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG AND deleted_flag=NO_FLAG);

Line 2011: FROM dual WHERE

2007: AND PRIOR ps_node_type IN(BOM_MODEL_TYPE,COMPONENT_TYPE,REFERENCE_TYPE))
2008: LOOP
2009: BEGIN
2010: SELECT '1' INTO v_exist_bom_nodes
2011: FROM dual WHERE
2012: EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=i.component_id
2013: AND ps_node_type=436 AND deleted_flag=NO_FLAG);
2014:
2015: IF i.referring_node_id IS NOT NULL THEN

Line 4250: SELECT '1' INTO v_ib_trackable FROM dual

4246:
4247: IF SQL%ROWCOUNT=0 THEN
4248: BEGIN
4249: v_ib_trackable:=NO_FLAG;
4250: SELECT '1' INTO v_ib_trackable FROM dual
4251: WHERE EXISTS(SELECT NULL FROM CZ_PS_NODES WHERE devl_project_id=t_m_chain_tbl(i)
4252: AND deleted_flag=NO_FLAG AND ib_trackable='1');
4253: v_ib_trackable:='1';
4254: t_trk_tbl(t_trk_tbl.COUNT+1):=t_m_chain_tbl(i);