[Home] [Help]
1832: ZX_LINES line ,
1833: ZX_REGIMES_B regime ,
1834: ZX_TAXES_B tax ,
1835: ZX_STATUS_B status ,
1836: ZX_RATES_B rate ,
1837: ZX_JURISDICTIONS_B jur
1838: WHERE line.APPLICATION_ID = p_transaction_rec.APPLICATION_ID
1839: AND line.ENTITY_CODE = p_transaction_rec.ENTITY_CODE
1840: AND line.EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
2440: and p_gl_date between nvl(start_date_active,p_gl_date) and nvl(end_date_active, p_gl_date);
2441:
2442: Cursor get_def_rec_settle_option_code(c_tax_rate_id IN NUMBER) is
2443: select def_rec_settlement_option_code
2444: from zx_rates_b
2445: where tax_rate_id = c_tax_rate_id;
2446:
2447: l_tax_rate_id NUMBER;
2448: l_ccid NUMBER;
2450: l_interim_tax_ccid NUMBER;
2451: l_nrec_ccid NUMBER;
2452: l_rec_ccid NUMBER;
2453: l_tax_liab_ccid NUMBER;
2454: l_def_rec_settle_option_code ZX_RATES_B.DEF_REC_SETTLEMENT_OPTION_CODE%type;
2455: l_error_buffer VARCHAR2(2000);
2456:
2457: BEGIN
2458: -- rewritten this API for bug 5645569. Per this bug
5470: AND trx_line_id = c_trx_line_id
5471: AND trx_level_type = c_trx_level_type;
5472:
5473: CURSOR check_migrated_rule_code_csr(
5474: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
5475: SELECT rates.recovery_rule_code
5476: FROM zx_rates_b rates
5477: WHERE rates.tax_rate_id = c_tax_rate_id;
5478:
5472:
5473: CURSOR check_migrated_rule_code_csr(
5474: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
5475: SELECT rates.recovery_rule_code
5476: FROM zx_rates_b rates
5477: WHERE rates.tax_rate_id = c_tax_rate_id;
5478:
5479: CURSOR check_current_rule_csr(
5480: c_rec_rate_result_id zx_rec_nrec_dist.rec_rate_result_id%TYPE) IS
5533: AND factor_dtls.det_factor_templ_id = factors.det_factor_templ_id;
5534:
5535: l_service_type_code zx_rules_b.service_type_code%TYPE;
5536: l_priority zx_rules_b.priority%TYPE;
5537: l_recovery_rule_code zx_rates_b.recovery_rule_code%TYPE;
5538: l_error_buffer VARCHAR2(200);
5539:
5540: BEGIN
5541: