267: FROM fnd_common_lookups
268: WHERE lookup_type = c_lookup_type
269: AND lookup_code = c_lookup_code;
270:
271: CURSOR c_state_code(c_fips_code pay_state_rules.fips_code%TYPE)
272: IS
273: SELECT fips_code||' - ('||state_code||')'
274: FROM pay_state_rules
275: WHERe fips_code = c_fips_code;
270:
271: CURSOR c_state_code(c_fips_code pay_state_rules.fips_code%TYPE)
272: IS
273: SELECT fips_code||' - ('||state_code||')'
274: FROM pay_state_rules
275: WHERe fips_code = c_fips_code;
276:
277:
278: