APPS.ZX_SIM_CONDITIONS_PKG dependencies on ZX_PROCESS_RESULTS

Line 168: FROM zx_process_results

164: result_type_code,
165: tax_status_code,
166: numeric_result,
167: alphanumeric_result
168: FROM zx_process_results
169: WHERE tax_rule_id IN (select sim_tax_rule_id
170: from zx_sim_rules_b);
171:
172: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 599: VALUES (zx_process_results_s.nextval,

595: created_by,
596: creation_date,
597: last_updated_by,
598: last_update_date)
599: VALUES (zx_process_results_s.nextval,
600: sim_tax_rule_id,
601: 'G_SIMAP_' || to_char(l_cg_id),
602: 1,
603: 'CODE',

Line 726: VALUES (zx_process_results_s.nextval,

722: created_by,
723: creation_date,
724: last_updated_by,
725: last_update_date)
726: VALUES (zx_process_results_s.nextval,
727: sim_tax_rule_id,
728: 'G_SIMST_' || to_char(l_cg_id),
729: 1,
730: 'CODE',

Line 846: VALUES (zx_process_results_s.nextval,

842: created_by,
843: creation_date,
844: last_updated_by,
845: last_update_date)
846: VALUES (zx_process_results_s.nextval,
847: sim_tax_rule_id,
848: 'G_SIMRT_' || to_char(l_cg_id),
849: 1,
850: p_tax_status_code,

Line 1499: INSERT INTO zx_process_results (

1495: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1496: 'Create Process Results Setup');
1497: END IF;
1498:
1499: INSERT INTO zx_process_results (
1500: result_id,
1501: content_owner_id,
1502: condition_group_id,
1503: condition_group_code,

Line 1543: UPDATE zx_process_results

1539: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1540: 'Update Process Results for which Priority has been changed in Simulator');
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

Line 1546: Where sim.sim_result_id = zx_process_results.result_id)

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
1550: And sim.simulated_flag <> 'Y');

Line 1549: Where sim.priority <> zx_process_results.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
1553: FND_LOG.STRING(g_level_statement,