159: IF (p_rounding_level_code IS NOT NULL) THEN
160: BEGIN
161: SELECT fndlookup.lookup_code
162: INTO l_dummy_lookup
163: FROM fnd_lookups fndlookup
164: WHERE fndlookup.lookup_type LIKE 'ZX_ROUNDING_LEVEL'
165: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
166: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
167: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
181: -- Validate the rounding Rule using the following query
182: BEGIN
183: SELECT fndlookup.lookup_code
184: INTO l_dummy_lookup
185: FROM fnd_lookups fndlookup
186: WHERE fndlookup.lookup_type LIKE 'ZX_ROUNDING_RULE'
187: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
188: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
189: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'
221: -- Validate the Registration Type Code using the following query
222: BEGIN
223: SELECT fndlookup.lookup_code
224: INTO l_dummy_lookup
225: FROM fnd_lookups fndlookup
226: WHERE fndlookup.lookup_type LIKE 'ZX_REGISTRATIONS_TYPE'
227: AND nvl(fndlookup.start_date_active, SYSDATE) <= SYSDATE
228: AND nvl(fndlookup.end_date_active, SYSDATE) >= SYSDATE
229: AND nvl(fndlookup.enabled_flag, 'N') = 'Y'