APPS.PO_STORE_TIMECARD_PKG_GRP dependencies on PER_ALL_PEOPLE_F

Line 215: -- Use per_all_people_f instead of per_people_f because of security settings

211:
212: if (p_contingent_worker_id is not null) then
213: l_stage := 'getting the contingent worker';
214: -- Bug6391432
215: -- Use per_all_people_f instead of per_people_f because of security settings
216: -- for this responsibility/user settings, some of the resource ids may not be
217: -- eligible for the per_people_f view criteria. which in turn will fail the query.
218: select first_name || last_name contractor_full_name,
219: first_name, last_name

Line 222: from per_all_people_f

218: select first_name || last_name contractor_full_name,
219: first_name, last_name
220: into l_contractor_full_name,
221: l_contractor_first_name, l_contractor_last_name
222: from per_all_people_f
223: where person_id = p_contingent_worker_id and
224: sysdate between effective_start_date and effective_end_date;
225: end if;
226: