APPS.ZX_RATES_PKG dependencies on FND_LOOKUPS

Line 97: -- Effective From and To date. So get the Max(Start Date) and Min(End Date) from fnd_lookups

93: l_effective_from := p_effective_from;
94: l_effective_to := p_effective_to;
95:
96: -- Bug # 5559151. If this procedure is called from Tax Rules/Condition Set UI then we are not passing the
97: -- Effective From and To date. So get the Max(Start Date) and Min(End Date) from fnd_lookups
98: IF l_effective_from IS NULL THEN
99: SELECT MAX(start_date_active)
100: INTO l_effective_from
101: FROM fnd_lookups

Line 101: FROM fnd_lookups

97: -- Effective From and To date. So get the Max(Start Date) and Min(End Date) from fnd_lookups
98: IF l_effective_from IS NULL THEN
99: SELECT MAX(start_date_active)
100: INTO l_effective_from
101: FROM fnd_lookups
102: WHERE lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS', 'ZX_OUTPUT_CLASSIFICATIONS')
103: AND enabled_flag = 'Y'
104: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE)
105: AND lookup_code = p_tax_rate_code;

Line 110: FROM fnd_lookups

106:
107: BEGIN
108: SELECT end_date_active
109: INTO l_effective_to
110: FROM fnd_lookups
111: WHERE lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
112: AND enabled_flag = 'Y'
113: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE)
114: AND lookup_code = p_TAX_RATE_CODE

Line 121: FROM fnd_lookups

117: EXCEPTION
118: WHEN NO_DATA_FOUND THEN
119: SELECT MAX(end_date_active)
120: INTO l_effective_to
121: FROM fnd_lookups
122: WHERE lookup_type IN('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS' , 'ZX_OUTPUT_CLASSIFICATIONS')
123: AND enabled_flag = 'Y'
124: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE)
125: AND lookup_code = p_tax_rate_code;