DBA Data[Home] [Help]

APPS.PAY_US_ER_REARCH dependencies on FND_COMMON_LOOKUPS

Line 273: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,

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

Line 274: c_lookup_code fnd_common_lookups.lookup_code%TYPE)

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

Line 277: FROM fnd_common_lookups

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)