DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 4515: , jai_rgm_registrations tax_rgm

4511: INTO
4512: ln_tax_rgm_acc_id
4513: FROM
4514: jai_rgm_definitions rgm_def
4515: , jai_rgm_registrations tax_rgm
4516: , jai_rgm_registrations acc_rgm
4517: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
4518: AND tax_rgm.regime_id = rgm_def.regime_id
4519: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types

Line 4516: , jai_rgm_registrations acc_rgm

4512: ln_tax_rgm_acc_id
4513: FROM
4514: jai_rgm_definitions rgm_def
4515: , jai_rgm_registrations tax_rgm
4516: , jai_rgm_registrations acc_rgm
4517: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
4518: AND tax_rgm.regime_id = rgm_def.regime_id
4519: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
4520: AND tax_rgm.attribute_code = pv_tax_type

Line 4828: FROM jai_rgm_registrations

4824: /*
4825: CURSOR c_get_st_accrual_date (p_regime_id NUMBER)
4826: IS
4827: SELECT to_date(attribute_value, 'DD/MM/YYYY')
4828: FROM jai_rgm_registrations
4829: WHERE regime_id = p_regime_id
4830: AND attribute_code = 'EFF_DATE_ST_PT'
4831: AND attribute_type_code = 'OTHERS'
4832: AND registration_type = 'OTHERS';

Line 5018: , jai_rgm_registrations tax_rgm

5014: INTO
5015: ln_tax_account_id
5016: FROM
5017: jai_rgm_definitions rgm_def
5018: , jai_rgm_registrations tax_rgm
5019: , jai_rgm_registrations acc_rgm
5020: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
5021: AND tax_rgm.regime_id = rgm_def.regime_id
5022: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types

Line 5019: , jai_rgm_registrations acc_rgm

5015: ln_tax_account_id
5016: FROM
5017: jai_rgm_definitions rgm_def
5018: , jai_rgm_registrations tax_rgm
5019: , jai_rgm_registrations acc_rgm
5020: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
5021: AND tax_rgm.regime_id = rgm_def.regime_id
5022: AND tax_rgm.registration_type = jai_constants.regn_type_tax_types
5023: AND tax_rgm.attribute_code = inclu_tax_csr.tax_type