DBA Data[Home] [Help]

APPS.POS_SUPPLIER_TAX_PROF_BO_PKG dependencies on FND_LOOKUPS

Line 163: FROM fnd_lookups fndlookup

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'

Line 185: FROM fnd_lookups fndlookup

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'

Line 225: FROM fnd_lookups fndlookup

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'