DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_SUBSCRIPTION_DETAILS

Line 2151: ZX_SUBSCRIPTION_DETAILS sd_reg,

2147: ZX_TAXES_B tax,
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:
2155: WHERE

Line 2152: ZX_SUBSCRIPTION_DETAILS sd_tax,

2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:
2155: WHERE
2156: lines_gt.trx_id = header.trx_id

Line 2153: ZX_SUBSCRIPTION_DETAILS sd_status

2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status
2154:
2155: WHERE
2156: lines_gt.trx_id = header.trx_id
2157: AND taxlines_gt.trx_id = header.trx_id

Line 2452: ZX_SUBSCRIPTION_DETAILS sd_rates

2448: FROM ZX_TRX_HEADERS_GT header,
2449: ZX_RATES_B rate ,
2450: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2451: ZX_TRANSACTION_LINES_GT lines_gt,
2452: ZX_SUBSCRIPTION_DETAILS sd_rates
2453: WHERE taxlines_gt.trx_id = header.trx_id
2454: AND taxlines_gt.application_id = Header.application_id
2455: AND taxlines_gt.entity_code = Header.entity_code
2456: AND taxlines_gt.event_class_code = Header.event_class_code