APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on AP_TAX_CODES_ALL

Line 34: FROM ap_tax_codes_all atc,

30: -- c_new_tax_rate will be used to get the new rate for the tax_group_id and org
31: CURSOR c_new_tax_rate(p_tax_group_id ap_awt_group_taxes.group_id%TYPE
32: , p_org_id ap_awt_group_taxes.org_id%TYPE) IS
33: SELECT atr.tax_rate new_tax_rate
34: FROM ap_tax_codes_all atc,
35: ap_awt_group_taxes_all agt,
36: ap_awt_tax_rates_all atr
37: WHERE agt.group_id = p_tax_group_id
38: AND agt.tax_name = atc.name

Line 69: l_old_tax_name ap_tax_codes_all.name%TYPE;

65: l_new_tax_rate ap_awt_tax_rates_all.tax_rate%TYPE;
66: l_new_tax_rate_id ap_awt_tax_rates.tax_rate_id%TYPE;
67: l_old_tax_grp_name ap_awt_groups.name%TYPE;
68: l_new_tax_grp_name ap_awt_groups.name%TYPE;
69: l_old_tax_name ap_tax_codes_all.name%TYPE;
70: l_update_flag VARCHAR2(2);
71: l_tax_name_exists_flag boolean;
72: l_start_date DATE;
73: l_update_date DATE;

Line 154: ap_tax_codes_all atc

150: BEGIN
151: SELECT atc.name tax_name
152: INTO l_old_tax_name
153: FROM ap_awt_group_taxes_all agt,
154: ap_tax_codes_all atc
155: WHERE agt.group_id = nvl(l_site_old_tax_grp_id, l_old_tax_grp_id)
156: AND atc.tax_type = 'AWT'
157: AND agt.tax_name = atc.name
158: AND sysdate <= nvl(atc.inactive_date, sysdate + 1)