APPS.GHR_HISTORY_FETCH dependencies on PER_ADDRESSES

Line 2330: p_address_data out nocopy per_addresses%rowtype,

2326: p_altered_pa_request_id in number default null,
2327: p_noa_id_corrected in number default null,
2328: p_rowid in rowid default null,
2329: p_pa_history_id in number default null,
2330: p_address_data out nocopy per_addresses%rowtype,
2331: p_result_code out nocopy varchar2 ) is
2332: l_result_code varchar2(100);
2333: l_hist_data ghr_pa_history%rowtype;
2334: l_proc varchar2(30):='fetch_address';

Line 2335: l_address_data per_addresses%rowtype;

2331: p_result_code out nocopy varchar2 ) is
2332: l_result_code varchar2(100);
2333: l_hist_data ghr_pa_history%rowtype;
2334: l_proc varchar2(30):='fetch_address';
2335: l_address_data per_addresses%rowtype;
2336:
2337: cursor per_address_rowid_cursor is
2338: select *
2339: from per_addresses

Line 2339: from per_addresses

2335: l_address_data per_addresses%rowtype;
2336:
2337: cursor per_address_rowid_cursor is
2338: select *
2339: from per_addresses
2340: where rowid = p_rowid;
2341:
2342: begin
2343: hr_utility.set_location('Entering:'|| l_proc, 5);