eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_SIM_CONDITIONS_PKG dependencies on ZX_RULES_B

Line 93: FROM zx_rules_b

89: last_update_login,
90: effective_to,
91: application_id,
92: recovery_type_code
93: FROM zx_rules_b
94: WHERE tax_regime_code = p_tax_regime_code
95: and tax = p_tax
96: and content_owner_id = p_content_owner_id
97: and NVL(application_id, p_application_id) = p_application_id

Line 549: Select zx_rules_b_s.nextval,

545: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
546: 'Simulate Rules and Process Results for Applicability');
547: END IF;
548:
549: Select zx_rules_b_s.nextval,
550: zx_condition_groups_b_s.nextval
551: Into l_rule_id,
552: l_cg_id
553: From Dual;

Line 675: Select zx_rules_b_s.nextval,

671: FND_LOG.STRING(g_level_statement,
672: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
673: 'Simulate Rules and Process Results for Status Determination');
674: END IF;
675: Select zx_rules_b_s.nextval,
676: zx_condition_groups_b_s.nextval
677: Into l_rule_id,
678: l_cg_id
679: From Dual;

Line 795: Select zx_rules_b_s.nextval,

791: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
792: 'Simulate Rules and Process Results for Rate Determination');
793: END IF;
794:
795: Select zx_rules_b_s.nextval,
796: zx_condition_groups_b_s.nextval
797: Into l_rule_id,
798: l_cg_id
799: From Dual;

Line 1407: INSERT INTO zx_rules_b (

1403: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1404: 'Create Rules Setup');
1405: END IF;
1406:
1407: INSERT INTO zx_rules_b (
1408: tax_rule_id,
1409: content_owner_id,
1410: tax_rule_code,
1411: tax,

Line 1467: zx_rules_b b

1463: fnd_global.user_id created_by,
1464: sysdate last_update_date,
1465: fnd_global.user_id last_updated_by
1466: from fnd_languages l,
1467: zx_rules_b b
1468: where l.installed_flag in ('I', 'B')
1469: and exists (Select NULL
1470: From zx_sim_rules_b s
1471: Where s.sim_tax_rule_id = b.tax_rule_id

Line 1484: UPDATE zx_rules_b

1480: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1481: 'Update Rules Setup for which Priority has been changed in Simulator');
1482: END IF;
1483:
1484: UPDATE zx_rules_b
1485: SET priority = (Select sim.priority
1486: From zx_sim_rules_b sim
1487: Where sim.sim_tax_rule_id = zx_rules_b.tax_rule_id)
1488: WHERE tax_rule_id IN (Select sim_tax_rule_id

Line 1487: Where sim.sim_tax_rule_id = zx_rules_b.tax_rule_id)

1483:
1484: UPDATE zx_rules_b
1485: SET priority = (Select sim.priority
1486: From zx_sim_rules_b sim
1487: Where sim.sim_tax_rule_id = zx_rules_b.tax_rule_id)
1488: WHERE tax_rule_id IN (Select sim_tax_rule_id
1489: From zx_sim_rules_b sim
1490: Where sim.priority <> zx_rules_b.priority
1491: And sim.simulated_flag <> 'Y');

Line 1490: Where sim.priority <> zx_rules_b.priority

1486: From zx_sim_rules_b sim
1487: Where sim.sim_tax_rule_id = zx_rules_b.tax_rule_id)
1488: WHERE tax_rule_id IN (Select sim_tax_rule_id
1489: From zx_sim_rules_b sim
1490: Where sim.priority <> zx_rules_b.priority
1491: And sim.simulated_flag <> 'Y');
1492:
1493: IF (g_level_statement >= g_current_runtime_level ) THEN
1494: FND_LOG.STRING(g_level_statement,