DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on GHR_POSITION_EXTRA_INFO_H_V

Line 1286: -- ghr_position_extra_info_h_v

1282: end if;
1283: End;
1284: --
1285: -- Procedure fetches the last record from per_position_extra_info or
1286: -- ghr_position_extra_info_h_v
1287: --
1288: Procedure fetch_positionei (
1289: p_position_extra_info_id in number default null,
1290: p_date_effective in date default null,

Line 1734: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;

1730: p_pos_ei_data out nocopy per_position_extra_info%rowtype
1731: )
1732: is
1733: l_proc varchar2(72) := 'Fetch_positionei (2)';
1734: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;
1735: l_pa_history_id ghr_pa_history.pa_history_id%type;
1736: l_max_effective_date date;
1737: l_session ghr_history_api.g_session_var_type;
1738: l_extra_info_id per_position_extra_info.position_extra_info_id%type;