269: SELECT FULL_NAME
270: FROM PER_PEOPLE_F
271: WHERE person_id = to_number(c_person_id);
272:
273: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,
274: c_lookup_code fnd_common_lookups.lookup_code%TYPE)
275: IS
276: SELECT meaning
277: FROM fnd_common_lookups
270: FROM PER_PEOPLE_F
271: WHERE person_id = to_number(c_person_id);
272:
273: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,
274: c_lookup_code fnd_common_lookups.lookup_code%TYPE)
275: IS
276: SELECT meaning
277: FROM fnd_common_lookups
278: WHERE lookup_type = c_lookup_type
273: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,
274: c_lookup_code fnd_common_lookups.lookup_code%TYPE)
275: IS
276: SELECT meaning
277: FROM fnd_common_lookups
278: WHERE lookup_type = c_lookup_type
279: AND lookup_code = c_lookup_code;
280:
281: CURSOR c_state_code(c_fips_code pay_state_rules.fips_code%TYPE)