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_NON_SF52_EXTRA_INFO dependencies on GHR_GENERAL

Line 59: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)

55: FROM per_people_extra_info pei,
56: pay_user_tables put
57: WHERE pei.person_id = p_person_id
58: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
59: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
60: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
61: <= p_effective_date
62: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
63: >= p_effective_date

Line 80: = ghr_general.return_number(rei.rei_information3)

76: pay_user_tables put
77: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
78: AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
79: AND pei2.person_extra_info_id
80: = ghr_general.return_number(rei.rei_information3)
81: AND (rei.rei_information5 = 'Y' or rei.rei_information5 is NULL )
82: AND put.user_table_id
83: = ghr_general.return_number(pei2.pei_information6)
84: AND rei.pa_request_id = l_altered_pa_request_id

Line 83: = ghr_general.return_number(pei2.pei_information6)

79: AND pei2.person_extra_info_id
80: = ghr_general.return_number(rei.rei_information3)
81: AND (rei.rei_information5 = 'Y' or rei.rei_information5 is NULL )
82: AND put.user_table_id
83: = ghr_general.return_number(pei2.pei_information6)
84: AND rei.pa_request_id = l_altered_pa_request_id
85: order by 1;
86:
87: Cursor c_866(p_person_extra_info_id in

Line 159: = ghr_general.return_number(rei.rei_information3)

155: pay_user_tables put
156: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
157: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
158: AND pei2.person_extra_info_id
159: = ghr_general.return_number(rei.rei_information3)
160: AND put.user_table_id
161: = ghr_general.return_number(pei2.pei_information6)
162: AND rei.rei_information5 = 'Y'
163: AND rei.pa_request_id = l_altered_pa_request_id

Line 161: = ghr_general.return_number(pei2.pei_information6)

157: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
158: AND pei2.person_extra_info_id
159: = ghr_general.return_number(rei.rei_information3)
160: AND put.user_table_id
161: = ghr_general.return_number(pei2.pei_information6)
162: AND rei.rei_information5 = 'Y'
163: AND rei.pa_request_id = l_altered_pa_request_id
164: order by 1;
165: