APPS.GHR_HISTORY_FETCH dependencies on PER_ADDRESSES

Line 2230: p_address_data out nocopy per_addresses%rowtype,

2226: p_altered_pa_request_id in number default null,
2227: p_noa_id_corrected in number default null,
2228: p_rowid in rowid default null,
2229: p_pa_history_id in number default null,
2230: p_address_data out nocopy per_addresses%rowtype,
2231: p_result_code out nocopy varchar2 ) is
2232: l_result_code varchar2(100);
2233: l_hist_data ghr_pa_history%rowtype;
2234: l_proc varchar2(30):='fetch_address';

Line 2235: l_address_data per_addresses%rowtype;

2231: p_result_code out nocopy varchar2 ) is
2232: l_result_code varchar2(100);
2233: l_hist_data ghr_pa_history%rowtype;
2234: l_proc varchar2(30):='fetch_address';
2235: l_address_data per_addresses%rowtype;
2236:
2237: cursor per_address_rowid_cursor is
2238: select *
2239: from per_addresses

Line 2239: from per_addresses

2235: l_address_data per_addresses%rowtype;
2236:
2237: cursor per_address_rowid_cursor is
2238: select *
2239: from per_addresses
2240: where rowid = p_rowid;
2241:
2242: begin
2243: hr_utility.set_location('Entering:'|| l_proc, 5);