APPS.ZX_JA_EXTRACT_PKG dependencies on ZX_STATUS_B
Line 2050: FROM ZX_STATUS_TL stl, zx_status_b sb
2046: ELSIF P_LOOKUP_TYPE = 'JATW_GOVERNMENT_TAX_TYPE' then
2047: BEGIN
2048: SELECT TAX_STATUS_NAME
2049: INTO x_lookup_meaning 2050: FROM ZX_STATUS_TL stl, zx_status_b sb 2051: WHERE sb.tax_status_code = P_LOOKUP_CODE
2052: AND sb.tax_status_id = stl.tax_status_id
2053: AND LANGUAGE = userenv('LANG')
2054: and p_trx_date >= effective_from and p_trx_date <= nvl(effective_to, p_trx_date);