APPS.GHR_HISTORY_FETCH dependencies on HR_ALL_POSITIONS_F

Line 2514: p_position_data out nocopy hr_all_positions_f%rowtype,

2510: p_noa_id_corrected in number default null,
2511: p_rowid in rowid default null,
2512: p_pa_history_id in number default null,
2513: p_get_ovn_flag in varchar2 default 'N',
2514: p_position_data out nocopy hr_all_positions_f%rowtype,
2515: p_result_code out nocopy varchar2 ) is
2516:
2517: cursor per_posn_f_cursor is
2518: select *

Line 2519: from hr_all_positions_f

2515: p_result_code out nocopy varchar2 ) is
2516:
2517: cursor per_posn_f_cursor is
2518: select *
2519: from hr_all_positions_f
2520: where position_id = p_position_id
2521: and p_date_effective between effective_start_date and
2522: effective_end_date;
2523:

Line 2526: from hr_all_positions_f

2522: effective_end_date;
2523:
2524: cursor per_posn_f_rowid_cursor is
2525: select *
2526: from hr_all_positions_f
2527: where rowid = p_rowid;
2528:
2529: cursor c_get_ovn is
2530: select object_version_number

Line 2538: from hr_all_positions_f

2534: effective_end_date;
2535:
2536: cursor c_get_end_date is
2537: select date_end
2538: from hr_all_positions_f
2539: where position_id = p_position_id
2540: and p_date_effective between effective_start_date and
2541: effective_end_date;
2542:

Line 2544: l_position_data hr_all_positions_f%rowtype;

2540: and p_date_effective between effective_start_date and
2541: effective_end_date;
2542:
2543: l_result_code varchar2(30);
2544: l_position_data hr_all_positions_f%rowtype;
2545: l_hist_data ghr_pa_history%rowtype;
2546: l_proc varchar2(30):='fetch_positionei';
2547:
2548: Begin