DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_PA_HISTORY

Line 2657: from ghr_pa_history

2653: ,information10 info10
2654: ,information11 info11
2655: ,information16 increase_percent -- Added by Sundar 3843306
2656: ,information17 info17
2657: from ghr_pa_history
2658: where person_id = p_person_id
2659: and pa_history_id IN ( select max(pa_history_id)
2660: from ghr_pa_history
2661: where person_id = p_person_id

Line 2660: from ghr_pa_history

2656: ,information17 info17
2657: from ghr_pa_history
2658: where person_id = p_person_id
2659: and pa_history_id IN ( select max(pa_history_id)
2660: from ghr_pa_history
2661: where person_id = p_person_id
2662: and information5 = 'GHR_US_PER_MASS_ACTIONS'
2663: and table_name = 'PER_PEOPLE_EXTRA_INFO'
2664: and effective_date = eff_date