eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on JAI_RGM_REGISTRATIONS

Line 735: jai_rgm_registrations

731: IS
732: SELECT
733: attribute_code tax_type
734: FROM
735: jai_rgm_registrations
736: WHERE regime_id = pn_regime_id
737: AND registration_type =jai_constants.regn_type_tax_types --tax type
738: AND attribute_code = pv_tax_type_code;
739:

Line 748: jai_rgm_registrations tax_types

744: IS
745: SELECT
746: TO_NUMBER (accnts.attribute_value)
747: FROM
748: jai_rgm_registrations tax_types
749: , jai_rgm_registrations accnts
750: WHERE tax_types.regime_id = pn_regime_id
751: AND tax_types.registration_type = jai_constants.regn_type_tax_types
752: AND tax_types.attribute_code = pn_tax_type

Line 749: , jai_rgm_registrations accnts

745: SELECT
746: TO_NUMBER (accnts.attribute_value)
747: FROM
748: jai_rgm_registrations tax_types
749: , jai_rgm_registrations accnts
750: WHERE tax_types.regime_id = pn_regime_id
751: AND tax_types.registration_type = jai_constants.regn_type_tax_types
752: AND tax_types.attribute_code = pn_tax_type
753: AND accnts.regime_id = tax_types.regime_id

Line 772: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;

768: vat_regimes_rec jai_regimes_cur%ROWTYPE;
769: ln_dist_acct_ccid NUMBER;
770: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
771: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
772: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
773:
774: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
775: ln_proc_level NUMBER := FND_LOG.level_procedure;
776: lv_proc_name VARCHAR2 (100) := 'Get_ST_Reverse_Ccid';

Line 3681: from JAI_RGM_REGISTRATIONS

3677: where regime_code = cp_regime_code ; /* SERVICE or VAT */
3678:
3679: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
3680: select attribute_code tax_type
3681: from JAI_RGM_REGISTRATIONS
3682: where regime_id = cp_regime_id
3683: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
3684: and attribute_code = cp_tax_type;
3685:

Line 5743: from JAI_RGM_REGISTRATIONS

5739: where regime_code = cp_regime_code ; /* SERVICE or VAT */
5740:
5741: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
5742: select attribute_code tax_type
5743: from JAI_RGM_REGISTRATIONS
5744: where regime_id = cp_regime_id
5745: and registration_type = jai_constants.regn_type_tax_types /* TAX_TYPES */
5746: and attribute_code = cp_tax_type;
5747: