APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_RGM_DEFINITIONS

Line 1488: FROM jai_rgm_definitions

1484: FROM jai_rgm_registrations
1485: WHERE registration_type = jai_constants.regn_type_tax_types
1486: AND attribute_code = pv_tax_type
1487: AND regime_id IN ( SELECT regime_id
1488: FROM jai_rgm_definitions
1489: WHERE regime_code = jai_constants.service_regime
1490: )
1491: );
1492:

Line 1677: pv_regime_code IN jai_rgm_definitions.regime_code%TYPE

1673:
1674:
1675: CURSOR jai_regimes_cur
1676: (
1677: pv_regime_code IN jai_rgm_definitions.regime_code%TYPE
1678: )
1679: IS
1680: SELECT
1681: regime_id

Line 1683: jai_rgm_definitions

1679: IS
1680: SELECT
1681: regime_id
1682: FROM
1683: jai_rgm_definitions
1684: WHERE regime_code = pv_regime_code;
1685:
1686: CURSOR regime_tax_type_cur
1687: ( pn_regime_id NUMBER

Line 1731: ln_regime_id jai_rgm_definitions.regime_id%TYPE;

1727:
1728: service_regimes_rec jai_regimes_cur%ROWTYPE;
1729: vat_regimes_rec jai_regimes_cur%ROWTYPE;
1730: ln_dist_acct_ccid NUMBER;
1731: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
1732: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1733: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
1734:
1735: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

Line 1732: lv_regime_code jai_rgm_definitions.regime_code%TYPE;

1728: service_regimes_rec jai_regimes_cur%ROWTYPE;
1729: vat_regimes_rec jai_regimes_cur%ROWTYPE;
1730: ln_dist_acct_ccid NUMBER;
1731: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
1732: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1733: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
1734:
1735: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1736: ln_proc_level NUMBER := FND_LOG.level_procedure;

Line 4925: FROM jai_rgm_definitions

4921: );
4922:
4923: CURSOR get_regime_id_cur IS
4924: SELECT regime_id
4925: FROM jai_rgm_definitions
4926: WHERE regime_code = jai_constants.service_regime;
4927:
4928: ln_regime_id number;
4929: ld_accrual_date DATE;