APPS.ZX_RATES_PKG dependencies on ZX_TAXES_B

Line 338: ZX_TAXES_B A

334:
335: BEGIN
336: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
337: FROM
338: ZX_TAXES_B A
339: WHERE
340: A.TAX = X_TAX
341: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
342: AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;

Line 350: ZX_TAXES_B A

346: WHEN NO_DATA_FOUND THEN
347:
348: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
349: FROM
350: ZX_TAXES_B A
351: WHERE
352: A.TAX = X_TAX
353: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
354: AND A.CONTENT_OWNER_ID = -99;

Line 832: ZX_TAXES_B A

828:
829: BEGIN
830: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
831: FROM
832: ZX_TAXES_B A
833: WHERE
834: A.TAX = X_TAX
835: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
836: AND A.CONTENT_OWNER_ID = X_CONTENT_OWNER_ID;

Line 845: ZX_TAXES_B A

841: WHEN NO_DATA_FOUND THEN
842:
843: SELECT TAX_TYPE_CODE INTO X_TAX_TYPE
844: FROM
845: ZX_TAXES_B A
846: WHERE
847: A.TAX = X_TAX
848: AND A.TAX_REGIME_CODE = X_TAX_REGIME_CODE
849: AND A.CONTENT_OWNER_ID = -99;

Line 997: THEN SUBSTRB(X_TAX_RATE_CODE, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')

993: VALUES(
994: X_LOOKUP_TYPE,
995: LANGUAGE_CODE,
996: (SELECT CASE WHEN LENGTHB(X_TAX_RATE_CODE) > 30
997: THEN SUBSTRB(X_TAX_RATE_CODE, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
998: ELSE X_TAX_RATE_CODE
999: END LOOKUP_CODE
1000: FROM DUAL) ,
1001: -- start bug#6992215