DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_LINES

Line 687: FROM ZX_LINES_DET_FACTORS D

683: (SELECT D.product_fisc_classification,
684: D.trx_business_category,
685: D.product_category,
686: D.output_tax_classification_code
687: FROM ZX_LINES_DET_FACTORS D
688: WHERE D.event_class_code = L.source_event_class_code
689: AND D.application_id = L.source_application_id
690: AND D.entity_code = L.source_entity_code
691: AND D.trx_id = L.source_trx_id

Line 862: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

858: PROCEDURE default_tax_attr (p_trx_line_index IN NUMBER,
859: x_return_status OUT NOCOPY VARCHAR2) is
860:
861: l_organization_id hr_organization_units.organization_id%type;
862: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
863: l_product_category zx_lines_det_factors.product_category%type;
864: l_trx_business_category zx_lines_det_factors.trx_business_category%type;
865:
866: CURSOR c_delimiter IS

Line 863: l_product_category zx_lines_det_factors.product_category%type;

859: x_return_status OUT NOCOPY VARCHAR2) is
860:
861: l_organization_id hr_organization_units.organization_id%type;
862: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
863: l_product_category zx_lines_det_factors.product_category%type;
864: l_trx_business_category zx_lines_det_factors.trx_business_category%type;
865:
866: CURSOR c_delimiter IS
867: SELECT delimiter

Line 864: l_trx_business_category zx_lines_det_factors.trx_business_category%type;

860:
861: l_organization_id hr_organization_units.organization_id%type;
862: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
863: l_product_category zx_lines_det_factors.product_category%type;
864: l_trx_business_category zx_lines_det_factors.trx_business_category%type;
865:
866: CURSOR c_delimiter IS
867: SELECT delimiter
868: FROM zx_fc_types_b

Line 2641: FROM zx_lines zl

2637: CASE
2638: WHEN lines_gt.adjusted_doc_application_id IS NOT NULL
2639: AND NOT EXISTS
2640: (SELECT 1
2641: FROM zx_lines zl
2642: WHERE zl.application_id = lines_gt.adjusted_doc_application_id
2643: AND zl.entity_code = lines_gt.adjusted_doc_entity_code
2644: AND zl.event_class_code = lines_gt.adjusted_doc_event_class_code
2645: AND zl.trx_id = lines_gt.adjusted_doc_trx_id