APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_RATES_B

Line 1870: ZX_RATES_B rate ,

1866: ZX_LINES line ,
1867: ZX_REGIMES_B regime ,
1868: ZX_TAXES_B tax ,
1869: ZX_STATUS_B status ,
1870: ZX_RATES_B rate ,
1871: ZX_JURISDICTIONS_B jur
1872: WHERE line.APPLICATION_ID = p_transaction_rec.APPLICATION_ID
1873: AND line.ENTITY_CODE = p_transaction_rec.ENTITY_CODE
1874: AND line.EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE

Line 2617: FROM zx_rates_b

2613: AND NVL(end_date_active, p_gl_date);
2614:
2615: CURSOR get_def_rec_settle_option_code(c_tax_rate_id NUMBER) IS
2616: SELECT def_rec_settlement_option_code
2617: FROM zx_rates_b
2618: WHERE tax_rate_id = c_tax_rate_id;
2619:
2620: CURSOR get_rate_code_csr(c_rate_id NUMBER) IS
2621: SELECT tax_rate_code

Line 2622: FROM zx_rates_b

2618: WHERE tax_rate_id = c_tax_rate_id;
2619:
2620: CURSOR get_rate_code_csr(c_rate_id NUMBER) IS
2621: SELECT tax_rate_code
2622: FROM zx_rates_b
2623: WHERE tax_rate_id = c_rate_id;
2624:
2625: -- Added following 2 cursors for Bug#13948234 --
2626: CURSOR get_chart_of_account(c_sob_id NUMBER) IS

Line 2646: l_def_rec_settle_option_code ZX_RATES_B.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE;

2642: l_interim_tax_ccid NUMBER;
2643: l_nrec_ccid NUMBER;
2644: l_rec_ccid NUMBER;
2645: l_tax_liab_ccid NUMBER;
2646: l_def_rec_settle_option_code ZX_RATES_B.DEF_REC_SETTLEMENT_OPTION_CODE%TYPE;
2647: l_chart_of_accounts_id NUMBER; -- Added for Bug#13948234 --
2648: l_account_string VARCHAR2(250); -- Added for Bug#13948234 --
2649: l_error_buffer VARCHAR2(2000);
2650:

Line 5760: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

5756: AND trx_line_id = c_trx_line_id
5757: AND trx_level_type = c_trx_level_type;
5758:
5759: CURSOR check_migrated_rule_code_csr(
5760: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
5761: SELECT rates.recovery_rule_code
5762: FROM zx_rates_b rates
5763: WHERE rates.tax_rate_id = c_tax_rate_id;
5764:

Line 5762: FROM zx_rates_b rates

5758:
5759: CURSOR check_migrated_rule_code_csr(
5760: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
5761: SELECT rates.recovery_rule_code
5762: FROM zx_rates_b rates
5763: WHERE rates.tax_rate_id = c_tax_rate_id;
5764:
5765: CURSOR check_current_rule_csr(
5766: c_rec_rate_result_id zx_rec_nrec_dist.rec_rate_result_id%TYPE) IS

Line 5823: l_recovery_rule_code zx_rates_b.recovery_rule_code%TYPE;

5819: AND factor_dtls.det_factor_templ_id = factors.det_factor_templ_id;
5820:
5821: l_service_type_code zx_rules_b.service_type_code%TYPE;
5822: l_priority zx_rules_b.priority%TYPE;
5823: l_recovery_rule_code zx_rates_b.recovery_rule_code%TYPE;
5824: l_error_buffer VARCHAR2(200);
5825:
5826: BEGIN
5827:

Line 6440: (SELECT tax_regime_code,tax from ZX_RATES_B

6436: SELECT zone_geography_type, override_geography_type,
6437: tax_id, tax, tax_regime_code
6438: FROM ZX_SCO_TAXES_B_V
6439: WHERE (tax_regime_code,tax) =
6440: (SELECT tax_regime_code,tax from ZX_RATES_B
6441: WHERE tax_rate_id = c_tax_rate_id);
6442:
6443: Cursor is_jurisdiction_acc_appl(c_tax_line_id number) is
6444: SELECT Count(*)