APPS.ZX_RATES_PKG dependencies on ZX_RATES_B

Line 275: cursor C is select ROWID from ZX_RATES_B

271:
272: ) is
273: X_ORG_ID NUMBER;
274: X_TAX_TYPE VARCHAR2(30);
275: cursor C is select ROWID from ZX_RATES_B
276: where TAX_RATE_ID = X_TAX_RATE_ID ;
277: begin
278: insert into ZX_RATES_B (
279: TAX_RATE_ID,

Line 278: insert into ZX_RATES_B (

274: X_TAX_TYPE VARCHAR2(30);
275: cursor C is select ROWID from ZX_RATES_B
276: where TAX_RATE_ID = X_TAX_RATE_ID ;
277: begin
278: insert into ZX_RATES_B (
279: TAX_RATE_ID,
280: TAX_RATE_CODE,
281: CONTENT_OWNER_ID,
282: EFFECTIVE_FROM,

Line 641: from ZX_RATES_B

637: ALLOW_EXCEPTIONS_FLAG,
638: SOURCE_ID,
639: -- DESCRIPTION, -- commented as part of fix for bug# 6820043
640: TAXABLE_BASIS_FORMULA_CODE
641: from ZX_RATES_B
642: where TAX_RATE_ID = X_TAX_RATE_ID
643: for update of TAX_RATE_ID nowait;
644: recinfo c%rowtype;
645: cursor c1 is select

Line 862: update ZX_RATES_B set

858: X_TAX_TYPE VARCHAR2(30);
859: X_RETURN_STATUS VARCHAR2(1) ; --bug#6992215
860:
861: begin
862: update ZX_RATES_B set
863: TAX_RATE_CODE = X_TAX_RATE_CODE,
864: CONTENT_OWNER_ID = X_CONTENT_OWNER_ID,
865: EFFECTIVE_FROM = X_EFFECTIVE_FROM,
866: EFFECTIVE_TO = X_EFFECTIVE_TO,

Line 1032: delete from ZX_RATES_B

1028: where TAX_RATE_ID = X_TAX_RATE_ID;
1029: if (sql%notfound) then
1030: raise no_data_found;
1031: end if;
1032: delete from ZX_RATES_B
1033: where TAX_RATE_ID = X_TAX_RATE_ID;
1034: if (sql%notfound) then
1035: raise no_data_found;
1036: end if;

Line 1048: from ZX_RATES_B B

1044: begin
1045: delete from ZX_RATES_TL T
1046: where not exists
1047: (select NULL
1048: from ZX_RATES_B B
1049: where B.TAX_RATE_ID = T.TAX_RATE_ID
1050: );
1051: update ZX_RATES_TL T set (
1052: TAX_RATE_NAME