APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on AR_VAT_TAX

Line 462: AR_VAT_TAX rates

458: TaxLines.summary_tax_line_number summary_tax_line_number
459: FROM
460: ZX_IMPORT_TAX_LINES_GT TaxLines,
461: ZX_TRX_HEADERS_GT Header,
462: AR_VAT_TAX rates
463: WHERE
464: TaxLines.tax_rate_code = rates.tax_code(+)
465: AND TaxLines.tax_rate_code IS NOT NULL
466: AND Header.trx_date between nvl(rates.start_date,Header.trx_date)

Line 497: AR_VAT_TAX rates

493: TaxLines.summary_tax_line_number summary_tax_line_number
494: FROM
495: ZX_IMPORT_TAX_LINES_GT TaxLines,
496: ZX_TRX_HEADERS_GT Header,
497: AR_VAT_TAX rates
498: WHERE
499: TaxLines.tax_rate_id = rates.vat_tax_id(+)
500: AND TaxLines.tax_rate_id IS NOT NULL
501: AND (TaxLines.tax_regime_code IS NULL OR TaxLines.tax IS NULL)

Line 537: AR_VAT_TAX Rates,

533: TaxLines.trx_id trx_id,
534: TaxLines.summary_tax_line_number summary_tax_line_number
535: FROM
536: ZX_IMPORT_TAX_LINES_GT TaxLines,
537: AR_VAT_TAX Rates,
538: ZX_TRX_HEADERS_GT Header
539: WHERE
540: Taxlines.tax_regime_Code = Rates.tax_regime_code(+)
541: AND Taxlines.tax = Rates.tax(+)

Line 579: AR_VAT_TAX Rates,

575: Rates.tax_rate,
576: TaxLines.trx_id,
577: TaxLines.summary_tax_line_number
578: FROM
579: AR_VAT_TAX Rates,
580: ZX_IMPORT_TAX_LINES_GT TaxLines,
581: ZX_TRX_HEADERS_GT Header
582: WHERE
583: Taxlines.tax_regime_Code = Rates.tax_regime_code(+)

Line 817: AR_VAT_TAX VT

813: USING (SELECT CTT.global_attribute4 output_tax_classification_code,
814: H.trx_id
815: FROM ZX_TRX_HEADERS_GT H,
816: RA_CUST_TRX_TYPES CTT,
817: AR_VAT_TAX VT
818: WHERE CTT.cust_trx_type_id = H.receivables_trx_type_id
819: AND CTT.org_id = VT.org_id
820: AND CTT.org_id = H.internal_organization_id
821: AND CTT.global_attribute4 = VT.tax_code