[Home] [Help]
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'
1414: AND org_id = g_org_id; -- bug 7301484
1415:
1416: DBG_Loc VARCHAR2(30) := 'Get_Normal_Withholding';
1417: current_calling_sequence VARCHAR2(2000);
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)
1631: AND org_id = g_org_id -- bug 7301484
1632: ORDER BY start_amount asc;