APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_RULES

Line 948: FROM jl_zz_ar_tx_rules tr

944: -- Bugfix 1388703
945: CURSOR c_rule IS
946: SELECT tr.rule,
947: tr.rule_id rule_id
948: FROM jl_zz_ar_tx_rules tr
949: WHERE tr.tax_rule_level = p_level
950: AND tr.tax_category_id = p_tax_category_id
951: AND nvl(tr.contributor_type,'~') = p_contributor_type
952: AND tr.cust_trx_type_id = p_cust_trx_type_id

Line 962: FROM jl_zz_ar_tx_rules tr,

958: -- Bugfix 1388703
959: CURSOR c_rule_default IS
960: SELECT tr.rule rule,
961: tr.rule_id rule_id
962: FROM jl_zz_ar_tx_rules tr,
963: ar_system_parameters sp
964: WHERE tr.tax_rule_level = p_level
965: AND tr.tax_category_id = p_tax_category_id
966: AND tr.contributor_type = 'DEFAULT'

Line 1174: FROM jl_zz_ar_tx_rules tr

1170: -- Bugfix 1388703
1171: CURSOR c_rule IS
1172: SELECT tr.rule,
1173: tr.rule_id rule_id
1174: FROM jl_zz_ar_tx_rules tr
1175: WHERE tr.tax_rule_level = p_level
1176: AND tr.tax_category_id = p_tax_category_id
1177: AND nvl(tr.contributor_type,'~') = p_contributor_type
1178: AND tr.cust_trx_type_id = p_cust_trx_type_id

Line 1188: FROM jl_zz_ar_tx_rules tr,

1184: -- Bugfix 1388703
1185: CURSOR c_rule_default IS
1186: SELECT tr.rule rule,
1187: tr.rule_id rule_id
1188: FROM jl_zz_ar_tx_rules tr,
1189: ar_system_parameters sp
1190: WHERE tr.tax_rule_level = p_level
1191: AND tr.tax_category_id = p_tax_category_id
1192: AND tr.contributor_type = 'DEFAULT'

Line 1415: FROM jl_zz_ar_tx_rules tr

1411: -- Bugfix 1388703
1412: CURSOR c_rule IS
1413: SELECT tr.rule,
1414: tr.rule_id rule_id
1415: FROM jl_zz_ar_tx_rules tr
1416: WHERE tr.tax_rule_level = p_level
1417: AND tr.tax_category_id = p_tax_category_id
1418: AND NVL(tr.contributor_type,'~') = p_contributor_type
1419: AND tr.cust_trx_type_id = p_cust_trx_type_id

Line 1429: FROM jl_zz_ar_tx_rules tr,

1425: -- Bugfix 1388703
1426: CURSOR c_rule_default IS
1427: SELECT tr.rule rule,
1428: tr.rule_id rule_id
1429: FROM jl_zz_ar_tx_rules tr,
1430: ar_system_parameters sp
1431: WHERE tr.tax_rule_level = p_level
1432: AND tr.tax_category_id = p_tax_category_id
1433: AND tr.contributor_type = 'DEFAULT'

Line 2799: l_rule_code jl_zz_ar_tx_rules.rule%type;

2795: p_exchange_rate IN NUMBER) IS
2796:
2797: l_rel_tax_line_amt_ctr BINARY_INTEGER;
2798: l_rel_tax_lines_ctr BINARY_INTEGER;
2799: l_rule_code jl_zz_ar_tx_rules.rule%type;
2800: l_tax_code ar_vat_tax.tax_code%type;
2801: l_grp_attr_name VARCHAR2(30);
2802: l_grp_attr_val VARCHAR2(30);
2803: l_operation_level VARCHAR2(30);

Line 2908: FROM jl_zz_ar_tx_rules

2904: -- Bugfix 1388703
2905: BEGIN
2906: SELECT rule
2907: INTO l_rule_code
2908: FROM jl_zz_ar_tx_rules
2909: WHERE rule_id = p_rule_id;
2910: EXCEPTION
2911: WHEN OTHERS THEN
2912: l_rule_code := NULL;

Line 4068: -- jl_zz_ar_tx_rules table

4064: -- bug#6834705
4065: -- if the invoice is credit memo, need to get
4066: -- cust_trx_type_id from the original invoice
4067: -- in order to get the correct rule defined from
4068: -- jl_zz_ar_tx_rules table
4069: --
4070:
4071: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
4072: OPEN get_orig_trx_type_id_c

Line 4546: v_rule jl_zz_ar_tx_rules.rule%type;

4542: p_ship_from_warehouse_id IN NUMBER)
4543: RETURN VARCHAR2 IS
4544:
4545: v_message_text VARCHAR2(150) := NULL;
4546: v_rule jl_zz_ar_tx_rules.rule%type;
4547:
4548:
4549:
4550: BEGIN

Line 4563: FROM jl_zz_ar_tx_rules r

4559: END IF;
4560:
4561: SELECT r.rule
4562: INTO v_rule
4563: FROM jl_zz_ar_tx_rules r
4564: WHERE r.rule_id = p_rule_id;
4565:
4566: IF (g_level_statement >= g_current_runtime_level) THEN
4567: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','get_legal_message: ' || '-- Rule Code: '||v_rule);