DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on PER_PEOPLE_F

Line 86: ,p_full_name IN per_people_f.full_name%TYPE

82: PROCEDURE fetch_and_validate_emp(
83: p_action IN VARCHAR2
84: ,p_mass_salary_id IN NUMBER
85: ,p_mass_salary_name IN VARCHAR2
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 87: ,p_national_identifier IN per_people_f.national_identifier%TYPE

83: p_action IN VARCHAR2
84: ,p_mass_salary_id IN NUMBER
85: ,p_mass_salary_name IN VARCHAR2
86: ,p_full_name IN per_people_f.full_name%TYPE
87: ,p_national_identifier IN per_people_f.national_identifier%TYPE
88: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
89: ,p_person_id IN per_assignments_f.person_id%TYPE
90: ,p_position_id IN per_assignments_f.position_id%TYPE
91: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 130: ,p_full_name IN per_people_f.full_name%TYPE

126: PROCEDURE fetch_and_validate_emp_perc(
127: p_action IN VARCHAR2
128: ,p_mass_salary_id IN NUMBER
129: ,p_mass_salary_name IN VARCHAR2
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 131: ,p_national_identifier IN per_people_f.national_identifier%TYPE

127: p_action IN VARCHAR2
128: ,p_mass_salary_id IN NUMBER
129: ,p_mass_salary_name IN VARCHAR2
130: ,p_full_name IN per_people_f.full_name%TYPE
131: ,p_national_identifier IN per_people_f.national_identifier%TYPE
132: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
133: ,p_person_id IN per_assignments_f.person_id%TYPE
134: ,p_position_id IN per_assignments_f.position_id%TYPE
135: ,p_grade_id IN per_assignments_f.grade_id%TYPE

Line 437: ,p_full_name IN per_people_f.full_name%TYPE

433: PROCEDURE fetch_and_validate_emp_ses(
434: p_action IN VARCHAR2
435: ,p_mass_salary_id IN NUMBER
436: ,p_mass_salary_name IN VARCHAR2
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE

Line 438: ,p_national_identifier IN per_people_f.national_identifier%TYPE

434: p_action IN VARCHAR2
435: ,p_mass_salary_id IN NUMBER
436: ,p_mass_salary_name IN VARCHAR2
437: ,p_full_name IN per_people_f.full_name%TYPE
438: ,p_national_identifier IN per_people_f.national_identifier%TYPE
439: ,p_assignment_id IN per_assignments_f.assignment_id%TYPE
440: ,p_person_id IN per_assignments_f.person_id%TYPE
441: ,p_position_id IN per_assignments_f.position_id%TYPE
442: ,p_grade_id IN per_assignments_f.grade_id%TYPE