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 PAY_USER_TABLES

Line 64: pay_user_tables put

60: pei_information8,
61: pei_information9,
62: person_extra_info_id
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)

Line 84: pay_user_tables put

80: pei_information8,
81: pei_information9,
82: person_extra_info_id
83: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
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)

Line 123: FROM per_people_extra_info pei,pay_user_tables put

119: pei_information7,
120: pei_information8,
121: pei_information9,
122: person_extra_info_id
123: FROM per_people_extra_info pei,pay_user_tables put
124: WHERE pei.person_id = p_person_id
125: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
126: AND put.user_table_id = pei.pei_information6
127: AND p_effective_date

Line 167: FROM per_people_extra_info pei,pay_user_tables put

163: pei_information9,
164: person_extra_info_id,
165: null terminate_flag,
166: null original_rpa
167: FROM per_people_extra_info pei,pay_user_tables put
168: WHERE pei.person_id = p_person_id
169: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
170: AND put.user_table_id = pei.pei_information6
171: AND p_effective_date

Line 188: pay_user_tables put

184: person_extra_info_id,
185: rei_information5 terminate_flag,
186: 'Original RPA' origianl_rpa
187: FROM per_people_extra_info pei2, ghr_pa_request_extra_info rei,
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)