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 1648: AND fnd_date.canonical_to_date(aei.aei_information1) = (

1644: select aei.assignment_extra_info_id
1645: from per_assignment_extra_info aei
1646: where aei.assignment_id = p_assignment_id
1647: and aei.information_type = p_information_type
1648: AND fnd_date.canonical_to_date(aei.aei_information1) = (
1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in
1650: where fnd_date.canonical_to_date(aei_in.aei_information1)<= p_date_effective
1651: AND aei_in.information_type=aei.information_type
1652: and aei_in.assignment_id = aei.assignment_id

Line 1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in

1645: from per_assignment_extra_info aei
1646: where aei.assignment_id = p_assignment_id
1647: and aei.information_type = p_information_type
1648: AND fnd_date.canonical_to_date(aei.aei_information1) = (
1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in
1650: where fnd_date.canonical_to_date(aei_in.aei_information1)<= p_date_effective
1651: AND aei_in.information_type=aei.information_type
1652: and aei_in.assignment_id = aei.assignment_id
1653: AND aei_in.assignment_extra_info_id IN(

Line 1650: where fnd_date.canonical_to_date(aei_in.aei_information1)<= p_date_effective

1646: where aei.assignment_id = p_assignment_id
1647: and aei.information_type = p_information_type
1648: AND fnd_date.canonical_to_date(aei.aei_information1) = (
1649: select max(fnd_date.canonical_to_date(aei_in.aei_information1)) from per_assignment_extra_info aei_in
1650: where fnd_date.canonical_to_date(aei_in.aei_information1)<= p_date_effective
1651: AND aei_in.information_type=aei.information_type
1652: and aei_in.assignment_id = aei.assignment_id
1653: AND aei_in.assignment_extra_info_id IN(
1654: select to_number(information1) from ghr_pa_history gph

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

3024: --6856387 added order by pa_history_id asc as in 10g if both from date and person analysis id is
3025: -- same then it is not ordering on pa_history_id(In 10g ordering will not happen based on primary key)
3026: Cursor c_person_analyses is
3027: select TO_NUMBER(gan.INFORMATION1) person_analysis_id,
3028: FND_DATE.CANONICAL_TO_DATE(gan.information9) date_from,
3029: FND_DATE.CANONICAL_TO_DATE(gan.information10) date_to ,
3030: pa_request_id,
3031: TO_NUMBER(gan.INFORMATION6) analysis_Criteria_id
3032: from ghr_pa_history gan , -- ghr_person_analyses_h_v gan,

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

3025: -- same then it is not ordering on pa_history_id(In 10g ordering will not happen based on primary key)
3026: Cursor c_person_analyses is
3027: select TO_NUMBER(gan.INFORMATION1) person_analysis_id,
3028: FND_DATE.CANONICAL_TO_DATE(gan.information9) date_from,
3029: FND_DATE.CANONICAL_TO_DATE(gan.information10) date_to ,
3030: pa_request_id,
3031: TO_NUMBER(gan.INFORMATION6) analysis_Criteria_id
3032: from ghr_pa_history gan , -- ghr_person_analyses_h_v gan,
3033: per_person_analyses per

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

3037: and TO_NUMBER(gan.INFORMATION11)= l_id_flex_num -- information11 holds id_flex_Number
3038: and per.id_flex_num = TO_NUMBER(gan.INFORMATION11)
3039: and to_char(per.person_analysis_id) = gan.INFORMATION1 -- information1 holds person_analysis_id (3206581)
3040: and p_effective_date
3041: between nvl(fnd_date.canonical_to_date(gan.information9),p_effective_date)
3042: and nvl(fnd_date.canonical_to_date(gan.information10),p_effective_date) -- information9,information10 holds date_from,date_to
3043: order by 2,1 desc, pa_history_id asc;
3044:
3045: ---- The following cursor is used only when the l_session.noa_id_correct is not null

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

3038: and per.id_flex_num = TO_NUMBER(gan.INFORMATION11)
3039: and to_char(per.person_analysis_id) = gan.INFORMATION1 -- information1 holds person_analysis_id (3206581)
3040: and p_effective_date
3041: between nvl(fnd_date.canonical_to_date(gan.information9),p_effective_date)
3042: and nvl(fnd_date.canonical_to_date(gan.information10),p_effective_date) -- information9,information10 holds date_from,date_to
3043: order by 2,1 desc, pa_history_id asc;
3044:
3045: ---- The following cursor is used only when the l_session.noa_id_correct is not null
3046: --- and from the gh52doup.pkb