[Home] [Help]
1298: p_altered_pa_request_id in number default null,
1299: p_noa_id_corrected in number default null,
1300: p_rowid in rowid default null,
1301: p_pa_history_id in number default null,
1302: p_assignment_data out nocopy per_all_assignments_f%rowtype,
1303: p_result_code out nocopy varchar2 ) is
1304: l_result_code varchar2(100);
1305: l_hist_data ghr_pa_history%rowtype;
1306: l_proc varchar2(30):='fetch_assignment';
1303: p_result_code out nocopy varchar2 ) is
1304: l_result_code varchar2(100);
1305: l_hist_data ghr_pa_history%rowtype;
1306: l_proc varchar2(30):='fetch_assignment';
1307: l_assignment_data per_all_assignments_f%rowtype;
1308: cursor per_assignment_f_cursor is
1309: select *
1310: from per_all_assignments_f
1311: where assignment_id = p_assignment_id
1306: l_proc varchar2(30):='fetch_assignment';
1307: l_assignment_data per_all_assignments_f%rowtype;
1308: cursor per_assignment_f_cursor is
1309: select *
1310: from per_all_assignments_f
1311: where assignment_id = p_assignment_id
1312: and p_date_effective between effective_start_date and effective_end_date;
1313: cursor per_assignment_f_rowid_cursor is
1314: select *
1311: where assignment_id = p_assignment_id
1312: and p_date_effective between effective_start_date and effective_end_date;
1313: cursor per_assignment_f_rowid_cursor is
1314: select *
1315: from per_all_assignments_f
1316: where rowid = p_rowid;
1317: Begin
1318: hr_utility.set_location('Entering:'|| l_proc, 5);
1319: p_result_code := null;
3144: p_altered_pa_request_id in number ,
3145: p_noa_id_corrected in number ,
3146: p_date_effective in date default null,
3147: -- p_get_ovn_flag in varchar2 default 'N' ,
3148: p_assignment_data out nocopy per_all_assignments_f%rowtype) as
3149:
3150:
3151:
3152: cursor get_root_hist_id(