eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_AWT_TAX_RATES

Line 1113: rt ap_awt_tax_rates.tax_rate%TYPE;

1109: ExceptionRateNOTFOUND OUT NOCOPY BOOLEAN,
1110: P_Calling_Sequence IN VARCHAR2)
1111: IS
1112: amt NUMBER;
1113: rt ap_awt_tax_rates.tax_rate%TYPE;
1114: CURSOR c_exception_rate IS
1115: SELECT tax_rate,
1116: tax_rate_id
1117: FROM ap_awt_tax_rates

Line 1117: FROM ap_awt_tax_rates

1113: rt ap_awt_tax_rates.tax_rate%TYPE;
1114: CURSOR c_exception_rate IS
1115: SELECT tax_rate,
1116: tax_rate_id
1117: FROM ap_awt_tax_rates
1118: WHERE invoice_num = InvNum
1119: AND vendor_id = SuppId
1120: AND vendor_site_id = SuppSiteId
1121: AND tax_name = TaxName

Line 1187: rt ap_awt_tax_rates.tax_rate%TYPE;

1183: NormalRateNOTFOUND OUT NOCOPY BOOLEAN,
1184: P_Calling_Sequence IN VARCHAR2)
1185: IS
1186: amt NUMBER;
1187: rt ap_awt_tax_rates.tax_rate%TYPE;
1188:
1189: CURSOR c_normal_rate
1190: IS
1191: SELECT tax_rate,

Line 1193: FROM ap_awt_tax_rates

1189: CURSOR c_normal_rate
1190: IS
1191: SELECT tax_rate,
1192: tax_rate_id
1193: FROM ap_awt_tax_rates
1194: WHERE tax_name = TaxName
1195: AND OpDate BETWEEN NVL(start_date, OpDate - 1)
1196: AND NVL(end_date, OpDate + 1)
1197: AND rate_type = 'STANDARD';

Line 1261: rt ap_awt_tax_rates.tax_rate%TYPE;

1257: CertRateNOTFOUND OUT NOCOPY BOOLEAN,
1258: P_Calling_Sequence IN VARCHAR2)
1259: IS
1260: amt NUMBER;
1261: rt ap_awt_tax_rates.tax_rate%TYPE;
1262: CURSOR c_certificate_rate
1263: IS
1264: SELECT tax_rate,
1265: tax_rate_id

Line 1266: FROM ap_awt_tax_rates

1262: CURSOR c_certificate_rate
1263: IS
1264: SELECT tax_rate,
1265: tax_rate_id
1266: FROM ap_awt_tax_rates
1267: WHERE tax_name = TaxName
1268: AND vendor_id = SuppId
1269: AND vendor_site_id = SuppSiteId
1270: AND OpDate BETWEEN NVL(start_date, OpDate - 1)

Line 1375: TABLE OF ap_awt_tax_rates.start_amount%TYPE

1371: nr NUMBER := 0;
1372: DO_HANDLE_BUCKET CONSTANT CHAR(1) := 'Y';
1373:
1374: TYPE Start_Amount_TabTyp IS
1375: TABLE OF ap_awt_tax_rates.start_amount%TYPE
1376: INDEX BY BINARY_INTEGER;
1377: tab_start_amount Start_Amount_TabTyp;
1378:
1379: TYPE End_Amount_TabTyp IS

Line 1380: TABLE OF ap_awt_tax_rates.end_amount%TYPE

1376: INDEX BY BINARY_INTEGER;
1377: tab_start_amount Start_Amount_TabTyp;
1378:
1379: TYPE End_Amount_TabTyp IS
1380: TABLE OF ap_awt_tax_rates.end_amount%TYPE
1381: INDEX BY BINARY_INTEGER;
1382: tab_end_amount End_Amount_TabTyp;
1383:
1384: TYPE Tax_Rate_TabTyp IS

Line 1385: TABLE OF ap_awt_tax_rates.tax_rate%TYPE

1381: INDEX BY BINARY_INTEGER;
1382: tab_end_amount End_Amount_TabTyp;
1383:
1384: TYPE Tax_Rate_TabTyp IS
1385: TABLE OF ap_awt_tax_rates.tax_rate%TYPE
1386: INDEX BY BINARY_INTEGER;
1387: tab_tax_rate Tax_Rate_TabTyp;
1388:
1389: TYPE Tax_Rate_Id_TabTyp IS

Line 1390: TABLE OF ap_awt_tax_rates.tax_rate_id%TYPE

1386: INDEX BY BINARY_INTEGER;
1387: tab_tax_rate Tax_Rate_TabTyp;
1388:
1389: TYPE Tax_Rate_Id_TabTyp IS
1390: TABLE OF ap_awt_tax_rates.tax_rate_id%TYPE
1391: INDEX BY BINARY_INTEGER;
1392: tab_tax_rate_id Tax_Rate_Id_TabTyp;
1393:
1394: CURSOR c_amount_ranges (

Line 1404: FROM ap_awt_tax_rates

1400: , start_amount
1401: , end_amount
1402: , NVL(start_date, OpDate - 1) start_date
1403: , NVL(end_date, OpDate + 1) end_date
1404: FROM ap_awt_tax_rates
1405: WHERE tax_name = TaxCode
1406: AND rate_type = 'STANDARD'
1407: AND OpDate BETWEEN NVL(start_date, OpDate - 1)
1408: AND NVL(end_date, OpDate + 1)

Line 2140: EXCEPTION_withholding_rate ap_awt_tax_rates.tax_rate%TYPE;

2136: current_amount_subject_for_tax NUMBER;
2137: current_rank_tax_cumulator NUMBER;
2138: current_rank integer;
2139: starting_group integer(1);
2140: EXCEPTION_withholding_rate ap_awt_tax_rates.tax_rate%TYPE;
2141: EXCEPTION_withholding_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
2142: EXCEPTION_withholding_amount NUMBER;
2143: NUMBER_of_ranges NUMBER;
2144: ranges_withholding_amount NUMBER;

Line 2141: EXCEPTION_withholding_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;

2137: current_rank_tax_cumulator NUMBER;
2138: current_rank integer;
2139: starting_group integer(1);
2140: EXCEPTION_withholding_rate ap_awt_tax_rates.tax_rate%TYPE;
2141: EXCEPTION_withholding_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
2142: EXCEPTION_withholding_amount NUMBER;
2143: NUMBER_of_ranges NUMBER;
2144: ranges_withholding_amount NUMBER;
2145: normal_withholding_amount NUMBER;

Line 2299: -- Withholding Tax Rate row exist in AP_AWT_TAX_RATES table

2295: END IF;
2296: EXIT WHEN must_be_base_currency;
2297:
2298: -- One of following will turn to FALSE IF at least one valid
2299: -- Withholding Tax Rate row exist in AP_AWT_TAX_RATES table
2300: -- FOR current tax in current group:
2301: custom_rate_NOTFOUND := TRUE;
2302: EXCEPTION_rate_NOTFOUND := TRUE;
2303: certIFicate_rate_NOTFOUND := TRUE;

Line 2328: custom_awt_tax_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;

2324:
2325: <>
2326: DECLARE
2327: DBG_Loc VARCHAR2(30) := 'Custom_Withholding_Hook';
2328: custom_awt_tax_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
2329: INVALID_TAX_RATE_ID EXCEPTION;
2330: BEGIN
2331:
2332: custom_awt_tax_rate_id :=

Line 2348: FROM ap_awt_tax_rates

2344: DECLARE
2345: CURSOR c_custom_rate (TaxRateId IN NUMBER)
2346: IS
2347: SELECT tax_rate
2348: FROM ap_awt_tax_rates
2349: WHERE tax_rate_id = TaxRateId;
2350:
2351: custom_wt_amount NUMBER;
2352: custom_wt_rate ap_awt_tax_rates.tax_rate%TYPE;

Line 2352: custom_wt_rate ap_awt_tax_rates.tax_rate%TYPE;

2348: FROM ap_awt_tax_rates
2349: WHERE tax_rate_id = TaxRateId;
2350:
2351: custom_wt_amount NUMBER;
2352: custom_wt_rate ap_awt_tax_rates.tax_rate%TYPE;
2353: custom_rate_notfound boolean;
2354: BEGIN
2355: debug_info := 'Open CURSOR FOR custom rate';
2356: OPEN c_custom_rate(custom_awt_tax_rate_id);