DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on FND_LOOKUP_VALUES

Line 4577: from fnd_lookup_values flv,

4573: l_code varchar2(30);
4574: begin
4575: select flv.lookup_code
4576: into l_code
4577: from fnd_lookup_values flv,
4578: per_assignments_f asg,
4579: hr_pump_batch_line_user_keys key
4580: where key.user_key_value = p_assignment_user_key
4581: and asg.assignment_id = key.unique_key_id

Line 4778: from fnd_lookup_values flv

4774: -- Check against meaning using the new R11.5 lookup tables.
4775: --
4776: select flv.lookup_code
4777: into l_code
4778: from fnd_lookup_values flv
4779: where flv.meaning = p_meaning_or_code
4780: and flv.lookup_type = p_lookup_type
4781: and flv.language = nvl(l_language_code, userenv('LANG'))
4782: and flv.view_application_id = 3