APPS.GHR_HISTORY_FETCH dependencies on HR_ALL_POSITIONS

Line 2614: p_position_data out nocopy hr_all_positions_f%rowtype,

2610: p_noa_id_corrected in number default null,
2611: p_rowid in rowid default null,
2612: p_pa_history_id in number default null,
2613: p_get_ovn_flag in varchar2 default 'N',
2614: p_position_data out nocopy hr_all_positions_f%rowtype,
2615: p_result_code out nocopy varchar2 ) is
2616:
2617: cursor per_posn_f_cursor is
2618: select *

Line 2619: from hr_all_positions_f

2615: p_result_code out nocopy varchar2 ) is
2616:
2617: cursor per_posn_f_cursor is
2618: select *
2619: from hr_all_positions_f
2620: where position_id = p_position_id
2621: and p_date_effective between effective_start_date and
2622: effective_end_date;
2623:

Line 2626: from hr_all_positions_f

2622: effective_end_date;
2623:
2624: cursor per_posn_f_rowid_cursor is
2625: select *
2626: from hr_all_positions_f
2627: where rowid = p_rowid;
2628:
2629: cursor c_get_ovn is
2630: select object_version_number

Line 2631: from hr_all_positions

2627: where rowid = p_rowid;
2628:
2629: cursor c_get_ovn is
2630: select object_version_number
2631: from hr_all_positions
2632: where position_id = p_position_id
2633: and p_date_effective between effective_start_date and
2634: effective_end_date;
2635:

Line 2638: from hr_all_positions_f

2634: effective_end_date;
2635:
2636: cursor c_get_end_date is
2637: select date_end
2638: from hr_all_positions_f
2639: where position_id = p_position_id
2640: and p_date_effective between effective_start_date and
2641: effective_end_date;
2642:

Line 2644: l_position_data hr_all_positions_f%rowtype;

2640: and p_date_effective between effective_start_date and
2641: effective_end_date;
2642:
2643: l_result_code varchar2(30);
2644: l_position_data hr_all_positions_f%rowtype;
2645: l_hist_data ghr_pa_history%rowtype;
2646: l_proc varchar2(30):='fetch_positionei';
2647:
2648: Begin