[Home] [Help]
1368: p_altered_pa_request_id in number default null,
1369: p_noa_id_corrected in number default null,
1370: p_rowid in rowid default null,
1371: p_pa_history_id in number default null,
1372: p_assignment_data out nocopy per_all_assignments_f%rowtype,
1373: p_result_code out nocopy varchar2 ) is
1374: l_result_code varchar2(100);
1375: l_hist_data ghr_pa_history%rowtype;
1376: l_proc varchar2(30):='fetch_assignment';
1373: p_result_code out nocopy varchar2 ) is
1374: l_result_code varchar2(100);
1375: l_hist_data ghr_pa_history%rowtype;
1376: l_proc varchar2(30):='fetch_assignment';
1377: l_assignment_data per_all_assignments_f%rowtype;
1378: cursor per_assignment_f_cursor is
1379: select *
1380: from per_all_assignments_f
1381: where assignment_id = p_assignment_id
1376: l_proc varchar2(30):='fetch_assignment';
1377: l_assignment_data per_all_assignments_f%rowtype;
1378: cursor per_assignment_f_cursor is
1379: select *
1380: from per_all_assignments_f
1381: where assignment_id = p_assignment_id
1382: and p_date_effective between effective_start_date and effective_end_date;
1383: cursor per_assignment_f_rowid_cursor is
1384: select *
1381: where assignment_id = p_assignment_id
1382: and p_date_effective between effective_start_date and effective_end_date;
1383: cursor per_assignment_f_rowid_cursor is
1384: select *
1385: from per_all_assignments_f
1386: where rowid = p_rowid;
1387: Begin
1388: hr_utility.set_location('Entering:'|| l_proc, 5);
1389: p_result_code := null;
3244: p_altered_pa_request_id in number ,
3245: p_noa_id_corrected in number ,
3246: p_date_effective in date default null,
3247: -- p_get_ovn_flag in varchar2 default 'N' ,
3248: p_assignment_data out nocopy per_all_assignments_f%rowtype) as
3249:
3250:
3251:
3252: cursor get_root_hist_id(