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 67: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)

63: FROM per_people_extra_info pei,
64: pay_user_tables put
65: WHERE pei.person_id = p_person_id
66: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
67: AND put.user_table_id = ghr_general.return_number(pei.pei_information6)
68: AND NVL(fnd_date.canonical_to_date(pei.pei_information1) ,p_effective_date)
69: <= p_effective_date
70: AND nvl(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
71: >= p_effective_date

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

84: pay_user_tables put
85: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
86: AND rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'
87: AND pei2.person_extra_info_id
88: = ghr_general.return_number(rei.rei_information3)
89: AND (rei.rei_information5 = 'Y' or rei.rei_information5 is NULL )
90: AND put.user_table_id
91: = ghr_general.return_number(pei2.pei_information6)
92: AND rei.pa_request_id = l_altered_pa_request_id

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

87: AND pei2.person_extra_info_id
88: = ghr_general.return_number(rei.rei_information3)
89: AND (rei.rei_information5 = 'Y' or rei.rei_information5 is NULL )
90: AND put.user_table_id
91: = ghr_general.return_number(pei2.pei_information6)
92: AND rei.pa_request_id = l_altered_pa_request_id
93: order by 1;
94:
95: --Bug # 5584845

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

188: pay_user_tables put
189: WHERE pei2.information_type = 'GHR_US_RETAINED_GRADE'
190: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
191: AND pei2.person_extra_info_id
192: = ghr_general.return_number(rei.rei_information3)
193: AND put.user_table_id
194: = ghr_general.return_number(pei2.pei_information6)
195: AND rei.rei_information5 = 'Y'
196: AND rei.pa_request_id = l_altered_pa_request_id

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

190: AND rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
191: AND pei2.person_extra_info_id
192: = ghr_general.return_number(rei.rei_information3)
193: AND put.user_table_id
194: = ghr_general.return_number(pei2.pei_information6)
195: AND rei.rei_information5 = 'Y'
196: AND rei.pa_request_id = l_altered_pa_request_id
197: order by 1;
198: