DBA Data[Home] [Help]

APPS.PA_SEARCH_PVT dependencies on HR_ORGANIZATION_UNITS

Line 40: l_resource_organization_name hr_organization_units.name%TYPE;

36: l_pot_availability_tbl number_tbl;
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:

Line 42: TYPE resource_organization_name_tbl IS TABLE OF hr_organization_units.name%TYPE

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
46: INDEX BY BINARY_INTEGER;