APPS.GHR_HISTORY_FETCH dependencies on PER_ALL_PEOPLE_F

Line 1140: p_people_data out nocopy per_all_people_f%rowtype,

1136: p_altered_pa_request_id in number default null,
1137: p_noa_id_corrected in number default null,
1138: p_rowid in rowid default null,
1139: p_pa_history_id in number default null,
1140: p_people_data out nocopy per_all_people_f%rowtype,
1141: p_result_code out nocopy varchar2 ) is
1142: l_result_code varchar2(100);
1143: l_hist_data ghr_pa_history%rowtype;
1144: l_proc varchar2(30):='fetch_people';

Line 1145: l_people_data per_all_people_f%rowtype;

1141: p_result_code out nocopy varchar2 ) is
1142: l_result_code varchar2(100);
1143: l_hist_data ghr_pa_history%rowtype;
1144: l_proc varchar2(30):='fetch_people';
1145: l_people_data per_all_people_f%rowtype;
1146:
1147: cursor per_people_f_cursor is
1148: select *
1149: from per_all_people_f

Line 1149: from per_all_people_f

1145: l_people_data per_all_people_f%rowtype;
1146:
1147: cursor per_people_f_cursor is
1148: select *
1149: from per_all_people_f
1150: where person_id = p_person_id
1151: and p_date_effective between effective_start_date and effective_end_date;
1152:
1153: cursor per_people_f_rowid_cursor is

Line 1155: from per_all_people_f

1151: and p_date_effective between effective_start_date and effective_end_date;
1152:
1153: cursor per_people_f_rowid_cursor is
1154: select *
1155: from per_all_people_f
1156: where rowid = p_rowid;
1157: Begin
1158: hr_utility.set_location('Entering:'|| l_proc, 5);
1159: p_result_code := null;