APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_ID_TCC_MAPPING_ALL

Line 896: INSERT INTO ZX_ID_TCC_MAPPING_ALL

892: END;
893:
894:
895: --Bug 4096752
896: INSERT INTO ZX_ID_TCC_MAPPING_ALL
897: (
898: TCC_MAPPING_ID ,
899: ORG_ID ,
900: TAX_CLASS ,

Line 922: ZX_ID_TCC_MAPPING_ALL_S.nextval , --tcc_mapping_id

918: ACTIVE_FLAG
919: )
920:
921: SELECT
922: ZX_ID_TCC_MAPPING_ALL_S.nextval , --tcc_mapping_id
923: decode(l_multi_org_flag,'N',l_org_id,ORG_ID) , --org_id
924: 'INPUT' , --tax_class
925: TAX_ID , --tax_id
926: NAME , --tax_classification_code

Line 948: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL

944: WHERE
945: codes.TAX_TYPE <> 'AWT'
946: AND codes.TAX_ID = nvl(p_tax_id,codes.TAX_ID)
947: AND NOT EXISTS
948: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL
949: WHERE TAX_RATE_CODE_ID = codes.TAX_ID
950: AND SOURCE = 'AP'
951: );
952: