APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_ID_TCC_MAPPING_ALL

Line 877: INSERT INTO ZX_ID_TCC_MAPPING_ALL

873: END;
874:
875:
876: --Bug 4096752
877: INSERT INTO ZX_ID_TCC_MAPPING_ALL
878: (
879: TCC_MAPPING_ID ,
880: ORG_ID ,
881: TAX_CLASS ,

Line 903: ZX_ID_TCC_MAPPING_ALL_S.nextval , --tcc_mapping_id

899: ACTIVE_FLAG
900: )
901:
902: SELECT
903: ZX_ID_TCC_MAPPING_ALL_S.nextval , --tcc_mapping_id
904: decode(l_multi_org_flag,'N',l_org_id,ORG_ID) , --org_id
905: 'INPUT' , --tax_class
906: TAX_ID , --tax_id
907: NAME , --tax_classification_code

Line 929: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL

925: WHERE
926: codes.TAX_TYPE <> 'AWT'
927: AND codes.TAX_ID = nvl(p_tax_id,codes.TAX_ID)
928: AND NOT EXISTS
929: (SELECT NULL FROM ZX_ID_TCC_MAPPING_ALL
930: WHERE TAX_RATE_CODE_ID = codes.TAX_ID
931: AND SOURCE = 'AP'
932: );
933: