APPS.ZX_SIM_CONDITIONS_PKG dependencies on ZX_SIM_PROCESS_RESULTS

Line 139: INSERT INTO zx_sim_process_results (

135: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
136: 'Simulate Process Results');
137: END IF;
138:
139: INSERT INTO zx_sim_process_results (
140: sim_result_id,
141: sim_tax_rule_id,
142: condition_group_code,
143: priority,

Line 221: from zx_sim_process_results

217: value_low,
218: value_high
219: FROM zx_conditions
220: WHERE condition_group_code IN (select condition_group_code
221: from zx_sim_process_results
222: group by condition_group_code);
223:
224: IF (g_level_statement >= g_current_runtime_level ) THEN
225: FND_LOG.STRING(g_level_statement,

Line 516: DELETE zx_sim_process_results;

512: 'Delete any existing Simulated Rules, Process Results and 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,

Line 588: INTO zx_sim_process_results (

584: last_updated_by,
585: last_update_date,
586: p_application_id)
587: WHEN (1=1) Then
588: INTO zx_sim_process_results (
589: sim_result_id,
590: sim_tax_rule_id,
591: condition_group_code,
592: priority,

Line 715: INTO zx_sim_process_results (

711: last_updated_by,
712: last_update_date,
713: p_application_id)
714: WHEN (1=1) Then
715: INTO zx_sim_process_results (
716: sim_result_id,
717: sim_tax_rule_id,
718: condition_group_code,
719: priority,

Line 834: INTO zx_sim_process_results (

830: last_updated_by,
831: last_update_date,
832: p_application_id)
833: WHEN (1=1) Then
834: INTO zx_sim_process_results (
835: sim_result_id,
836: sim_tax_rule_id,
837: condition_group_code,
838: priority,

Line 1109: from zx_sim_process_results p,

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
1111: where p.sim_tax_rule_id = r.sim_tax_rule_id
1112: group by condition_group_code, det_factor_templ_code) rule
1113: WHERE cond.condition_group_code = rule.condition_group_code

Line 1147: zx_sim_process_results result

1143: sysdate)
1144: SELECT condition_group_code,
1145: det_factor_templ_code
1146: FROM zx_sim_rules_b rule,
1147: zx_sim_process_results result
1148: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id
1149: AND result.simulated_flag = 'Y'
1150: GROUP BY condition_group_code, det_factor_templ_code;
1151:

Line 1179: From zx_sim_process_results s

1175: from fnd_languages l,
1176: zx_condition_groups_b b
1177: where l.installed_flag in ('I', 'B')
1178: and exists (Select NULL
1179: From zx_sim_process_results s
1180: Where s.condition_group_code = b.condition_group_code
1181: And s.simulated_flag = 'Y')
1182: and not exists (Select NULL
1183: From zx_condition_groups_tl t

Line 1533: zx_sim_process_results result

1529: sysdate creation_date,
1530: fnd_global.user_id last_updated_by,
1531: sysdate last_update_date
1532: FROM zx_sim_rules_b rule,
1533: zx_sim_process_results result
1534: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id
1535: AND result.simulated_flag = 'Y';
1536:
1537: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1545: From zx_sim_process_results sim

1541: END IF;
1542:
1543: UPDATE zx_process_results
1544: SET priority = (Select sim.priority
1545: From zx_sim_process_results sim
1546: Where sim.sim_result_id = zx_process_results.result_id)
1547: WHERE result_id IN (Select sim_result_id
1548: From zx_sim_process_results sim
1549: Where sim.priority <> zx_process_results.priority

Line 1548: From zx_sim_process_results sim

1544: SET priority = (Select sim.priority
1545: From zx_sim_process_results sim
1546: Where sim.sim_result_id = zx_process_results.result_id)
1547: WHERE result_id IN (Select sim_result_id
1548: From zx_sim_process_results sim
1549: Where sim.priority <> zx_process_results.priority
1550: And sim.simulated_flag <> 'Y');
1551:
1552: IF (g_level_statement >= g_current_runtime_level ) THEN