APPS.IGI_CIS2007_CERT_PKG dependencies on IGI_CIS_TAX_TREATMENT_H

Line 63: FROM ap_awt_tax_rates atr, igi_cis_tax_treatment_h his

59:
60:
61: Cursor C_Tax_Names(p_new_grp_id in ap_awt_groups.group_id%Type) Is
62: SELECT atr.*
63: FROM ap_awt_tax_rates atr, igi_cis_tax_treatment_h his
64: WHERE his.new_group_id = p_new_grp_id
65: AND atr.tax_rate_id = his.tax_rate_id
66: AND atr.priority = 1
67: ORDER BY atr.vendor_id, atr.vendor_site_id;

Line 179: Insert Into igi_cis_tax_treatment_h(

175: End If;
176: -- Debug Messages
177:
178: --Insert a corrosponding row in the history table
179: Insert Into igi_cis_tax_treatment_h(
180: vendor_id
181: ,vendor_site_id
182: ,tax_rate_id
183: ,old_group_id

Line 227: FROM ap_awt_tax_rates atr, igi_cis_tax_treatment_h his

223: UPDATE ap_awt_tax_rates
224: SET priority = priority + 1
225: WHERE (vendor_id, vendor_site_id, tax_rate_id) in
226: (SELECT atr.vendor_id , atr.vendor_site_id, atr.tax_rate_id
227: FROM ap_awt_tax_rates atr, igi_cis_tax_treatment_h his
228: WHERE new_group_id = C_Tax_Info_Rec.group_id
229: AND atr.tax_rate_id = his.tax_rate_id
230: AND priority = 0 );
231: