APPS.JAI_AP_MATCH_TAX_PKG dependencies on JAI_RGM_DEFINITIONS

Line 940: ln_vat_regime_id jai_rgm_definitions.regime_id%type;

936: v_tax_type VARCHAR2(50);
937: v_apportn_factor_for_item_line NUMBER; -- Bug#3752887
938:
939: /*following variables added for bug 6595773*/
940: ln_vat_regime_id jai_rgm_definitions.regime_id%type;
941: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
942: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
943:
944:

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

1000: * hardcoding the value for service. This is required
1001: * for re-using the same cursor to avoid performance issue
1002: * in using jai_regime_tax_types_v.
1003: */
1004: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
1005: IS
1006: select regime_id
1007: from JAI_RGM_DEFINITIONS
1008: where regime_code = cp_regime_code ; /* SERVICE or VAT */

Line 1007: from JAI_RGM_DEFINITIONS

1003: */
1004: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
1005: IS
1006: select regime_id
1007: from JAI_RGM_DEFINITIONS
1008: where regime_code = cp_regime_code ; /* SERVICE or VAT */
1009:
1010: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
1011: select attribute_code tax_type

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

6044: * hardcoding the value for service. This is required
6045: * for re-using the same cursor to avoid performance issue
6046: * in using jai_regime_tax_types_v.
6047: */
6048: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
6049: IS
6050: select regime_id
6051: from JAI_RGM_DEFINITIONS
6052: where regime_code = cp_regime_code ; /* SERVICE or VAT */

Line 6051: from JAI_RGM_DEFINITIONS

6047: */
6048: cursor c_jai_regimes(cp_regime_code IN JAI_RGM_DEFINITIONS.regime_code%TYPE)
6049: IS
6050: select regime_id
6051: from JAI_RGM_DEFINITIONS
6052: where regime_code = cp_regime_code ; /* SERVICE or VAT */
6053:
6054: cursor c_regime_tax_type(cp_regime_id number, cp_tax_type varchar2) is
6055: select attribute_code tax_type