APPS.HXC_TIMEKEEPER_WF_PKG dependencies on PER_ALL_PEOPLE_F

Line 381: from per_all_people_f

377:
378: cursor csr_closest_name1
379: (b_person_id in number,b_effective_date date) is
380: select full_name
381: from per_all_people_f
382: where person_id = b_person_id
383: and (effective_end_date=(select max(effective_end_date) from per_all_people_f
384: where person_id=b_person_id and(effective_end_date<= b_effective_date)));
385:

Line 383: and (effective_end_date=(select max(effective_end_date) from per_all_people_f

379: (b_person_id in number,b_effective_date date) is
380: select full_name
381: from per_all_people_f
382: where person_id = b_person_id
383: and (effective_end_date=(select max(effective_end_date) from per_all_people_f
384: where person_id=b_person_id and(effective_end_date<= b_effective_date)));
385:
386:
387: cursor csr_closest_name2(b_person_id in number,b_effective_date date) is

Line 389: from per_all_people_f

385:
386:
387: cursor csr_closest_name2(b_person_id in number,b_effective_date date) is
388: select full_name
389: from per_all_people_f
390: where person_id = b_person_id
391: and (effective_start_date=(select min(effective_start_date) from per_all_people_f
392: where person_id=b_person_id and
393: (effective_start_date>= b_effective_date)));

Line 391: and (effective_start_date=(select min(effective_start_date) from per_all_people_f

387: cursor csr_closest_name2(b_person_id in number,b_effective_date date) is
388: select full_name
389: from per_all_people_f
390: where person_id = b_person_id
391: and (effective_start_date=(select min(effective_start_date) from per_all_people_f
392: where person_id=b_person_id and
393: (effective_start_date>= b_effective_date)));
394:
395:

Line 396: l_temp_name per_all_people_f.full_name%type;

392: where person_id=b_person_id and
393: (effective_start_date>= b_effective_date)));
394:
395:
396: l_temp_name per_all_people_f.full_name%type;
397: l_name wf_users.name%type;
398: l_display_name wf_users.display_name%type;
399:
400: begin