DBA Data[Home] [Help]

APPS.AP_CALC_WITHHOLDING_PKG dependencies on STANDARD

Line 1197: AND rate_type = 'STANDARD';

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';
1198:
1199: DBG_Loc VARCHAR2(30) := 'Get_Normal_Withholding';
1200: current_calling_sequence VARCHAR2(2000);
1201: debug_info VARCHAR2(100);

Line 1406: AND rate_type = 'STANDARD'

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)
1409: ORDER BY start_amount asc;
1410: