APPS.GHR_MASS_SEL_NOA dependencies on PER_PEOPLE_F

Line 24: , p_full_name IN per_people_f.full_name%TYPE

20: PROCEDURE fetch_and_validate_emp
21: (p_action IN varchar2
22: , p_mass_salary_id IN number
23: , p_mass_salary_name IN varchar2
24: , p_full_name IN per_people_f.full_name%TYPE
25: , p_national_identifier IN per_people_f.national_identifier%TYPE
26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE

Line 25: , p_national_identifier IN per_people_f.national_identifier%TYPE

21: (p_action IN varchar2
22: , p_mass_salary_id IN number
23: , p_mass_salary_name IN varchar2
24: , p_full_name IN per_people_f.full_name%TYPE
25: , p_national_identifier IN per_people_f.national_identifier%TYPE
26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE

Line 26: , p_employee_number IN per_people_f.employee_number%TYPE

22: , p_mass_salary_id IN number
23: , p_mass_salary_name IN varchar2
24: , p_full_name IN per_people_f.full_name%TYPE
25: , p_national_identifier IN per_people_f.national_identifier%TYPE
26: , p_employee_number IN per_people_f.employee_number%TYPE
27: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
28: , p_person_id IN per_assignments_f.person_id%TYPE
29: , p_position_id IN per_assignments_f.position_id%TYPE
30: , p_grade_id IN per_assignments_f.grade_id%TYPE

Line 75: , p_person_id IN per_people_f.person_id%TYPE

71:
72: PROCEDURE refresh_ei_details
73: (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE
74: , p_effective_date IN date
75: , p_person_id IN per_people_f.person_id%TYPE
76: , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE
77: , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE);
78:
79: FUNCTION check_select_flg