[Home] [Help]
2540: and position_id = nvl(a.to_position_id,a.from_position_id))
2541: and action_taken = 'FUTURE_ACTION'
2542: and exists
2543: (select 1
2544: from per_people_f per
2545: where per.person_id = a.person_id
2546: and a.effective_date between
2547: per.effective_start_date and per.effective_end_date )
2548: and b.pa_routing_history_id = (select max(pa_routing_history_id)
2564: and a.pa_request_id = b.pa_request_id
2565: and action_taken = 'FUTURE_ACTION'
2566: and exists
2567: (select 1
2568: from per_people_f per
2569: where per.person_id = a.person_id
2570: and a.effective_date between
2571: per.effective_start_date and per.effective_end_date )
2572: and b.pa_routing_history_id = (select max(pa_routing_history_id)
3383: -- {End Of Comments}
3384: -- ---------------------------------------------------------------------------
3385:
3386: PROCEDURE refresh_pa_request(
3387: p_person_id in per_people_f.person_id%type,
3388: p_effective_date in date,
3389: p_from_only in boolean default FALSE,
3390: p_derive_to_cols in boolean default FALSE,
3391: p_sf52_data in out nocopy ghr_pa_requests%rowtype) IS
3503: ,per.date_of_birth
3504: ,per.first_name
3505: ,per.last_name
3506: ,per.middle_names
3507: FROM per_people_f per
3508: WHERE per.person_id = p_person_id
3509: AND NVL(p_effective_date,TRUNC(sysdate)) between per.effective_start_date and per.effective_end_date;
3510:
3511: Cursor get_pos_bg ( c_position_id in number) IS
3528: -- FWFA Changes
3529: -- Bug # 1239688 --
3530: cursor get_person_type is
3531: select ppt.system_person_type
3532: from per_people_f ppf,
3533: per_person_types ppt
3534: where ppf.person_id = p_person_id
3535: and p_effective_date
3536: between ppf.effective_start_date
5768: where pa_request_id = p_Sf52_data.pa_request_id;
5769:
5770: cursor get_person_type is
5771: select ppt.system_person_type
5772: from per_people_f ppf,
5773: per_person_types ppt
5774: where ppf.person_id = p_sf52_data.person_id
5775: and p_sf52_data.effective_date
5776: between ppf.effective_start_date