APPS.PA_SEARCH_PVT dependencies on FND_LOOKUP_VALUES

Line 41: l_person_type fnd_lookup_values.lookup_code%TYPE; -- Bug 6526674

37: l_person_avail NUMBER:= 0;
38: l_person_pot_avail NUMBER:= 0;
39: l_days_in_period_tbl number_tbl;
40: l_resource_organization_name hr_organization_units.name%TYPE;
41: l_person_type fnd_lookup_values.lookup_code%TYPE; -- Bug 6526674
42: TYPE resource_organization_name_tbl IS TABLE OF hr_organization_units.name%TYPE
43: INDEX BY BINARY_INTEGER;
44:
45: TYPE person_id_tbl IS TABLE OF pa_resources_denorm.person_id%TYPE

Line 188: from fnd_lookup_values

184:
185: if p_search_criteria.person_type is null then l_person_type := 'ALL';
186: else
187: select decode(lookup_code,'ALL','ALL','EMP','Y','CWK','N') into l_person_type
188: from fnd_lookup_values
189: where lookup_type in ('PERSON_TYPE','PA_ANY_ALL') and
190: meaning = p_search_criteria.person_type and language = userenv('LANG')
191: and lookup_code in ('EMP','CWK','ALL');
192: end if;