DBA Data[Home] [Help]

APPS.ZX_SIM_RULES_PKG dependencies on ZX_SIM_RULES_B

Line 47: INSERT INTO ZX_SIM_RULES_B (sim_tax_rule_id,

43: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
44: 'ZX_SIM_RULES_PKG: Insert_Row (+)');
45: END IF;
46:
47: INSERT INTO ZX_SIM_RULES_B (sim_tax_rule_id,
48: content_owner_id,
49: tax_rule_code,
50: tax,
51: tax_regime_code,

Line 136: UPDATE ZX_SIM_RULES_B

132: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
133: 'ZX_SIM_RULES_PKG: Update_Row (+)');
134: END IF;
135:
136: UPDATE ZX_SIM_RULES_B
137: SET sim_tax_rule_id = p_sim_tax_rule_id,
138: content_owner_id = p_content_owner_id,
139: tax_rule_code = p_tax_rule_code,
140: tax = p_tax,

Line 265: FROM ZX_SIM_RULES_B

261: request_id,
262: program_application_id,
263: program_id,
264: program_login_id
265: FROM ZX_SIM_RULES_B
266: WHERE SIM_TAX_RULE_ID = p_sim_tax_rule_id
267: AND CONTENT_OWNER_ID = p_content_owner_id
268: AND APPLICATION_ID = p_application_id;
269:

Line 349: from ZX_SIM_RULES_B B

345:
346: delete from ZX_SIM_RULES_TL T
347: where not exists
348: (select NULL
349: from ZX_SIM_RULES_B B
350: where B.SIM_TAX_RULE_ID = T.SIM_TAX_RULE_ID);
351: update ZX_SIM_RULES_TL T set (
352: TAX_RULE_NAME
353: ) = (select B.TAX_RULE_NAME