[Home] [Help]
APPS.ZX_SRVC_TYP_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V
Line 16876: FROM ZX_OUTPUT_CLASSIFICATIONS_V
16872: c_trx_date ZX_LINES_DET_FACTORS.trx_date%TYPE,
16873: c_internal_organization_id ZX_LINES.internal_organization_id%TYPE)
16874: IS
16875: SELECT COUNT(1)
16876: FROM ZX_OUTPUT_CLASSIFICATIONS_V
16877: WHERE lookup_code = c_output_tcc
16878: AND enabled_flag = 'Y'
16879: AND c_trx_date >= start_date_active
16880: AND (c_trx_date <= end_date_active