APPS.CZ_REFS dependencies on CZ_RULES

Line 153: (SELECT NULL FROM cz_rules WHERE (antecedent_id=x.express_id OR consequent_id=x.express_id

149: WHERE deleted_flag = NO_FLAG
150: AND consequent_flag =YES_FLAG
151: AND ps_node_id = nodes.ps_node_id
152: AND EXISTS
153: (SELECT NULL FROM cz_rules WHERE (antecedent_id=x.express_id OR consequent_id=x.express_id
154: OR amount_id=x.express_id) AND disabled_flag=NO_FLAG
155: AND devl_project_id=p_model_id AND deleted_flag=NO_FLAG)));
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN

Line 339: (SELECT NULL FROM cz_rules WHERE (antecedent_id=x.express_id OR consequent_id=x.express_id

335: WHERE deleted_flag = NO_FLAG
336: AND consequent_flag =YES_FLAG
337: AND ps_node_id = p_ps_node_id
338: AND EXISTS
339: (SELECT NULL FROM cz_rules WHERE (antecedent_id=x.express_id OR consequent_id=x.express_id
340: OR amount_id=x.express_id) AND disabled_flag=NO_FLAG
341: AND devl_project_id=p_model_id AND deleted_flag=NO_FLAG));
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN

Line 401: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES

397: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
398: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
399:
400: BEGIN
401: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES
402: WHERE devl_project_id=p_model_id AND disabled_flag=NO_FLAG
403: AND deleted_flag=NO_FLAG)
404: LOOP
405: BEGIN

Line 4227: WHERE rule_id IN(SELECT rule_id FROM CZ_RULES

4223: FND_MSG_PUB.initialize;
4224:
4225: FOR i IN(SELECT expr_node_id,rule_id
4226: FROM CZ_EXPRESSION_NODES
4227: WHERE rule_id IN(SELECT rule_id FROM CZ_RULES
4228: WHERE devl_project_id IN(SELECT devl_project_id FROM CZ_PS_NODES
4229: WHERE ps_node_id=p_ps_node_id) AND deleted_flag=NO_FLAG AND disabled_flag=NO_FLAG) AND
4230: ps_node_id=p_ps_node_id AND expr_type=205 AND deleted_flag=NO_FLAG)
4231: LOOP