481: WHERE c.party_tax_profile_id = X_CONTENT_OWNER_ID;
482:
483: BEGIN
484: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
485: FROM ZX_TAXES_B A
486: WHERE A.TAX = X_TAX
487: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
488: AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
489:
489:
490: EXCEPTION
491: WHEN NO_DATA_FOUND THEN
492: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
493: FROM ZX_TAXES_B A
494: WHERE A.TAX = X_TAX
495: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
496: AND A.CONTENT_OWNER_ID = -99;
497: END;
983: WHERE c.party_tax_profile_id = X_CONTENT_OWNER_ID;
984:
985: BEGIN
986: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
987: FROM ZX_TAXES_B A
988: WHERE A.TAX = X_TAX
989: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
990: AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
991: EXCEPTION
990: AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
994: FROM ZX_TAXES_B A
995: WHERE A.TAX = X_TAX
996: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
997: AND A.CONTENT_OWNER_ID = -99;
998: END;
1172: );
1173: ELSE
1174: CLOSE cur_fnd_lookup_values;
1175: IF LENGTHB(X_TAX_RATE_CODE) > 30 THEN
1176: l_lookup_code := SUBSTRB(X_TAX_RATE_CODE, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S');
1177: l_tag := x_tax_rate_code;
1178: ELSE
1179: l_lookup_code := x_tax_rate_code;
1180: l_tag := NULL;