APPS.HR_PROCESS_ADDRESS_SS dependencies on PER_ALL_PEOPLE_F

Line 43: FROM per_all_people_f per

39: IS
40: SELECT per.current_applicant_flag,
41: per.current_employee_flag,
42: per.current_npw_flag
43: FROM per_all_people_f per
44: WHERE per.person_id = p_person_id
45: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
46:
47: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

Line 47: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

43: FROM per_all_people_f per
44: WHERE per.person_id = p_person_id
45: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
46:
47: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
48: l_current_employee_flag per_all_people_f.current_employee_flag%type;
49: l_current_npw_flag per_all_people_f.current_npw_flag%type;
50: l_applicant_hire boolean := false ;
51: l_re_hire boolean := false ;

Line 48: l_current_employee_flag per_all_people_f.current_employee_flag%type;

44: WHERE per.person_id = p_person_id
45: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
46:
47: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
48: l_current_employee_flag per_all_people_f.current_employee_flag%type;
49: l_current_npw_flag per_all_people_f.current_npw_flag%type;
50: l_applicant_hire boolean := false ;
51: l_re_hire boolean := false ;
52: p_result boolean := true;

Line 49: l_current_npw_flag per_all_people_f.current_npw_flag%type;

45: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
46:
47: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
48: l_current_employee_flag per_all_people_f.current_employee_flag%type;
49: l_current_npw_flag per_all_people_f.current_npw_flag%type;
50: l_applicant_hire boolean := false ;
51: l_re_hire boolean := false ;
52: p_result boolean := true;
53: begin

Line 201: l_reg_full_name per_all_people_f.full_name%type default null;

197: -- StartRegistration
198: l_reg_per_ovn number default null;
199: l_reg_employee_number number default null;
200: l_reg_asg_ovn number default null;
201: l_reg_full_name per_all_people_f.full_name%type default null;
202: l_reg_assignment_id number;
203: l_reg_per_effective_start_date date;
204: l_reg_per_effective_end_date date;
205: l_reg_per_comment_id number;

Line 2567: from per_all_people_f

2563: BEGIN
2564:
2565: select 'NOT_SFL'
2566: into l_check_for_sfl
2567: from per_all_people_f
2568: where person_id =l_address.person_id;
2569:
2570: EXCEPTION
2571: WHEN no_data_found THEN