APPS.GHR_HISTORY_FETCH dependencies on PER_PERSON_ANALYSES

Line 2287: -- Procedure fetch_person_analyses fetches the last record from per_person_analyses or ghr_pa_history

2283: when OTHERS then
2284: raise;
2285: End fetch_address ;
2286: --
2287: -- Procedure fetch_person_analyses fetches the last record from per_person_analyses or ghr_pa_history
2288: -- which was created between effective start date and effective end date
2289: --
2290: Procedure fetch_person_analyses (
2291: p_person_analysis_id in number default null,

Line 2297: p_peranalyses_data out nocopy per_person_analyses%rowtype,

2293: p_altered_pa_request_id in number default null,
2294: p_noa_id_corrected in number default null,
2295: p_rowid in rowid default null,
2296: p_pa_history_id in number default null,
2297: p_peranalyses_data out nocopy per_person_analyses%rowtype,
2298: p_result_code out nocopy varchar2 ) is
2299: l_peranalyses_data per_person_analyses%rowtype;
2300: l_proc varchar2(30) := 'fetch_person_analyses';
2301: l_hist_data ghr_pa_history%rowtype;

Line 2299: l_peranalyses_data per_person_analyses%rowtype;

2295: p_rowid in rowid default null,
2296: p_pa_history_id in number default null,
2297: p_peranalyses_data out nocopy per_person_analyses%rowtype,
2298: p_result_code out nocopy varchar2 ) is
2299: l_peranalyses_data per_person_analyses%rowtype;
2300: l_proc varchar2(30) := 'fetch_person_analyses';
2301: l_hist_data ghr_pa_history%rowtype;
2302: l_result_code varchar2(100);
2303: cursor per_peranalyses_rowid_cursor is

Line 2305: from per_person_analyses

2301: l_hist_data ghr_pa_history%rowtype;
2302: l_result_code varchar2(100);
2303: cursor per_peranalyses_rowid_cursor is
2304: select *
2305: from per_person_analyses
2306: where rowid = p_rowid;
2307: Begin
2308: hr_utility.set_location('Entering:'|| l_proc, 5);
2309: p_result_code := null;

Line 2913: l_person_analysis_id per_person_analyses.person_analysis_id%type;

2909: l_proc varchar2(72) := 'return_special_information ';
2910: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
2911: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
2912: l_session ghr_history_api.g_session_var_type;
2913: l_person_analysis_id per_person_analyses.person_analysis_id%type;
2914: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2915:
2916: Cursor c_flex_num is
2917: select flx.id_flex_num

Line 2933: per_person_analyses per

2929: FND_DATE.CANONICAL_TO_DATE(gan.information10) date_to ,
2930: pa_request_id,
2931: TO_NUMBER(gan.INFORMATION6) analysis_Criteria_id
2932: from ghr_pa_history gan , -- ghr_person_analyses_h_v gan,
2933: per_person_analyses per
2934: where gan.table_name = 'PER_PERSON_ANALYSES'
2935: and TO_NUMBER(gan.information7) = p_person_id -- information7 holds person_id
2936: and per.person_id = TO_NUMBER(gan.information7)
2937: and TO_NUMBER(gan.INFORMATION11)= l_id_flex_num -- information11 holds id_flex_Number

Line 2934: where gan.table_name = 'PER_PERSON_ANALYSES'

2930: pa_request_id,
2931: TO_NUMBER(gan.INFORMATION6) analysis_Criteria_id
2932: from ghr_pa_history gan , -- ghr_person_analyses_h_v gan,
2933: per_person_analyses per
2934: where gan.table_name = 'PER_PERSON_ANALYSES'
2935: and TO_NUMBER(gan.information7) = p_person_id -- information7 holds person_id
2936: and per.person_id = TO_NUMBER(gan.information7)
2937: and TO_NUMBER(gan.INFORMATION11)= l_id_flex_num -- information11 holds id_flex_Number
2938: and per.id_flex_num = TO_NUMBER(gan.INFORMATION11)

Line 2951: from per_person_analyses pan

2947: --- Not much impact so changing the select statement.
2948:
2949: Cursor c_pan_ovn is
2950: select object_version_number
2951: from per_person_analyses pan
2952: where person_analysis_id = l_person_analysis_id;
2953:
2954: Cursor c_sit is
2955: select pea.analysis_criteria_id,