APPS.GHR_MLC_PKG dependencies on GHR_PA_HISTORY

Line 3231: from ghr_pa_history

3227: eff_date in Date) IS
3228: select information9 info9
3229: ,information10 info10
3230: ,information11 info11
3231: from ghr_pa_history
3232: where person_id = p_person_id
3233: and pa_history_id IN ( select max(pa_history_id)
3234: from ghr_pa_history
3235: where person_id = p_person_id

Line 3234: from ghr_pa_history

3230: ,information11 info11
3231: from ghr_pa_history
3232: where person_id = p_person_id
3233: and pa_history_id IN ( select max(pa_history_id)
3234: from ghr_pa_history
3235: where person_id = p_person_id
3236: and information5 = 'GHR_US_PER_MASS_ACTIONS'
3237: and table_name = 'PER_PEOPLE_EXTRA_INFO'
3238: and effective_date = eff_date

Line 5391: FROM ghr_pa_history pah

5387: SELECT pah.pa_history_id,
5388: pah.information4 , -- position_id
5389: to_number(pah.information11) user_tab_id,
5390: pah.effective_date
5391: FROM ghr_pa_history pah
5392: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'
5393: AND pah.information5 = 'GHR_US_POS_VALID_GRADE'
5394: AND to_number(pah.information4) = l_pos_id
5395: AND to_number(pah.information11) = l_tab_id

Line 5406: l_hist_id ghr_pa_history.pa_history_id%type;

5402: AND pah.effective_date
5403: between pos.effective_start_date and pos.effective_end_date
5404: AND HR_GENERAL.DECODE_AVAILABILITY_STATUS(pos.availability_status_id) = 'Active');
5405:
5406: l_hist_id ghr_pa_history.pa_history_id%type;
5407: l_position_id per_assignments_f.position_id%type;
5408: l_his_eff_date ghr_pa_requests.effective_date%type;
5409: l_user_tab_id pay_user_tables.user_table_id%type;
5410:

Line 5422: UPDATE GHR_PA_HISTORY upah

5418: l_his_eff_date := hist_rec.effective_date;
5419: l_user_tab_id := hist_rec.user_tab_id;
5420:
5421:
5422: UPDATE GHR_PA_HISTORY upah
5423: SET information11 = to_char(p_upd_tableid)
5424: WHERE pa_history_id = l_hist_id;
5425:
5426: END LOOP;