APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on JAI_RGM_DEFINITIONS

Line 718: pv_regime_code IN jai_rgm_definitions.regime_code%TYPE

714:
715:
716: CURSOR jai_regimes_cur
717: (
718: pv_regime_code IN jai_rgm_definitions.regime_code%TYPE
719: )
720: IS
721: SELECT
722: regime_id

Line 724: jai_rgm_definitions

720: IS
721: SELECT
722: regime_id
723: FROM
724: jai_rgm_definitions
725: WHERE regime_code = pv_regime_code;
726:
727: CURSOR regime_tax_type_cur
728: ( pn_regime_id NUMBER

Line 770: ln_regime_id jai_rgm_definitions.regime_id%TYPE;

766:
767: service_regimes_rec jai_regimes_cur%ROWTYPE;
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;

Line 771: lv_regime_code jai_rgm_definitions.regime_code%TYPE;

767: service_regimes_rec jai_regimes_cur%ROWTYPE;
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;

Line 3673: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)

3669: * hardcoding the value for service. This is required
3670: * for re-using the same cursor to avoid performance issue
3671: * in using jai_regime_tax_types_v.
3672: */
3673: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
3674: IS
3675: select regime_id
3676: from JAI_RGM_DEFINITIONS
3677: where regime_code = cp_regime_code ; /* SERVICE or VAT */

Line 3676: from JAI_RGM_DEFINITIONS

3672: */
3673: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
3674: IS
3675: select regime_id
3676: from JAI_RGM_DEFINITIONS
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

Line 5735: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)

5731: * hardcoding the value for service. This is required
5732: * for re-using the same cursor to avoid performance issue
5733: * in using jai_regime_tax_types_v.
5734: */
5735: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
5736: IS
5737: select regime_id
5738: from JAI_RGM_DEFINITIONS
5739: where regime_code = cp_regime_code ; /* SERVICE or VAT */

Line 5738: from JAI_RGM_DEFINITIONS

5734: */
5735: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
5736: IS
5737: select regime_id
5738: from JAI_RGM_DEFINITIONS
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