eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_HISTORY_FETCH dependencies on FND_DATE

Line 2928: FND_DATE.CANONICAL_TO_DATE(gan.information9) date_from,

2924: --6856387 added order by pa_history_id asc as in 10g if both from date and person analysis id is
2925: -- same then it is not ordering on pa_history_id(In 10g ordering will not happen based on primary key)
2926: Cursor c_person_analyses is
2927: select TO_NUMBER(gan.INFORMATION1) person_analysis_id,
2928: FND_DATE.CANONICAL_TO_DATE(gan.information9) date_from,
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,

Line 2929: FND_DATE.CANONICAL_TO_DATE(gan.information10) date_to ,

2925: -- same then it is not ordering on pa_history_id(In 10g ordering will not happen based on primary key)
2926: Cursor c_person_analyses is
2927: select TO_NUMBER(gan.INFORMATION1) person_analysis_id,
2928: FND_DATE.CANONICAL_TO_DATE(gan.information9) date_from,
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

Line 2941: between nvl(fnd_date.canonical_to_date(gan.information9),p_effective_date)

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)
2939: and to_char(per.person_analysis_id) = gan.INFORMATION1 -- information1 holds person_analysis_id (3206581)
2940: and p_effective_date
2941: between nvl(fnd_date.canonical_to_date(gan.information9),p_effective_date)
2942: and nvl(fnd_date.canonical_to_date(gan.information10),p_effective_date) -- information9,information10 holds date_from,date_to
2943: order by 2,1 desc, pa_history_id asc;
2944:
2945: ---- The following cursor is used only when the l_session.noa_id_correct is not null

Line 2942: and nvl(fnd_date.canonical_to_date(gan.information10),p_effective_date) -- information9,information10 holds date_from,date_to

2938: and per.id_flex_num = TO_NUMBER(gan.INFORMATION11)
2939: and to_char(per.person_analysis_id) = gan.INFORMATION1 -- information1 holds person_analysis_id (3206581)
2940: and p_effective_date
2941: between nvl(fnd_date.canonical_to_date(gan.information9),p_effective_date)
2942: and nvl(fnd_date.canonical_to_date(gan.information10),p_effective_date) -- information9,information10 holds date_from,date_to
2943: order by 2,1 desc, pa_history_id asc;
2944:
2945: ---- The following cursor is used only when the l_session.noa_id_correct is not null
2946: --- and from the gh52doup.pkb