APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_RGM_DEFINITIONS

Line 1237: ln_vat_regime_id jai_rgm_definitions.regime_id%type;

1233: v_apportn_factor_for_item_line NUMBER; -- Bug#3752887
1234: v_apportn_factor_for_adhoc NUMBER; --Added by nprashar for bug # 13363329
1235:
1236: /*following variables added for bug 6595773*/
1237: ln_vat_regime_id jai_rgm_definitions.regime_id%type;
1238: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
1239: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
1240:
1241:

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

1317: * hardcoding the value for service. This is required
1318: * for re-using the same cursor to avoid performance issue
1319: * in using jai_regime_tax_types_v.
1320: */
1321: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
1322: IS
1323: select regime_id
1324: from JAI_RGM_DEFINITIONS
1325: where regime_code = cp_regime_code ; /* SERVICE or VAT */

Line 1324: from JAI_RGM_DEFINITIONS

1320: */
1321: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
1322: IS
1323: select regime_id
1324: from JAI_RGM_DEFINITIONS
1325: where regime_code = cp_regime_code ; /* SERVICE or VAT */
1326:
1327: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
1328: select attribute_code tax_type

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

7595: * hardcoding the value for service. This is required
7596: * for re-using the same cursor to avoid performance issue
7597: * in using jai_regime_tax_types_v.
7598: */
7599: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
7600: IS
7601: select regime_id
7602: from JAI_RGM_DEFINITIONS
7603: where regime_code = cp_regime_code ; /* SERVICE or VAT */

Line 7602: from JAI_RGM_DEFINITIONS

7598: */
7599: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
7600: IS
7601: select regime_id
7602: from JAI_RGM_DEFINITIONS
7603: where regime_code = cp_regime_code ; /* SERVICE or VAT */
7604:
7605: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
7606: select attribute_code tax_type