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: p_result boolean ;

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: p_result boolean ;
52: begin

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: p_result boolean ;
52: begin
53:

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

189: -- StartRegistration
190: l_reg_per_ovn number default null;
191: l_reg_employee_number number default null;
192: l_reg_asg_ovn number default null;
193: l_reg_full_name per_all_people_f.full_name%type default null;
194: l_reg_assignment_id number;
195: l_reg_per_effective_start_date date;
196: l_reg_per_effective_end_date date;
197: l_reg_per_comment_id number;

Line 2559: from per_all_people_f

2555: BEGIN
2556:
2557: select 'NOT_SFL'
2558: into l_check_for_sfl
2559: from per_all_people_f
2560: where person_id =l_address.person_id;
2561:
2562: EXCEPTION
2563: WHEN no_data_found THEN