APPS.CZ_REFS dependencies on CZ_RULES

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

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

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

401: WHERE deleted_flag = NO_FLAG
402: AND consequent_flag =YES_FLAG
403: AND ps_node_id = p_ps_node_id
404: AND EXISTS
405: (SELECT NULL FROM cz_rules WHERE (antecedent_id=x.express_id OR consequent_id=x.express_id
406: OR amount_id=x.express_id) AND disabled_flag=NO_FLAG
407: AND devl_project_id=p_model_id AND deleted_flag=NO_FLAG));
408: EXCEPTION
409: WHEN NO_DATA_FOUND THEN

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

463: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
464: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
465:
466: BEGIN
467: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES
468: WHERE devl_project_id=p_model_id AND disabled_flag=NO_FLAG
469: AND deleted_flag=NO_FLAG)
470: LOOP
471: BEGIN

Line 4305: WHERE rule_id IN(SELECT rule_id FROM CZ_RULES

4301: FND_MSG_PUB.initialize;
4302:
4303: FOR i IN(SELECT expr_node_id,rule_id
4304: FROM CZ_EXPRESSION_NODES
4305: WHERE rule_id IN(SELECT rule_id FROM CZ_RULES
4306: WHERE devl_project_id IN(SELECT devl_project_id FROM CZ_PS_NODES
4307: WHERE ps_node_id=p_ps_node_id) AND deleted_flag=NO_FLAG AND disabled_flag=NO_FLAG) AND
4308: ps_node_id=p_ps_node_id AND expr_type=205 AND deleted_flag=NO_FLAG)
4309: LOOP