DBA Data[Home] [Help]

APPS.ZX_RATES_PKG dependencies on ZX_TAXES_B

Line 485: FROM ZX_TAXES_B A

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:

Line 493: FROM ZX_TAXES_B A

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;

Line 987: FROM ZX_TAXES_B A

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

Line 994: FROM ZX_TAXES_B A

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;

Line 1176: l_lookup_code := SUBSTRB(X_TAX_RATE_CODE, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S');

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;