DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on GHR_PA_HISTORY

Line 256: FROM ghr_pa_history

252: SELECT information9 info9
253: , information10 info10
254: , information11 info11
255: , information17 info17
256: FROM ghr_pa_history
257: WHERE person_id = p_person_id
258: AND pa_history_id IN
259: (
260: SELECT max (pa_history_id)

Line 261: FROM ghr_pa_history

257: WHERE person_id = p_person_id
258: AND pa_history_id IN
259: (
260: SELECT max (pa_history_id)
261: FROM ghr_pa_history
262: WHERE person_id = p_person_id
263: AND information5 = 'GHR_US_PER_MASS_ACTIONS'
264: AND table_name = 'PER_PEOPLE_EXTRA_INFO'
265: AND effective_date = eff_date