eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_CIS2007_TAX_EFF_DATE dependencies on STANDARD

Line 41: AND atr.rate_type = 'STANDARD'

37: WHERE agt.group_id = p_tax_group_id
38: AND agt.tax_name = atc.name
39: AND atc.name = atr.tax_name
40: AND atc.tax_type = 'AWT'
41: AND atr.rate_type = 'STANDARD'
42: AND(sysdate BETWEEN nvl(atr.start_date, sysdate -1)
43: AND nvl(atr.end_date, sysdate + 1))
44: AND atc.org_id = agt.org_id
45: AND atr.org_id = agt.org_id

Line 311: , 'STANDARD' --certificate_type

307: , TRUNC(p_effective_date) --start_date
308: , lcr_vendor_site.vendor_id --vendor_id
309: , lcr_vendor_site.vendor_site_id --vendor_site_id
310: , 'CERT' --certificate_number
311: , 'STANDARD' --certificate_type
312: , initcap(p_source || ' - Tax Treatment Change') --comments
313: , 1 --priority
314: , lcr_vendor_site.org_id --org_id
315: , sysdate --last_update_date

Line 398: , 'STANDARD' --certificate_type

394: , TRUNC(p_effective_date) --start_date
395: , lcr_vendor_site.vendor_id --vendor_id
396: , lcr_vendor_site.vendor_site_id --vendor_site_id
397: , 'CERT' --certificate_number
398: , 'STANDARD' --certificate_type
399: , initcap(p_source || ' - Tax Treatment Change') --comments
400: , 1 --priority
401: , lcr_vendor_site.org_id --org_id
402: , sysdate --last_update_date