DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on ZX_FC_TYPES_VL

Line 7002: FROM zx_fc_types_vl

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 =

Line 7921: FROM zx_fc_types_vl

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)