DBA Data[Home] [Help]

APPS.PAY_US_ER_REARCH dependencies on FND_COMMON_LOOKUPS

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

259: SELECT FULL_NAME
260: FROM PER_PEOPLE_F
261: WHERE person_id = to_number(c_person_id);
262:
263: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,
264: c_lookup_code fnd_common_lookups.lookup_code%TYPE)
265: IS
266: SELECT meaning
267: FROM fnd_common_lookups

Line 264: c_lookup_code fnd_common_lookups.lookup_code%TYPE)

260: FROM PER_PEOPLE_F
261: WHERE person_id = to_number(c_person_id);
262:
263: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,
264: c_lookup_code fnd_common_lookups.lookup_code%TYPE)
265: IS
266: SELECT meaning
267: FROM fnd_common_lookups
268: WHERE lookup_type = c_lookup_type

Line 267: FROM fnd_common_lookups

263: CURSOR c_lookup_meaning(c_lookup_type fnd_common_lookups.lookup_type%TYPE,
264: c_lookup_code fnd_common_lookups.lookup_code%TYPE)
265: IS
266: SELECT meaning
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)