APPS.JL_ZZ_AR_UPLOAD_TAXES dependencies on AR_VAT_TAX

Line 18: l_def_tax_code AR_VAT_TAX_ALL.TAX_CODE%TYPE;

14: l_start_date_max DATE;
15: l_start_date_sec_max DATE;
16: l_end_date_sec_max DATE;
17: l_end_date_max DATE;
18: l_def_tax_code AR_VAT_TAX_ALL.TAX_CODE%TYPE;
19: l_def_tax_rate AR_VAT_TAX_ALL.TAX_RATE%TYPE;
20: l_exist_in_all VARCHAR2(2);
21: l_proper_tax_rate_code VARCHAR2(2);
22: l_exist_in_tmp VARCHAR2(2);

Line 19: l_def_tax_rate AR_VAT_TAX_ALL.TAX_RATE%TYPE;

15: l_start_date_sec_max DATE;
16: l_end_date_sec_max DATE;
17: l_end_date_max DATE;
18: l_def_tax_code AR_VAT_TAX_ALL.TAX_CODE%TYPE;
19: l_def_tax_rate AR_VAT_TAX_ALL.TAX_RATE%TYPE;
20: l_exist_in_all VARCHAR2(2);
21: l_proper_tax_rate_code VARCHAR2(2);
22: l_exist_in_tmp VARCHAR2(2);
23: l_data_change_flag VARCHAR2(2);

Line 147: FROM AR_VAT_TAX VAT,

143:
144: BEGIN
145: SELECT 'Y'
146: INTO l_proper_tax_rate_code
147: FROM AR_VAT_TAX VAT,
148: JL_ZZ_AR_TX_CATEG JZ
149: WHERE VAT.ORG_ID = P_ORG_ID
150: AND VAT.GLOBAL_ATTRIBUTE1 = JZ.TAX_CATEGORY_ID
151: AND VAT.ORG_ID = JZ.ORG_ID

Line 243: FROM AR_VAT_TAX VAT,

239: -- DERIVING THE DEFAULT TAX CODE AND VAT TAX ID
240: BEGIN
241: SELECT VAT.TAX_CODE, VAT.TAX_RATE
242: INTO l_def_tax_code, l_def_tax_rate
243: FROM AR_VAT_TAX VAT,
244: JL_ZZ_AR_TX_CATEG JZ
245: WHERE VAT.GLOBAL_ATTRIBUTE7 = 'Y'
246: AND VAT.ORG_ID = P_ORG_ID
247: AND VAT.GLOBAL_ATTRIBUTE1 = JZ.TAX_CATEGORY_ID