APPS.JAI_OPEN_API_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 2109: FROM jai_rgm_registrations jrr

2105: 'ADDL. EXCISE', 'OCTRAI', --'INSURANCE',--Commented by zhiwei for Bug#12584781 at 20110607
2106: 'TURNOVER TAX','OTHER EXCISE','VAT', 'VAT_REVERSAL')
2107: OR upper(tax_type) IN
2108: (SELECT jrr.attribute_code
2109: FROM jai_rgm_registrations jrr
2110: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2111: AND jrr.regime_id IN
2112: (SELECT jrd.regime_id
2113: FROM jai_rgm_definitions jrd

Line 2133: FROM jai_rgm_registrations jrr

2129: AND
2130: (--Added by zhiwei for Bug#12561573
2131: upper(tax_type) IN
2132: (SELECT jrr.attribute_code
2133: FROM jai_rgm_registrations jrr
2134: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2135: AND jrr.regime_id IN
2136: (SELECT jrd.regime_id
2137: FROM jai_rgm_definitions jrd

Line 2717: FROM jai_rgm_registrations jrr

2713: AND jila.interface_line_id = jitla.interface_line_id
2714: AND jila.internal_trx_id = cn_trx_id
2715: AND upper(jcta.tax_type) IN
2716: (SELECT jrr.attribute_code
2717: FROM jai_rgm_registrations jrr
2718: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2719: AND jrr.regime_id = (SELECT jrd.regime_id
2720: FROM jai_rgm_definitions jrd
2721: WHERE jrd.regime_code = jai_constants.vat_regime)));

Line 2834: FROM jai_rgm_registrations jrr

2830: AND jila.interface_line_id = jitla.interface_line_id
2831: AND jila.internal_trx_id = cn_trx_id
2832: AND upper(jcta.tax_type) IN
2833: (SELECT upper(jrr.attribute_code)
2834: FROM jai_rgm_registrations jrr
2835: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
2836: AND jrr.regime_id = (SELECT jrd.regime_id
2837: FROM jai_rgm_definitions jrd
2838: WHERE jrd.regime_code = jai_constants.service_regime)));

Line 4475: FROM jai_rgm_registrations jrr

4471: and (
4472: upper(tax_type) in
4473: (
4474: SELECT jrr.attribute_code
4475: FROM jai_rgm_registrations jrr
4476: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
4477: AND jrr.regime_id IN
4478: (
4479: SELECT jrd.regime_id

Line 4513: FROM jai_rgm_registrations jrr

4509: and (
4510: upper(tax_type) in
4511: (
4512: SELECT jrr.attribute_code
4513: FROM jai_rgm_registrations jrr
4514: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
4515: AND jrr.regime_id IN
4516: (
4517: SELECT jrd.regime_id

Line 5663: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

5659: FROM jai_regime_tax_types_v jrttv
5660: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
5661:
5662: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
5663: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5664:
5665: -- Start of bug 4089440
5666: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5667: lv_error_flag VARCHAR2(2);

Line 8064: FROM jai_rgm_registrations jrr

8060: ----------------------------------------------
8061: --Added by zhiwei for bug#12564566 end
8062: AND upper(jcta.tax_type) IN
8063: (SELECT jrr.attribute_code
8064: FROM jai_rgm_registrations jrr
8065: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8066: AND jrr.regime_id = (SELECT jrd.regime_id
8067: FROM jai_rgm_definitions jrd
8068: WHERE jrd.regime_code = jai_constants.vat_regime)));

Line 8148: FROM jai_rgm_registrations jrr

8144: where internal_trx_id = ln_customer_trx_id
8145: )
8146: AND upper(jcta.tax_type) IN
8147: (SELECT upper(jrr.attribute_code)
8148: FROM jai_rgm_registrations jrr
8149: WHERE jrr.registration_type = jai_constants.regn_type_tax_types
8150: AND jrr.regime_id = (SELECT jrd.regime_id
8151: FROM jai_rgm_definitions jrd
8152: WHERE jrd.regime_code = jai_constants.service_regime)));