APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_RULES_TL

Line 1000: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *

996:
997: /****************************************************************************************
998: * Procedure: CREATE_RULES *
999: * Based on the input parameters, row(s) would be created in to ZX_RULES_B, *
1000: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *
1001: *****************************************************************************************/
1002:
1003: PROCEDURE CREATE_RULES
1004: ( --parameters rqrd for zx_rules_b

Line 1120: -- Inserting values in table zx_rules_tl

1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117:
1118: END;
1119:
1120: -- Inserting values in table zx_rules_tl
1121: BEGIN
1122: INSERT INTO zx_rules_tl (
1123: tax_rule_id ,
1124: tax_rule_name ,

Line 1122: INSERT INTO zx_rules_tl (

1118: END;
1119:
1120: -- Inserting values in table zx_rules_tl
1121: BEGIN
1122: INSERT INTO zx_rules_tl (
1123: tax_rule_id ,
1124: tax_rule_name ,
1125: created_by ,
1126: creation_date ,

Line 1153: FROM zx_rules_tl t

1149: WHERE l.installed_flag IN ('I', 'B')
1150: AND rules.record_type_code = 'MIGRATED'
1151: AND rules.tax_rule_code = l_tax_rule_code
1152: AND NOT EXISTS (SELECT NULL
1153: FROM zx_rules_tl t
1154: WHERE t.tax_rule_id = rules.tax_rule_id
1155: AND t.language = l.language_code);
1156:
1157: EXCEPTION WHEN OTHERS THEN