APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_RGM_DEFINITIONS

Line 385: ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE;

381: FROM JAI_AR_TRXS h
382: WHERE h.customer_trx_id = pn_customer_trx_id;
383:
384: lv_st_inv_number jai_ar_trxs.st_inv_number%TYPE;
385: ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE;
386: lv_regime_code jai_rgm_definitions.REGIME_CODE%TYPE;
387: ln_organization_id NUMBER;
388: ln_location_id NUMBER;
389: ln_batch_source_id NUMBER;

Line 386: lv_regime_code jai_rgm_definitions.REGIME_CODE%TYPE;

382: WHERE h.customer_trx_id = pn_customer_trx_id;
383:
384: lv_st_inv_number jai_ar_trxs.st_inv_number%TYPE;
385: ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE;
386: lv_regime_code jai_rgm_definitions.REGIME_CODE%TYPE;
387: ln_organization_id NUMBER;
388: ln_location_id NUMBER;
389: ln_batch_source_id NUMBER;
390: ln_ship_to_customer_id NUMBER;

Line 4514: jai_rgm_definitions rgm_def

4510: TO_NUMBER(acc_rgm.attribute_value)
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

Line 4815: ln_regime_code jai_rgm_definitions.regime_code%TYPE; /*Bug 11821537 - Added Regime Code*/

4811: where regime_code in (jai_constants.service_regime,jai_constants.vat_regime)
4812: and tax_type=cp_tax_type;
4813:
4814: ln_regime_id number;
4815: ln_regime_code jai_rgm_definitions.regime_code%TYPE; /*Bug 11821537 - Added Regime Code*/
4816: --end additions for bug#11652823
4817: ------------------------------------------------------------------
4818: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 End
4819:

Line 5017: jai_rgm_definitions rgm_def

5013: TO_NUMBER(acc_rgm.attribute_value)
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