APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_RULES_TL

Line 1036: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *

1032:
1033: /****************************************************************************************
1034: * Procedure: CREATE_RULES *
1035: * Based on the input parameters, row(s) would be created in to ZX_RULES_B, *
1036: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *
1037: *****************************************************************************************/
1038:
1039: PROCEDURE CREATE_RULES
1040: ( --parameters rqrd for zx_rules_b

Line 1158: -- Inserting values in table zx_rules_tl

1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: END;
1157:
1158: -- Inserting values in table zx_rules_tl
1159: BEGIN
1160: INSERT INTO zx_rules_tl (
1161: tax_rule_id,
1162: tax_rule_name,

Line 1160: INSERT INTO zx_rules_tl (

1156: END;
1157:
1158: -- Inserting values in table zx_rules_tl
1159: BEGIN
1160: INSERT INTO zx_rules_tl (
1161: tax_rule_id,
1162: tax_rule_name,
1163: created_by,
1164: creation_date,

Line 1191: FROM zx_rules_tl t

1187: WHERE l.installed_flag IN ('I', 'B')
1188: AND rules.record_type_code = 'MIGRATED'
1189: AND rules.tax_rule_code = l_tax_rule_code
1190: AND NOT EXISTS (SELECT NULL
1191: FROM zx_rules_tl t
1192: WHERE t.tax_rule_id = rules.tax_rule_id
1193: AND t.language = l.language_code);
1194:
1195: EXCEPTION WHEN OTHERS THEN