APPS.ZX_PTP_IMPORT dependencies on ZX_REGIMES_V

Line 3426: FROM zx_regimes_v

3422: WHERE (( tax_regime_code IS NOT NULL
3423: AND NOT EXISTS
3424: (
3425: SELECT 1
3426: FROM zx_regimes_v
3427: WHERE has_sub_regime_flag <> 'Y'
3428: AND tax_regime_code = reg_int.tax_regime_code
3429: )
3430: )

Line 3437: FROM zx_regimes_v

3433: AND tax_regime_name IS NOT NULL
3434: AND NOT EXISTS
3435: (
3436: SELECT 1
3437: FROM zx_regimes_v
3438: WHERE has_sub_regime_flag <> 'Y'
3439: AND tax_regime_name = reg_int.tax_regime_name
3440: )
3441: )

Line 3455: FROM zx_regimes_v

3451: -- value to id conversion for tax_regime_code
3452: UPDATE zx_registrations_int reg_int
3453: SET tax_regime_code = (
3454: SELECT tax_regime_name
3455: FROM zx_regimes_v
3456: WHERE has_sub_regime_flag <> 'Y'
3457: AND tax_regime_name = reg_int.tax_regime_name
3458: AND rownum=1
3459: )

Line 4367: FROM zx_regimes_v

4363: ( tax_regime_code IS NOT NULL
4364: AND NOT EXISTS
4365: (
4366: SELECT tax_regime_code
4367: FROM zx_regimes_v
4368: WHERE has_sub_regime_flag <> 'Y'
4369: AND tax_regime_code = exe_int.tax_regime_code
4370: )
4371: )

Line 4378: FROM zx_regimes_v

4374: AND tax_regime_name IS NOT NULL
4375: AND NOT EXISTS
4376: (
4377: SELECT 1
4378: FROM zx_regimes_v
4379: WHERE has_sub_regime_flag <> 'Y'
4380: AND tax_regime_name = exe_int.tax_regime_name
4381: )
4382: )

Line 4396: FROM zx_regimes_v

4392: -- value to id conversion for tax_regime_code
4393: UPDATE zx_exemptions_int exe_int
4394: SET tax_regime_code = (
4395: SELECT tax_regime_code
4396: FROM zx_regimes_v
4397: WHERE has_sub_regime_flag <> 'Y'
4398: AND tax_regime_name = exe_int.tax_regime_name
4399: )
4400: WHERE record_status = G_RS_IN_PROCESS