DBA Data[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on ZX_STATUS_B

Line 2123: FROM ZX_STATUS_TL stl, zx_status_b sb

2119: ELSIF P_LOOKUP_TYPE = 'JATW_GOVERNMENT_TAX_TYPE' then
2120: BEGIN
2121: SELECT TAX_STATUS_NAME
2122: INTO x_lookup_meaning
2123: FROM ZX_STATUS_TL stl, zx_status_b sb
2124: WHERE sb.tax_status_code = P_LOOKUP_CODE
2125: AND sb.tax_status_id = stl.tax_status_id
2126: AND LANGUAGE = userenv('LANG')
2127: and p_trx_date >= effective_from and p_trx_date <= nvl(effective_to, p_trx_date);