APPS.GHR_MLC_PKG dependencies on GHR_PA_HISTORY

Line 3277: from ghr_pa_history

3273: eff_date in Date) IS
3274: select information9 info9
3275: ,information10 info10
3276: ,information11 info11
3277: from ghr_pa_history
3278: where person_id = p_person_id
3279: and pa_history_id IN ( select max(pa_history_id)
3280: from ghr_pa_history
3281: where person_id = p_person_id

Line 3280: from ghr_pa_history

3276: ,information11 info11
3277: from ghr_pa_history
3278: where person_id = p_person_id
3279: and pa_history_id IN ( select max(pa_history_id)
3280: from ghr_pa_history
3281: where person_id = p_person_id
3282: and information5 = 'GHR_US_PER_MASS_ACTIONS'
3283: and table_name = 'PER_PEOPLE_EXTRA_INFO'
3284: and effective_date = eff_date

Line 5449: FROM ghr_pa_history pah

5445: SELECT pah.pa_history_id,
5446: pah.information4 , -- position_id
5447: to_number(pah.information11) user_tab_id,
5448: pah.effective_date
5449: FROM ghr_pa_history pah
5450: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'
5451: AND pah.information5 = 'GHR_US_POS_VALID_GRADE'
5452: AND to_number(pah.information4) = l_pos_id
5453: AND to_number(pah.information11) = l_tab_id

Line 5464: l_hist_id ghr_pa_history.pa_history_id%type;

5460: AND pah.effective_date
5461: between pos.effective_start_date and pos.effective_end_date
5462: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');
5463:
5464: l_hist_id ghr_pa_history.pa_history_id%type;
5465: l_position_id per_assignments_f.position_id%type;
5466: l_his_eff_date ghr_pa_requests.effective_date%type;
5467: l_user_tab_id pay_user_tables.user_table_id%type;
5468:

Line 5480: UPDATE GHR_PA_HISTORY upah

5476: l_his_eff_date := hist_rec.effective_date;
5477: l_user_tab_id := hist_rec.user_tab_id;
5478:
5479:
5480: UPDATE GHR_PA_HISTORY upah
5481: SET information11 = to_char(p_upd_tableid)
5482: WHERE pa_history_id = l_hist_id;
5483:
5484: END LOOP;