APPS.GHR_PROCESS_SF52 dependencies on PER_PEOPLE_F

Line 2654: from per_people_f per

2650: and position_id = nvl(a.to_position_id,a.from_position_id))
2651: and action_taken = 'FUTURE_ACTION'
2652: and exists
2653: (select 1
2654: from per_people_f per
2655: where per.person_id = a.person_id
2656: and a.effective_date between
2657: per.effective_start_date and per.effective_end_date )
2658: and b.pa_routing_history_id = (select max(pa_routing_history_id)

Line 2678: from per_people_f per

2674: and a.pa_request_id = b.pa_request_id
2675: and action_taken = 'FUTURE_ACTION'
2676: and exists
2677: (select 1
2678: from per_people_f per
2679: where per.person_id = a.person_id
2680: and a.effective_date between
2681: per.effective_start_date and per.effective_end_date )
2682: and b.pa_routing_history_id = (select max(pa_routing_history_id)

Line 2769: l_employee_number per_people_f.employee_number%type;

2765: where par.pa_request_id = p_pa_request_id; -- 3769917
2766:
2767: -- End of Bug 3602261
2768: --Bug # 9329643
2769: l_employee_number per_people_f.employee_number%type;
2770:
2771:
2772: BEGIN
2773: for get_par_id in c_get_par_id loop

Line 3077: l_employee_number per_people_f.employee_number%type;

3073: l_proc varchar2(30):='Route_Errerd_SF52';
3074: l_new_line varchar2(1) := substr('',1,1);
3075: l_sf52 ghr_pa_requests%rowtype ;
3076: --Bug # 9329643
3077: l_employee_number per_people_f.employee_number%type;
3078:
3079: Begin
3080: l_sf52 :=p_sf52; --NOCOPY Changes
3081: hr_utility.set_location( 'Entering : ' || l_proc, 10);

Line 3513: p_person_id in per_people_f.person_id%type,

3509: -- {End Of Comments}
3510: -- ---------------------------------------------------------------------------
3511:
3512: PROCEDURE refresh_pa_request(
3513: p_person_id in per_people_f.person_id%type,
3514: p_effective_date in date,
3515: p_from_only in boolean default FALSE,
3516: p_derive_to_cols in boolean default FALSE,
3517: p_sf52_data in out nocopy ghr_pa_requests%rowtype) IS

Line 3636: FROM per_people_f per

3632: ,per.date_of_birth
3633: ,per.first_name
3634: ,per.last_name
3635: ,per.middle_names
3636: FROM per_people_f per
3637: WHERE per.person_id = p_person_id
3638: AND NVL(p_effective_date,TRUNC(sysdate)) between per.effective_start_date and per.effective_end_date;
3639:
3640: Cursor get_pos_bg ( c_position_id in number) IS

Line 3662: from per_people_f ppf,

3658: -- FWFA Changes
3659: -- Bug # 1239688 --
3660: cursor get_person_type is
3661: select ppt.system_person_type
3662: from per_people_f ppf,
3663: per_person_types ppt
3664: where ppf.person_id = p_person_id
3665: and p_effective_date
3666: between ppf.effective_start_date

Line 6050: from per_people_f ppf,

6046: where pa_request_id = p_Sf52_data.pa_request_id;
6047:
6048: cursor get_person_type is
6049: select ppt.system_person_type
6050: from per_people_f ppf,
6051: per_person_types ppt
6052: where ppf.person_id = p_sf52_data.person_id
6053: and p_sf52_data.effective_date
6054: between ppf.effective_start_date