DBA Data[Home] [Help]

APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_ERRORS_GT

Line 428: FROM ZX_ERRORS_GT err

424: AND (trxlines.trx_level_type = p_trx_level_type OR
425: p_trx_level_type IS NULL)
426: AND NOT EXISTS(
427: SELECT 1
428: FROM ZX_ERRORS_GT err
429: WHERE err.application_id = header.application_id
430: AND err.entity_code = header.entity_code
431: AND err.event_class_code = header.event_class_code
432: AND err.trx_id = header.trx_id)

Line 796: FROM zx_errors_gt err_gt

792: AND TRX_ID = p_trx_line_dist_tbl.TRX_ID(i)
793: AND TRX_LINE_ID = p_trx_line_dist_tbl.TRX_LINE_ID(i)
794: AND TRX_LEVEL_TYPE = p_trx_line_dist_tbl.TRX_LEVEL_TYPE(i)
795: AND NOT EXISTS (SELECT 'Y'
796: FROM zx_errors_gt err_gt
797: WHERE err_gt.application_id = p_trx_line_dist_tbl.application_id(i)
798: AND err_gt.entity_code = p_trx_line_dist_tbl.entity_code(i)
799: AND err_gt.event_class_code = p_trx_line_dist_tbl.event_class_code(i)
800: AND err_gt.trx_id = p_trx_line_dist_tbl.trx_id(i));