6998: -- Validate the Fiscal Classification Type using the following query
6999: BEGIN
7000: SELECT owner_id_char
7001: INTO l_classification_type
7002: FROM zx_fc_types_vl
7003: WHERE classification_type_categ_code = 'PARTY_FISCAL_CLASS'
7004: AND SYSDATE BETWEEN nvl(effective_from, SYSDATE) AND
7005: nvl(effective_to, SYSDATE)
7006: AND classification_type_code =
7917: BEGIN
7918:
7919: SELECT owner_id_char
7920: INTO l_classification_type
7921: FROM zx_fc_types_vl
7922: WHERE classification_type_categ_code = 'PARTY_FISCAL_CLASS'
7923: AND SYSDATE BETWEEN nvl(effective_from, SYSDATE) AND
7924: nvl(effective_to, SYSDATE)
7925: AND classification_type_code = l_fiscal_class_rec_tab(cntr)