91: SELECT
92: DISTINCT
93: ORGANIZATION_ID
94: FROM
95: JAI_RGM_ORG_REGNS_V
96: WHERE REGIME_CODE = LV_SERVICE_REGIME
97: AND REGISTRATION_TYPE = LV_OTH_REG_TYPE
98: AND ATTRIBUTE_TYPE_CODE = LV_PRIM_ATT_TYPE_CODE
99: AND ATTRIBUTE_CODE = LV_SERVICE_ATT_CODE
201: SELECT
202: DISTINCT
203: ORGANIZATION_ID
204: FROM
205: JAI_RGM_ORG_REGNS_V
206: WHERE REGIME_CODE = LV_SERVICE_REGIME
207: AND REGISTRATION_TYPE = LV_OTH_REG_TYPE
208: AND ATTRIBUTE_TYPE_CODE = LV_PRIM_ATT_TYPE_CODE
209: AND ATTRIBUTE_CODE = LV_SERVICE_ATT_CODE
245: SELECT
246: DISTINCT
247: ORGANIZATION_ID
248: FROM
249: JAI_RGM_ORG_REGNS_V
250: WHERE REGIME_CODE = LV_SERVICE_REGIME
251: AND REGISTRATION_TYPE = LV_OTH_REG_TYPE
252: AND ATTRIBUTE_TYPE_CODE = LV_PRIM_ATT_TYPE_CODE
253: AND ATTRIBUTE_CODE = LV_SERVICE_ATT_CODE