APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_ID_TCC_MAPPING_ALL

Line 9127: INSERT INTO zx_id_tcc_mapping_all

9123: );
9124:
9125: END LOOP;
9126:
9127: INSERT INTO zx_id_tcc_mapping_all
9128: (
9129: TCC_MAPPING_ID ,
9130: ORG_ID ,
9131: TAX_CLASS ,

Line 9152: ZX_ID_TCC_MAPPING_ALL_S.NEXTVAL,

9148: LEDGER_ID ,
9149: ACTIVE_FLAG
9150: )
9151: SELECT
9152: ZX_ID_TCC_MAPPING_ALL_S.NEXTVAL,
9153: decode(l_multi_org_flag,'N',l_org_id,codes.org_id),
9154: DECODE(codes.tax_class, 'I', 'INPUT',
9155: 'OUTPUT'),
9156: codes.vat_tax_id,

Line 9178: FROM zx_id_tcc_mapping_all zitm

9174: ar_vat_tax_all_b codes
9175: WHERE
9176: NOT EXISTS
9177: (SELECT 1
9178: FROM zx_id_tcc_mapping_all zitm
9179: WHERE zitm.tax_rate_code_id = codes.vat_tax_id
9180: AND zitm.source = 'AR'
9181: );
9182: EXCEPTION