APPS.GHR_WGI_PKG dependencies on PER_PEOPLE_F

Line 61: FROM per_assignments_f paf, per_people_f ppf,

57: ppf.last_name, ppf.first_name, ppf.middle_names,
58: ppf.full_name, paf.position_id, paf.assignment_id,
59: paf.grade_id, paf.job_id, paf.location_id,
60: paf.organization_id
61: FROM per_assignments_f paf, per_people_f ppf,
62: per_person_types ppt
63: WHERE ppf.person_id = paf.person_id
64: AND paf.primary_flag = 'Y'
65: AND paf.assignment_type <> 'B'

Line 83: l_person_id per_people_f.person_id%TYPE;

79: --
80: -- remove person id, set default frequency to 90, uncomment element api
81: --
82: l_exists BOOLEAN;
83: l_person_id per_people_f.person_id%TYPE;
84: l_assignment_id per_assignments.assignment_id%TYPE;
85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;

Line 85: l_national_identifier per_people_f.national_identifier%TYPE;

81: --
82: l_exists BOOLEAN;
83: l_person_id per_people_f.person_id%TYPE;
84: l_assignment_id per_assignments.assignment_id%TYPE;
85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;

Line 86: l_date_of_birth per_people_f.date_of_birth%TYPE;

82: l_exists BOOLEAN;
83: l_person_id per_people_f.person_id%TYPE;
84: l_assignment_id per_assignments.assignment_id%TYPE;
85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;

Line 87: l_last_name per_people_f.last_name%TYPE;

83: l_person_id per_people_f.person_id%TYPE;
84: l_assignment_id per_assignments.assignment_id%TYPE;
85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;

Line 88: l_first_name per_people_f.first_name%TYPE;

84: l_assignment_id per_assignments.assignment_id%TYPE;
85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;

Line 89: l_middle_names per_people_f.middle_names%TYPE;

85: l_national_identifier per_people_f.national_identifier%TYPE;
86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;

Line 90: l_full_name per_people_f.full_name%TYPE;

86: l_date_of_birth per_people_f.date_of_birth%TYPE;
87: l_last_name per_people_f.last_name%TYPE;
88: l_first_name per_people_f.first_name%TYPE;
89: l_middle_names per_people_f.middle_names%TYPE;
90: l_full_name per_people_f.full_name%TYPE;
91: l_position_id per_assignments.position_id%TYPE;
92: l_grade_id ghr_pa_requests.to_grade_id%TYPE;
93: l_job_id per_assignments.job_id%TYPE;
94: l_location_id per_assignments.location_id%TYPE;