DBA Data[Home] [Help]

APPS.ZX_GL_EXTRACT_PKG dependencies on ZX_REGISTRATIONS

Line 2903: FROM zx_registrations reg

2899: l_return_status);
2900: Begin
2901: SELECT registration_number
2902: INTO GT_TAX_REG_NUM(i)
2903: FROM zx_registrations reg
2904: WHERE reg.party_tax_profile_id = l_ptp_id
2905: AND nvl(reg.tax_regime_code,1) = nvl(p_tax_regime_code,1)
2906: AND nvl(reg.tax,nvl(p_tax,1)) = nvl(p_tax,1)
2907: AND nvl(reg.tax_jurisdiction_code,nvl(p_tax_jurisdiction_code,1)) = nvl(p_tax_jurisdiction_code,1)