DBA Data[Home] [Help]

APPS.JA_JAINRGCR_XMLP_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 95: JAI_RGM_ORG_REGNS_V

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

Line 205: JAI_RGM_ORG_REGNS_V

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

Line 249: JAI_RGM_ORG_REGNS_V

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