APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_RULES

Line 928: FROM jl_zz_ar_tx_rules tr

924: -- Bugfix 1388703
925: CURSOR c_rule IS
926: SELECT tr.rule,
927: tr.rule_id rule_id
928: FROM jl_zz_ar_tx_rules tr
929: WHERE tr.tax_rule_level = p_level
930: AND tr.tax_category_id = p_tax_category_id
931: AND nvl(tr.contributor_type,'~') = p_contributor_type
932: AND tr.cust_trx_type_id = p_cust_trx_type_id

Line 942: FROM jl_zz_ar_tx_rules tr,

938: -- Bugfix 1388703
939: CURSOR c_rule_default IS
940: SELECT tr.rule rule,
941: tr.rule_id rule_id
942: FROM jl_zz_ar_tx_rules tr,
943: ar_system_parameters sp
944: WHERE tr.tax_rule_level = p_level
945: AND tr.tax_category_id = p_tax_category_id
946: AND tr.contributor_type = 'DEFAULT'

Line 1154: FROM jl_zz_ar_tx_rules tr

1150: -- Bugfix 1388703
1151: CURSOR c_rule IS
1152: SELECT tr.rule,
1153: tr.rule_id rule_id
1154: FROM jl_zz_ar_tx_rules tr
1155: WHERE tr.tax_rule_level = p_level
1156: AND tr.tax_category_id = p_tax_category_id
1157: AND nvl(tr.contributor_type,'~') = p_contributor_type
1158: AND tr.cust_trx_type_id = p_cust_trx_type_id

Line 1168: FROM jl_zz_ar_tx_rules tr,

1164: -- Bugfix 1388703
1165: CURSOR c_rule_default IS
1166: SELECT tr.rule rule,
1167: tr.rule_id rule_id
1168: FROM jl_zz_ar_tx_rules tr,
1169: ar_system_parameters sp
1170: WHERE tr.tax_rule_level = p_level
1171: AND tr.tax_category_id = p_tax_category_id
1172: AND tr.contributor_type = 'DEFAULT'

Line 1395: FROM jl_zz_ar_tx_rules tr

1391: -- Bugfix 1388703
1392: CURSOR c_rule IS
1393: SELECT tr.rule,
1394: tr.rule_id rule_id
1395: FROM jl_zz_ar_tx_rules tr
1396: WHERE tr.tax_rule_level = p_level
1397: AND tr.tax_category_id = p_tax_category_id
1398: AND NVL(tr.contributor_type,'~') = p_contributor_type
1399: AND tr.cust_trx_type_id = p_cust_trx_type_id

Line 1409: FROM jl_zz_ar_tx_rules tr,

1405: -- Bugfix 1388703
1406: CURSOR c_rule_default IS
1407: SELECT tr.rule rule,
1408: tr.rule_id rule_id
1409: FROM jl_zz_ar_tx_rules tr,
1410: ar_system_parameters sp
1411: WHERE tr.tax_rule_level = p_level
1412: AND tr.tax_category_id = p_tax_category_id
1413: AND tr.contributor_type = 'DEFAULT'

Line 2778: l_rule_code jl_zz_ar_tx_rules.rule%type;

2774: p_exchange_rate IN NUMBER) IS
2775:
2776: l_rel_tax_line_amt_ctr BINARY_INTEGER;
2777: l_rel_tax_lines_ctr BINARY_INTEGER;
2778: l_rule_code jl_zz_ar_tx_rules.rule%type;
2779: l_tax_code ar_vat_tax.tax_code%type;
2780: l_grp_attr_name VARCHAR2(30);
2781: l_grp_attr_val VARCHAR2(30);
2782: l_operation_level VARCHAR2(30);

Line 2886: FROM jl_zz_ar_tx_rules

2882: -- Bugfix 1388703
2883: BEGIN
2884: SELECT rule
2885: INTO l_rule_code
2886: FROM jl_zz_ar_tx_rules
2887: WHERE rule_id = p_rule_id;
2888: EXCEPTION
2889: WHEN OTHERS THEN
2890: l_rule_code := NULL;

Line 3980: -- jl_zz_ar_tx_rules table

3976: -- bug#6834705
3977: -- if the invoice is credit memo, need to get
3978: -- cust_trx_type_id from the original invoice
3979: -- in order to get the correct rule defined from
3980: -- jl_zz_ar_tx_rules table
3981: --
3982:
3983: IF ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.credit_memo_flag = TRUE THEN
3984: OPEN get_orig_trx_type_id_c

Line 4418: v_rule jl_zz_ar_tx_rules.rule%type;

4414: p_ship_from_warehouse_id IN NUMBER)
4415: RETURN VARCHAR2 IS
4416:
4417: v_message_text VARCHAR2(150) := NULL;
4418: v_rule jl_zz_ar_tx_rules.rule%type;
4419:
4420:
4421:
4422: BEGIN

Line 4435: FROM jl_zz_ar_tx_rules r

4431: END IF;
4432:
4433: SELECT r.rule
4434: INTO v_rule
4435: FROM jl_zz_ar_tx_rules r
4436: WHERE r.rule_id = p_rule_id;
4437:
4438: IF (g_level_statement >= g_current_runtime_level) THEN
4439: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.JL_ZZ_TAX','get_legal_message: ' || '-- Rule Code: '||v_rule);