APPS.IGI_CIS_CI36_DATA_PKG dependencies on FND_PROFILE

Line 57: AND icatr1.tax_name = fnd_profile.value ('IGI_CIS_TAX_CODE')

53: Substr(icatr1.comments,1,50) "comments", icatr1.ni_number
54: FROM igi_cis_awt_tax_rates icatr1
55: WHERE icatr1.vendor_id = P_vendor_id
56: AND icatr1.vendor_site_id = P_vendor_site_id
57: AND icatr1.tax_name = fnd_profile.value ('IGI_CIS_TAX_CODE')
58: AND TRUNC(NVL(P_check_date,icatr1.start_date))
59: BETWEEN TRUNC(icatr1.start_date)
60: AND nvl(TRUNC(icatr1.end_date),to_date('9999/12/31','YYYY/MM/DD'))
61: AND NVL(icatr1.priority, '-1') =

Line 66: AND icatr2.tax_name = fnd_profile.value ('IGI_CIS_TAX_CODE')

62: (SELECT NVL(MIN(icatr2.priority), '-1')
63: FROM igi_cis_awt_tax_rates icatr2
64: WHERE icatr2.vendor_id = P_vendor_id
65: AND icatr2.vendor_site_id = P_vendor_site_id
66: AND icatr2.tax_name = fnd_profile.value ('IGI_CIS_TAX_CODE')
67: AND TRUNC(NVL(P_check_date,icatr2.start_date))
68: BETWEEN TRUNC(icatr2.start_date)
69: AND nvl(TRUNC(icatr2.end_date),to_date('9999/12/31','YYYY/MM/DD')));
70: