DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_MCO_LV_TAXES_V

Line 3478: FROM zx_mco_lv_taxes_v

3474: WHERE (( tax_code IS NOT NULL
3475: AND NOT EXISTS
3476: (
3477: SELECT 1
3478: FROM zx_mco_lv_taxes_v
3479: WHERE tax_regime_code = reg_int.tax_regime_code
3480: AND tax = reg_int.tax_code
3481: )
3482: )

Line 3489: FROM zx_mco_lv_taxes_v

3485: AND tax_name IS NOT NULL
3486: AND NOT EXISTS
3487: (
3488: SELECT 1
3489: FROM zx_mco_lv_taxes_v
3490: WHERE tax_regime_code = reg_int.tax_regime_code
3491: AND tax_full_name = reg_int.tax_name
3492: )
3493: )

Line 3508: FROM zx_mco_lv_taxes_v

3504: -- value to id conversion for tax
3505: UPDATE zx_registrations_int reg_int
3506: SET tax_code = (
3507: SELECT tax
3508: FROM zx_mco_lv_taxes_v
3509: WHERE tax_regime_code = reg_int.tax_regime_code
3510: AND tax_full_name = reg_int.tax_name
3511: AND rownum=1
3512: )