APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_LINES_DET_FACTORS

Line 488: FROM ZX_LINES_DET_FACTORS D

484: (SELECT D.product_fisc_classification,
485: D.trx_business_category,
486: D.product_category,
487: D.output_tax_classification_code
488: FROM ZX_LINES_DET_FACTORS D
489: WHERE D.event_class_code = L.source_event_class_code
490: AND D.application_id = L.source_application_id
491: AND D.entity_code = L.source_entity_code
492: AND D.trx_id = L.source_trx_id

Line 667: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

663: PROCEDURE default_tax_attr (p_trx_line_index IN NUMBER,
664: x_return_status OUT NOCOPY VARCHAR2) is
665:
666: l_organization_id hr_organization_units.organization_id%type;
667: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
668: l_product_category zx_lines_det_factors.product_category%type;
669: l_trx_business_category zx_lines_det_factors.trx_business_category%type;
670:
671: CURSOR c_delimiter IS

Line 668: l_product_category zx_lines_det_factors.product_category%type;

664: x_return_status OUT NOCOPY VARCHAR2) is
665:
666: l_organization_id hr_organization_units.organization_id%type;
667: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
668: l_product_category zx_lines_det_factors.product_category%type;
669: l_trx_business_category zx_lines_det_factors.trx_business_category%type;
670:
671: CURSOR c_delimiter IS
672: SELECT delimiter

Line 669: l_trx_business_category zx_lines_det_factors.trx_business_category%type;

665:
666: l_organization_id hr_organization_units.organization_id%type;
667: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
668: l_product_category zx_lines_det_factors.product_category%type;
669: l_trx_business_category zx_lines_det_factors.trx_business_category%type;
670:
671: CURSOR c_delimiter IS
672: SELECT delimiter
673: FROM zx_fc_types_b