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 1328: rt ap_awt_tax_rates.tax_rate%TYPE;

1324: ExceptionRateNOTFOUND OUT NOCOPY BOOLEAN,
1325: P_Calling_Sequence IN VARCHAR2)
1326: IS
1327: amt NUMBER;
1328: rt ap_awt_tax_rates.tax_rate%TYPE;
1329: CURSOR c_exception_rate IS
1330: SELECT tax_rate,
1331: tax_rate_id
1332: FROM ap_awt_tax_rates

Line 1332: FROM ap_awt_tax_rates

1328: rt ap_awt_tax_rates.tax_rate%TYPE;
1329: CURSOR c_exception_rate IS
1330: SELECT tax_rate,
1331: tax_rate_id
1332: FROM ap_awt_tax_rates
1333: WHERE invoice_num = InvNum
1334: AND vendor_id = SuppId
1335: AND vendor_site_id = SuppSiteId
1336: AND tax_name = TaxName

Line 1403: rt ap_awt_tax_rates.tax_rate%TYPE;

1399: NormalRateNOTFOUND OUT NOCOPY BOOLEAN,
1400: P_Calling_Sequence IN VARCHAR2)
1401: IS
1402: amt NUMBER;
1403: rt ap_awt_tax_rates.tax_rate%TYPE;
1404:
1405: CURSOR c_normal_rate
1406: IS
1407: SELECT tax_rate,

Line 1409: FROM ap_awt_tax_rates

1405: CURSOR c_normal_rate
1406: IS
1407: SELECT tax_rate,
1408: tax_rate_id
1409: FROM ap_awt_tax_rates
1410: WHERE tax_name = TaxName
1411: AND OpDate BETWEEN NVL(start_date, OpDate - 1)
1412: AND NVL(end_date, OpDate + 1)
1413: AND rate_type = 'STANDARD'

Line 1478: rt ap_awt_tax_rates.tax_rate%TYPE;

1474: CertRateNOTFOUND OUT NOCOPY BOOLEAN,
1475: P_Calling_Sequence IN VARCHAR2)
1476: IS
1477: amt NUMBER;
1478: rt ap_awt_tax_rates.tax_rate%TYPE;
1479: CURSOR c_certificate_rate
1480: IS
1481: SELECT tax_rate,
1482: tax_rate_id

Line 1483: FROM ap_awt_tax_rates

1479: CURSOR c_certificate_rate
1480: IS
1481: SELECT tax_rate,
1482: tax_rate_id
1483: FROM ap_awt_tax_rates
1484: WHERE tax_name = TaxName
1485: AND vendor_id = SuppId
1486: AND vendor_site_id = SuppSiteId
1487: AND OpDate BETWEEN NVL(start_date, OpDate - 1)

Line 1597: TABLE OF ap_awt_tax_rates.start_amount%TYPE

1593: nr NUMBER := 0;
1594: DO_HANDLE_BUCKET CONSTANT CHAR(1) := 'Y';
1595:
1596: TYPE Start_Amount_TabTyp IS
1597: TABLE OF ap_awt_tax_rates.start_amount%TYPE
1598: INDEX BY BINARY_INTEGER;
1599: tab_start_amount Start_Amount_TabTyp;
1600:
1601: TYPE End_Amount_TabTyp IS

Line 1602: TABLE OF ap_awt_tax_rates.end_amount%TYPE

1598: INDEX BY BINARY_INTEGER;
1599: tab_start_amount Start_Amount_TabTyp;
1600:
1601: TYPE End_Amount_TabTyp IS
1602: TABLE OF ap_awt_tax_rates.end_amount%TYPE
1603: INDEX BY BINARY_INTEGER;
1604: tab_end_amount End_Amount_TabTyp;
1605:
1606: TYPE Tax_Rate_TabTyp IS

Line 1607: TABLE OF ap_awt_tax_rates.tax_rate%TYPE

1603: INDEX BY BINARY_INTEGER;
1604: tab_end_amount End_Amount_TabTyp;
1605:
1606: TYPE Tax_Rate_TabTyp IS
1607: TABLE OF ap_awt_tax_rates.tax_rate%TYPE
1608: INDEX BY BINARY_INTEGER;
1609: tab_tax_rate Tax_Rate_TabTyp;
1610:
1611: TYPE Tax_Rate_Id_TabTyp IS

Line 1612: TABLE OF ap_awt_tax_rates.tax_rate_id%TYPE

1608: INDEX BY BINARY_INTEGER;
1609: tab_tax_rate Tax_Rate_TabTyp;
1610:
1611: TYPE Tax_Rate_Id_TabTyp IS
1612: TABLE OF ap_awt_tax_rates.tax_rate_id%TYPE
1613: INDEX BY BINARY_INTEGER;
1614: tab_tax_rate_id Tax_Rate_Id_TabTyp;
1615:
1616: CURSOR c_amount_ranges (

Line 1626: FROM ap_awt_tax_rates

1622: , start_amount
1623: , end_amount
1624: , NVL(start_date, OpDate - 1) start_date
1625: , NVL(end_date, OpDate + 1) end_date
1626: FROM ap_awt_tax_rates
1627: WHERE tax_name = TaxCode
1628: AND rate_type = 'STANDARD'
1629: AND OpDate BETWEEN NVL(start_date, OpDate - 1)
1630: AND NVL(end_date, OpDate + 1)

Line 2505: EXCEPTION_withholding_rate ap_awt_tax_rates.tax_rate%TYPE;

2501: current_amount_subject_for_tax NUMBER;
2502: current_rank_tax_cumulator NUMBER;
2503: current_rank integer;
2504: starting_group integer(1);
2505: EXCEPTION_withholding_rate ap_awt_tax_rates.tax_rate%TYPE;
2506: EXCEPTION_withholding_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
2507: EXCEPTION_withholding_amount NUMBER;
2508: NUMBER_of_ranges NUMBER;
2509: ranges_withholding_amount NUMBER;

Line 2506: EXCEPTION_withholding_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;

2502: current_rank_tax_cumulator NUMBER;
2503: current_rank integer;
2504: starting_group integer(1);
2505: EXCEPTION_withholding_rate ap_awt_tax_rates.tax_rate%TYPE;
2506: EXCEPTION_withholding_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
2507: EXCEPTION_withholding_amount NUMBER;
2508: NUMBER_of_ranges NUMBER;
2509: ranges_withholding_amount NUMBER;
2510: normal_withholding_amount NUMBER;

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

2675: END IF;
2676: EXIT WHEN must_be_base_currency;
2677:
2678: -- One of following will turn to FALSE IF at least one valid
2679: -- Withholding Tax Rate row exist in AP_AWT_TAX_RATES table
2680: -- FOR current tax in current group:
2681: custom_rate_NOTFOUND := TRUE;
2682: EXCEPTION_rate_NOTFOUND := TRUE;
2683: certIFicate_rate_NOTFOUND := TRUE;

Line 2708: custom_awt_tax_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;

2704:
2705: <>
2706: DECLARE
2707: DBG_Loc VARCHAR2(30) := 'Custom_Withholding_Hook';
2708: custom_awt_tax_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
2709: INVALID_TAX_RATE_ID EXCEPTION;
2710: BEGIN
2711:
2712: custom_awt_tax_rate_id :=

Line 2728: FROM ap_awt_tax_rates

2724: DECLARE
2725: CURSOR c_custom_rate (TaxRateId IN NUMBER)
2726: IS
2727: SELECT tax_rate
2728: FROM ap_awt_tax_rates
2729: WHERE tax_rate_id = TaxRateId;
2730:
2731: custom_wt_amount NUMBER;
2732: unrounded_custom_wt_amount number; --bug10262174

Line 2733: custom_wt_rate ap_awt_tax_rates.tax_rate%TYPE;

2729: WHERE tax_rate_id = TaxRateId;
2730:
2731: custom_wt_amount NUMBER;
2732: unrounded_custom_wt_amount number; --bug10262174
2733: custom_wt_rate ap_awt_tax_rates.tax_rate%TYPE;
2734: custom_rate_notfound boolean;
2735: BEGIN
2736: debug_info := 'Open CURSOR FOR custom rate';
2737: OPEN c_custom_rate(custom_awt_tax_rate_id);