DBA Data[Home] [Help]

APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 399: JAI_RGM_ORG_REGNS_V

395: SELECT
396: DISTINCT
397: ORGANIZATION_ID
398: FROM
399: JAI_RGM_ORG_REGNS_V
400: WHERE REGIME_CODE = 'SERVICE'
401: AND REGISTRATION_TYPE = 'OTHERS'
402: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
403: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 472: JAI_RGM_ORG_REGNS_V

468: SELECT
469: DISTINCT
470: ORGANIZATION_ID
471: FROM
472: JAI_RGM_ORG_REGNS_V
473: WHERE REGIME_CODE = 'SERVICE'
474: AND REGISTRATION_TYPE = 'OTHERS'
475: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
476: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 552: JAI_RGM_ORG_REGNS_V

548: SELECT
549: DISTINCT
550: ORGANIZATION_ID
551: FROM
552: JAI_RGM_ORG_REGNS_V
553: WHERE REGIME_CODE = 'SERVICE'
554: AND REGISTRATION_TYPE = 'OTHERS'
555: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
556: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 660: JAI_RGM_ORG_REGNS_V

656: SELECT
657: DISTINCT
658: ORGANIZATION_ID
659: FROM
660: JAI_RGM_ORG_REGNS_V
661: WHERE REGIME_CODE = 'SERVICE'
662: AND REGISTRATION_TYPE = 'OTHERS'
663: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
664: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 912: JAI_RGM_ORG_REGNS_V

908: SELECT
909: DISTINCT
910: ORGANIZATION_ID
911: FROM
912: JAI_RGM_ORG_REGNS_V
913: WHERE REGIME_CODE = 'SERVICE'
914: AND REGISTRATION_TYPE = 'OTHERS'
915: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
916: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 962: JAI_RGM_ORG_REGNS_V

958: SELECT
959: DISTINCT
960: ORGANIZATION_ID
961: FROM
962: JAI_RGM_ORG_REGNS_V
963: WHERE REGIME_CODE = 'SERVICE'
964: AND REGISTRATION_TYPE = 'OTHERS'
965: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
966: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 1078: JAI_RGM_ORG_REGNS_V

1074: SELECT
1075: DISTINCT
1076: ORGANIZATION_ID
1077: FROM
1078: JAI_RGM_ORG_REGNS_V
1079: WHERE REGIME_CODE = 'SERVICE'
1080: AND REGISTRATION_TYPE = 'OTHERS'
1081: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
1082: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 1128: JAI_RGM_ORG_REGNS_V

1124: SELECT
1125: DISTINCT
1126: ORGANIZATION_ID
1127: FROM
1128: JAI_RGM_ORG_REGNS_V
1129: WHERE REGIME_CODE = 'SERVICE'
1130: AND REGISTRATION_TYPE = 'OTHERS'
1131: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
1132: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 2927: JAI_RGM_ORG_REGNS_V

2923: SELECT
2924: DISTINCT
2925: ORGANIZATION_ID
2926: FROM
2927: JAI_RGM_ORG_REGNS_V
2928: WHERE REGIME_CODE = 'SERVICE'
2929: AND REGISTRATION_TYPE = 'OTHERS'
2930: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
2931: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 2977: JAI_RGM_ORG_REGNS_V

2973: SELECT
2974: DISTINCT
2975: ORGANIZATION_ID
2976: FROM
2977: JAI_RGM_ORG_REGNS_V
2978: WHERE REGIME_CODE = 'SERVICE'
2979: AND REGISTRATION_TYPE = 'OTHERS'
2980: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
2981: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'

Line 3197: JAI_RGM_ORG_REGNS_V

3193: SELECT
3194: DISTINCT
3195: ORGANIZATION_ID
3196: FROM
3197: JAI_RGM_ORG_REGNS_V
3198: WHERE REGIME_CODE = 'SERVICE'
3199: AND REGISTRATION_TYPE = 'OTHERS'
3200: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
3201: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'