DBA Data[Home] [Help]

APPS.JA_JAINST3_XMLP_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 159: JAI_RGM_ORG_REGNS_V

155: SELECT
156: DISTINCT
157: ORGANIZATION_ID
158: FROM
159: JAI_RGM_ORG_REGNS_V
160: WHERE REGIME_CODE = 'SERVICE'
161: AND REGISTRATION_TYPE = 'OTHERS'
162: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
163: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 210: JAI_RGM_ORG_REGNS_V

206: SELECT
207: DISTINCT
208: ORGANIZATION_ID
209: FROM
210: JAI_RGM_ORG_REGNS_V
211: WHERE REGIME_CODE = 'SERVICE'
212: AND REGISTRATION_TYPE = 'OTHERS'
213: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
214: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 447: JAI_RGM_ORG_REGNS_V

443: SELECT
444: DISTINCT
445: ORGANIZATION_ID
446: FROM
447: JAI_RGM_ORG_REGNS_V
448: WHERE REGIME_CODE = 'SERVICE'
449: AND REGISTRATION_TYPE = 'OTHERS'
450: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
451: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 679: JAI_RGM_ORG_REGNS_V

675: SELECT
676: DISTINCT
677: ORGANIZATION_ID
678: FROM
679: JAI_RGM_ORG_REGNS_V
680: WHERE REGIME_CODE = 'SERVICE'
681: AND REGISTRATION_TYPE = 'OTHERS'
682: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
683: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 730: JAI_RGM_ORG_REGNS_V

726: SELECT
727: DISTINCT
728: ORGANIZATION_ID
729: FROM
730: JAI_RGM_ORG_REGNS_V
731: WHERE REGIME_CODE = 'SERVICE'
732: AND REGISTRATION_TYPE = 'OTHERS'
733: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
734: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'