DBA Data[Home] [Help]

APPS.ZX_CHECK_REQUIRED_PARAMS_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 134: ZX_TRANSACTION_LINES_GT lines_gt

130: ELSE NULL
131: END ZX_UNIT_PRICE_MISSING
132: */
133: FROM ZX_TRX_HEADERS_GT header,
134: ZX_TRANSACTION_LINES_GT lines_gt
135: WHERE lines_gt.trx_id = header.trx_id
136: AND lines_gt.application_id = header.application_id
137: AND lines_gt.entity_code = header.entity_code
138: AND lines_gt.event_class_code = header.event_class_code;

Line 356: ( SELECT 1 FROM zx_transaction_lines_gt

352: END ZX_ROUND_PARTY_MISSING,
353: CASE WHEN (header.TRX_CURRENCY_CODE is NULL
354: AND header.precision is NULL )
355: AND EXISTS
356: ( SELECT 1 FROM zx_transaction_lines_gt
357: WHERE application_id = header.application_id
358: AND entity_code = header.entity_code
359: AND event_class_code = header.event_class_code
360: AND trx_id = header.trx_id