APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_RULES_B

Line 5485: zx_rules_b rules,

5481: SELECT rules.service_type_code,
5482: rules.priority,
5483: factor_dtls.determining_factor_code
5484: FROM zx_process_results results,
5485: zx_rules_b rules,
5486: zx_det_factor_templ_b factors,
5487: zx_det_factor_templ_dtl factor_dtls
5488: WHERE results.result_id = c_rec_rate_result_id
5489: AND rules.tax_rule_id = results.tax_rule_id

Line 5494: c_service_type_code zx_rules_b.service_type_code%TYPE,

5490: AND factors.det_factor_templ_code = rules.det_factor_templ_code
5491: AND factor_dtls.det_factor_templ_id = factors.det_factor_templ_id;
5492:
5493: CURSOR check_other_rules_csr(
5494: c_service_type_code zx_rules_b.service_type_code%TYPE,
5495: c_priority zx_rules_b.priority%TYPE,
5496: c_application_id NUMBER,
5497: c_entity_code VARCHAR2,
5498: c_event_class_code VARCHAR2,

Line 5495: c_priority zx_rules_b.priority%TYPE,

5491: AND factor_dtls.det_factor_templ_id = factors.det_factor_templ_id;
5492:
5493: CURSOR check_other_rules_csr(
5494: c_service_type_code zx_rules_b.service_type_code%TYPE,
5495: c_priority zx_rules_b.priority%TYPE,
5496: c_application_id NUMBER,
5497: c_entity_code VARCHAR2,
5498: c_event_class_code VARCHAR2,
5499: c_tax zx_taxes_b.tax%TYPE,

Line 5501: c_recovery_type_code zx_rules_b.recovery_type_code%TYPE,

5497: c_entity_code VARCHAR2,
5498: c_event_class_code VARCHAR2,
5499: c_tax zx_taxes_b.tax%TYPE,
5500: c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5501: c_recovery_type_code zx_rules_b.recovery_type_code%TYPE,
5502: -- c_reference_application_id zx_rules_b.application_id%TYPE,
5503: c_tax_line_id zx_lines.tax_line_id%TYPE) IS
5504: SELECT rules.service_type_code,
5505: rules.priority,

Line 5502: -- c_reference_application_id zx_rules_b.application_id%TYPE,

5498: c_event_class_code VARCHAR2,
5499: c_tax zx_taxes_b.tax%TYPE,
5500: c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5501: c_recovery_type_code zx_rules_b.recovery_type_code%TYPE,
5502: -- c_reference_application_id zx_rules_b.application_id%TYPE,
5503: c_tax_line_id zx_lines.tax_line_id%TYPE) IS
5504: SELECT rules.service_type_code,
5505: rules.priority,
5506: factor_dtls.determining_factor_code

Line 5535: l_service_type_code zx_rules_b.service_type_code%TYPE;

5531: rules.effective_to IS NULL)
5532: AND factors.det_factor_templ_code = rules.det_factor_templ_code
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:

Line 5536: l_priority zx_rules_b.priority%TYPE;

5532: AND factors.det_factor_templ_code = rules.det_factor_templ_code
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