APPS.JL_AR_APPLICABLE_TAXES dependencies on AP_AWT_TAX_RATES

Line 499: l_WHT_RATE_ALL AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;

495: l_TAX_RATE_AP_AWT NUMBER(15);
496: l_EFFECTIVE_START_DATE DATE;
497: l_EFFECTIVE_END_DATE DATE;
498:
499: l_WHT_RATE_ALL AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
500: l_WHT_GROUP_NUM_ALL AP_AWT_TAX_RATES_ALL.TAX_NAME%TYPE;
501:
502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;

Line 500: l_WHT_GROUP_NUM_ALL AP_AWT_TAX_RATES_ALL.TAX_NAME%TYPE;

496: l_EFFECTIVE_START_DATE DATE;
497: l_EFFECTIVE_END_DATE DATE;
498:
499: l_WHT_RATE_ALL AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
500: l_WHT_GROUP_NUM_ALL AP_AWT_TAX_RATES_ALL.TAX_NAME%TYPE;
501:
502: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
503: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;
504: l_SUPP_AWT_CODE_ID_SEQ JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;

Line 725: FROM AP_AWT_TAX_RATES

721: GROUP BY WHT_RATE, WHT_GROUP_NUM;
722:
723: SELECT 'Y'
724: INTO WHT_GROUP_NUM_rate_flag
725: FROM AP_AWT_TAX_RATES
726: WHERE tax_name = l_WHT_GROUP_NUM_ALL
727: AND tax_rate = l_WHT_RATE_ALL;
728:
729: SELECT tax_id

Line 1858: l_WHT_RATE_DEF_ATR AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;

1854: AWT_CODE_INV_AVAIL_FLAG VARCHAR2(1) := 'N';
1855:
1856: l_WHT_GROUP_NUM_DEF_ATC AP_TAX_CODES_ALL.NAME%TYPE;
1857: l_TAX_ID_DEF_ATC AP_TAX_CODES_ALL.TAX_ID%TYPE;
1858: l_WHT_RATE_DEF_ATR AP_AWT_TAX_RATES_ALL.TAX_RATE%TYPE;
1859: ALL_REC JL_AR_TURN_UPL%ROWTYPE;
1860:
1861: l_SUPP_AWT_CODE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_CODE_ID%TYPE;
1862: l_SUPP_AWT_TYPE_ID_CD JL_ZZ_AP_SUP_AWT_CD_ALL.SUPP_AWT_TYPE_ID%TYPE;

Line 1950: FROM AP_AWT_TAX_RATES

1946: AND tax_type = 'AWT';
1947:
1948: SELECT TAX_RATE
1949: INTO l_WHT_RATE_DEF_ATR
1950: FROM AP_AWT_TAX_RATES
1951: WHERE TAX_NAME = l_WHT_GROUP_NUM_DEF_ATC;
1952:
1953: SELECT TRIM(leading '0' FROM (SUBSTR(tax_name, 14, 2)))
1954: INTO l_WHT_GROUP_NUM_DEF_NO

Line 1955: FROM AP_AWT_TAX_RATES

1951: WHERE TAX_NAME = l_WHT_GROUP_NUM_DEF_ATC;
1952:
1953: SELECT TRIM(leading '0' FROM (SUBSTR(tax_name, 14, 2)))
1954: INTO l_WHT_GROUP_NUM_DEF_NO
1955: FROM AP_AWT_TAX_RATES
1956: WHERE tax_name = l_WHT_GROUP_NUM_DEF_ATC;
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN