APPS.ZX_CONDITION_GROUPS_PKG dependencies on ZX_PROCESS_RESULTS

Line 1131: FROM ZX_PROCESS_RESULTS

1127: WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1128:
1129: CURSOR C_PROC_RES is
1130: SELECT TAX_RULE_ID,RESULT_ID
1131: FROM ZX_PROCESS_RESULTS
1132: WHERE Enabled_Flag = 'Y'
1133: AND CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE;
1134:
1135: CURSOR C_RES_RULE_ID(p_cur_rule_id NUMBER, p_cur_result_id NUMBER) is

Line 1137: FROM ZX_PROCESS_RESULTS

1133: AND CONDITION_GROUP_CODE = X_CONDITION_GROUP_CODE;
1134:
1135: CURSOR C_RES_RULE_ID(p_cur_rule_id NUMBER, p_cur_result_id NUMBER) is
1136: SELECT TAX_RULE_ID
1137: FROM ZX_PROCESS_RESULTS
1138: WHERE TAX_RULE_ID = p_cur_rule_id and Enabled_Flag = 'Y'
1139: and RESULT_ID <> p_cur_result_id;
1140:
1141: CURSOR C_RULE_REC (p_cur_rule_id1 NUMBER) is

Line 1154: -- Logic to update ZX_PROCESS_RESULTS and ZX_RULES tables,

1150: p_result_id NUMBER;
1151: ctr NUMBER;
1152: begin
1153:
1154: -- Logic to update ZX_PROCESS_RESULTS and ZX_RULES tables,
1155: -- to disable the associated results and rules
1156: OPEN C1;
1157: FETCH C1 INTO p_Enabled_Flag;
1158: CLOSE C1;

Line 1213: UPDATE ZX_PROCESS_RESULTS SET Enabled_Flag = 'N'

1209: END IF;
1210: CLOSE C_RES_RULE_ID;
1211: END LOOP;
1212: CLOSE C_PROC_RES;
1213: UPDATE ZX_PROCESS_RESULTS SET Enabled_Flag = 'N'
1214: WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1215: end if;
1216:
1217: update ZX_CONDITION_GROUPS_B set