APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PER_PEOPLE_F

Line 17: p_person_id in per_people_f.person_id%type,

13: --End Bug# 14514445
14:
15: Procedure term_ret_grade
16: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
17: p_person_id in per_people_f.person_id%type,
18: p_first_noa_id in ghr_pa_requests.first_noa_id%type,
19: p_second_noa_id in ghr_pa_requests.second_noa_id%type,
20: p_effective_date in ghr_pa_requests.effective_date%type,
21: p_refresh_flag in varchar2 )

Line 514: p_person_id in per_people_f.person_id%type ,

510: Procedure populate_noa_spec_extra_info
511: (p_pa_request_id in number ,
512: p_first_noa_id in number ,
513: p_second_noa_id in number ,
514: p_person_id in per_people_f.person_id%type ,
515: p_assignment_id in per_assignments_f.assignment_id%type ,
516: p_position_id in per_positions.position_id%type ,
517: p_effective_date in ghr_pa_requests.effective_date%type ,
518: p_refresh_flag in varchar2 default 'Y'

Line 690: p_person_id in per_people_f.person_id%type,

686:
687: Procedure fetch_noa_spec_extra_info
688: (p_pa_request_id in number,
689: p_noa_id in number,
690: p_person_id in per_people_f.person_id%type,
691: p_assignment_id in per_assignments_f.assignment_id%type,
692: p_position_id in per_positions.position_id%type,
693: p_effective_date in ghr_pa_requests.effective_date%type,
694: p_refresh_flag in varchar2 default 'Y'

Line 714: l_person_id per_people_f.person_id%type;

710: l_old_rei_rec ghr_pa_request_extra_info%rowtype;
711: l_flag varchar2(1);
712: l_refresh_flag varchar2(1);
713: l_rei_rec_exists varchar2(1);
714: l_person_id per_people_f.person_id%type;
715: l_assignment_id per_assignments_f.assignment_id%type;
716: l_ret_review_date varchar2(30);
717: l_eff_date date;
718: l_position_id per_positions.position_id%type;

Line 4218: l_person_id per_people_f.person_id%type;

4214: l_exists boolean := FALSE;
4215: l_flag varchar2(1) := null;
4216: l_rei_rec ghr_pa_request_extra_info%rowtype;
4217: l_org_rec ghr_pa_request_ei_shadow%rowtype;
4218: l_person_id per_people_f.person_id%type;
4219: l_assignment_id per_assignments_f.assignment_id%type;
4220: l_per_refresh_flag varchar2(1);
4221: l_asg_refresh_flag varchar2(1);
4222: l_business_group_id per_assignments_f.business_group_id%type;

Line 4231: from per_people_f

4227: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
4228:
4229: cursor c_bus_gp is
4230: select business_group_id
4231: from per_people_f
4232: where person_id = p_person_id
4233: and nvl(p_effective_date,sysdate) between
4234: effective_start_date and effective_end_date;
4235:

Line 4333: per_people_f ppf

4329: -- Added by Venkat -- Bug # 1236354
4330: cursor c_person_type is
4331: select ppt.system_person_type
4332: from per_person_types ppt,
4333: per_people_f ppf
4334: where ppf.person_id = p_person_id
4335: and ppt.person_type_id = ppf.person_type_id
4336: and p_effective_date
4337: between ppf.effective_start_date