APPS.ZX_SIM_CONDITIONS_PKG dependencies on ZX_SIM_RULE_CONDITIONS

Line 178: INSERT INTO zx_sim_rule_conditions (

174: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
175: 'Simulate Conditions');
176: END IF;
177:
178: INSERT INTO zx_sim_rule_conditions (
179: simrule_condition_id,
180: condition_group_code,
181: determining_factor_class_code,
182: determining_factor_code,

Line 517: DELETE zx_sim_rule_conditions;

513: END IF;
514: DELETE zx_sim_rules_b;
515: DELETE zx_sim_rules_tl;
516: DELETE zx_sim_process_results;
517: DELETE zx_sim_rule_conditions;
518:
519: IF (g_level_statement >= g_current_runtime_level ) THEN
520: FND_LOG.STRING(g_level_statement,
521: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

Line 625: INSERT INTO zx_sim_rule_conditions (

621: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
622: 'Simulate Rule Conditions for Applicability');
623: END IF;
624:
625: INSERT INTO zx_sim_rule_conditions (
626: simrule_condition_id,
627: condition_group_code,
628: determining_factor_class_code,
629: determining_factor_cq_code,

Line 752: INSERT INTO zx_sim_rule_conditions (

748: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
749: 'Simulate Rule Conditions for Status Determination');
750: END IF;
751:
752: INSERT INTO zx_sim_rule_conditions (
753: simrule_condition_id,
754: condition_group_code,
755: determining_factor_class_code,
756: determining_factor_cq_code,

Line 873: INSERT INTO zx_sim_rule_conditions (

869: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
870: 'Simulate Rule Conditions for Rate Determination');
871: END IF;
872:
873: INSERT INTO zx_sim_rule_conditions (
874: simrule_condition_id,
875: condition_group_code,
876: determining_factor_class_code,
877: determining_factor_cq_code,

Line 971: FROM zx_sim_rule_conditions

967: p_error_buffer OUT NOCOPY VARCHAR2) AS
968:
969: CURSOR c_condgroups IS
970: SELECT condition_group_code
971: FROM zx_sim_rule_conditions
972: WHERE simulated_flag = 'Y'
973: GROUP BY condition_group_code
974: HAVING count(*) <= 10;
975:

Line 988: FROM zx_sim_rule_conditions

984: date_value,
985: alphanumeric_value,
986: value_low,
987: value_high
988: FROM zx_sim_rule_conditions
989: WHERE condition_group_code = c_group_code
990: AND ignore_flag='N';
991:
992: l_cond_cnt NUMBER;

Line 1106: FROM zx_sim_rule_conditions cond,

1102: determining_factor_class_code,
1103: determining_factor_cq_code,
1104: determining_factor_code,
1105: decode(ignore_flag,'N','Y','N') required_flag
1106: FROM zx_sim_rule_conditions cond,
1107: (select det_factor_templ_code,
1108: condition_group_code
1109: from zx_sim_process_results p,
1110: zx_sim_rules_b r

Line 1398: FROM zx_sim_rule_conditions

1394: date_value,
1395: alphanumeric_value,
1396: value_low,
1397: value_high
1398: FROM zx_sim_rule_conditions
1399: WHERE simulated_flag = 'Y';
1400:
1401: IF (g_level_statement >= g_current_runtime_level ) THEN
1402: FND_LOG.STRING(g_level_statement,