DBA Data[Home] [Help]

APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_ID_TCC_MAPPING_ALL

Line 9115: INSERT INTO zx_id_tcc_mapping_all

9111: );
9112:
9113: END LOOP;
9114:
9115: INSERT INTO zx_id_tcc_mapping_all
9116: (
9117: TCC_MAPPING_ID ,
9118: ORG_ID ,
9119: TAX_CLASS ,

Line 9140: ZX_ID_TCC_MAPPING_ALL_S.NEXTVAL,

9136: LEDGER_ID ,
9137: ACTIVE_FLAG
9138: )
9139: SELECT
9140: ZX_ID_TCC_MAPPING_ALL_S.NEXTVAL,
9141: decode(l_multi_org_flag,'N',l_org_id,codes.org_id),
9142: DECODE(codes.tax_class, 'I', 'INPUT',
9143: 'OUTPUT'),
9144: codes.vat_tax_id,

Line 9166: FROM zx_id_tcc_mapping_all zitm

9162: ar_vat_tax_all_b codes
9163: WHERE
9164: NOT EXISTS
9165: (SELECT 1
9166: FROM zx_id_tcc_mapping_all zitm
9167: WHERE zitm.tax_rate_code_id = codes.vat_tax_id
9168: AND zitm.source = 'AR'
9169: );
9170: EXCEPTION