DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_TRX_TAX_LINK_GT

Line 427: ZX_TRX_TAX_LINK_GT TaxLink

423: TaxLink.line_amt,
424: TaxLines.trx_id
425: FROM
426: ZX_IMPORT_TAX_LINES_GT TaxLines,
427: ZX_TRX_TAX_LINK_GT TaxLink
428: WHERE
429: Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y' AND
430: TaxLines.tax_amt is NULL AND
431: TaxLines.tax_rate is not NULL AND

Line 2130: FROM zx_trx_tax_link_gt

2126: AND imptaxes_gt1.tax = imptaxes_gt.tax
2127: AND (imptaxes_gt1.tax_line_allocation_flag = 'Y'
2128: AND EXISTS
2129: (SELECT 1
2130: FROM zx_trx_tax_link_gt
2131: WHERE application_id = imptaxes_gt1.application_id
2132: AND entity_code = imptaxes_gt1.entity_code
2133: AND event_class_code = imptaxes_gt1.event_class_code
2134: AND trx_id = imptaxes_gt1.trx_id

Line 2160: FROM zx_trx_tax_link_gt

2156: --
2157: CASE
2158: WHEN
2159: (SELECT COUNT(*)
2160: FROM zx_trx_tax_link_gt
2161: WHERE application_id = imptaxes_gt.application_id
2162: AND entity_code = imptaxes_gt.entity_code
2163: AND event_class_code = imptaxes_gt.event_class_code
2164: AND trx_id = imptaxes_gt.trx_id

Line 2234: FROM zx_trx_tax_link_gt

2230: AND lines_gt.trx_id = header.trx_id
2231: AND (imptaxes_gt.tax_line_allocation_flag = 'Y'
2232: AND EXISTS
2233: (SELECT 1
2234: FROM zx_trx_tax_link_gt
2235: WHERE application_id = imptaxes_gt.application_id
2236: AND entity_code = imptaxes_gt.entity_code
2237: AND event_class_code = imptaxes_gt.event_class_code
2238: AND trx_id = imptaxes_gt.trx_id