APPS.IGI_CIS2007_CERT_PKG dependencies on STANDARD

Line 55: AND atr.rate_type = 'STANDARD'

51: AND atc.tax_type = 'AWT'
52: AND(trunc(sysdate) BETWEEN trunc(nvl(atc.start_date, sysdate -1))
53: AND trunc(nvl(atc.inactive_date, sysdate + 1)))
54: AND atc.name = atr.tax_name
55: AND atr.rate_type = 'STANDARD'
56: AND(trunc(sysdate) BETWEEN trunc(nvl(atr.start_date, sysdate -1))
57: AND trunc(nvl(atr.end_date, sysdate + 1)))
58: ORDER BY agt.group_id, atr.tax_rate;
59:

Line 154: ,'STANDARD' -- certificate_type

150: ,TRUNC(C_Tax_Info_Rec.start_date) -- start_date
151: ,C_Tax_Names_Rec.vendor_id -- vendor_id
152: ,C_Tax_Names_Rec.vendor_site_id -- vendor_site_id
153: ,'CERT' -- certificate_number
154: ,'STANDARD' -- certificate_type
155: ,'TAX RATE CHANGE' -- comments
156: ,0 -- priority
157: ,C_Tax_Names_Rec.org_id -- org_id
158: ,sysdate -- last_update_date