DBA Data[Home] [Help]

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);