DBA Data[Home] [Help]

APPS.GHR_MSL_PKG dependencies on GHR_PA_HISTORY

Line 2629: from ghr_pa_history

2625: ,information10 info10
2626: ,information11 info11
2627: ,information16 increase_percent -- Added by Sundar 3843306
2628: ,information17 info17
2629: from ghr_pa_history
2630: where person_id = p_person_id
2631: and pa_history_id IN ( select max(pa_history_id)
2632: from ghr_pa_history
2633: where person_id = p_person_id

Line 2632: from ghr_pa_history

2628: ,information17 info17
2629: from ghr_pa_history
2630: where person_id = p_person_id
2631: and pa_history_id IN ( select max(pa_history_id)
2632: from ghr_pa_history
2633: where person_id = p_person_id
2634: and information5 = 'GHR_US_PER_MASS_ACTIONS'
2635: and table_name = 'PER_PEOPLE_EXTRA_INFO'
2636: and effective_date = eff_date