DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on GHR_POSITION_EXTRA_INFO_H_V

Line 1218: -- ghr_position_extra_info_h_v

1214: end if;
1215: End;
1216: --
1217: -- Procedure fetches the last record from per_position_extra_info or
1218: -- ghr_position_extra_info_h_v
1219: --
1220: Procedure fetch_positionei (
1221: p_position_extra_info_id in number default null,
1222: p_date_effective in date default null,

Line 1639: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;

1635: p_pos_ei_data out nocopy per_position_extra_info%rowtype
1636: )
1637: is
1638: l_proc varchar2(72) := 'Fetch_positionei (2)';
1639: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;
1640: l_pa_history_id ghr_pa_history.pa_history_id%type;
1641: l_max_effective_date date;
1642: l_session ghr_history_api.g_session_var_type;
1643: l_extra_info_id per_position_extra_info.position_extra_info_id%type;