DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_RULES_B

Line 5771: zx_rules_b rules,

5767: SELECT rules.service_type_code,
5768: rules.priority,
5769: factor_dtls.determining_factor_code
5770: FROM zx_process_results results,
5771: zx_rules_b rules,
5772: zx_det_factor_templ_b factors,
5773: zx_det_factor_templ_dtl factor_dtls
5774: WHERE results.result_id = c_rec_rate_result_id
5775: AND rules.tax_rule_id = results.tax_rule_id

Line 5780: c_service_type_code zx_rules_b.service_type_code%TYPE,

5776: AND factors.det_factor_templ_code = rules.det_factor_templ_code
5777: AND factor_dtls.det_factor_templ_id = factors.det_factor_templ_id;
5778:
5779: CURSOR check_other_rules_csr(
5780: c_service_type_code zx_rules_b.service_type_code%TYPE,
5781: c_priority zx_rules_b.priority%TYPE,
5782: c_application_id NUMBER,
5783: c_entity_code VARCHAR2,
5784: c_event_class_code VARCHAR2,

Line 5781: c_priority zx_rules_b.priority%TYPE,

5777: AND factor_dtls.det_factor_templ_id = factors.det_factor_templ_id;
5778:
5779: CURSOR check_other_rules_csr(
5780: c_service_type_code zx_rules_b.service_type_code%TYPE,
5781: c_priority zx_rules_b.priority%TYPE,
5782: c_application_id NUMBER,
5783: c_entity_code VARCHAR2,
5784: c_event_class_code VARCHAR2,
5785: c_tax zx_taxes_b.tax%TYPE,

Line 5787: c_recovery_type_code zx_rules_b.recovery_type_code%TYPE,

5783: c_entity_code VARCHAR2,
5784: c_event_class_code VARCHAR2,
5785: c_tax zx_taxes_b.tax%TYPE,
5786: c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5787: c_recovery_type_code zx_rules_b.recovery_type_code%TYPE,
5788: -- c_reference_application_id zx_rules_b.application_id%TYPE,
5789: c_tax_line_id zx_lines.tax_line_id%TYPE) IS
5790: SELECT rules.service_type_code,
5791: rules.priority,

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

5784: c_event_class_code VARCHAR2,
5785: c_tax zx_taxes_b.tax%TYPE,
5786: c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
5787: c_recovery_type_code zx_rules_b.recovery_type_code%TYPE,
5788: -- c_reference_application_id zx_rules_b.application_id%TYPE,
5789: c_tax_line_id zx_lines.tax_line_id%TYPE) IS
5790: SELECT rules.service_type_code,
5791: rules.priority,
5792: factor_dtls.determining_factor_code

Line 5821: l_service_type_code zx_rules_b.service_type_code%TYPE;

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

Line 5822: l_priority zx_rules_b.priority%TYPE;

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