APPS.GHR_ELT_TO_BEN_PKG dependencies on GHR_PA_HISTORY

Line 222: l_pa_history_rec ghr_pa_history%rowtype;

218: -- Variable Declaration
219: l_current_bg_id NUMBER(15);
220: l_current_person_id NUMBER(15);
221: l_benefits_eit_rec ghr_api.per_benefit_info_type;
222: l_pa_history_rec ghr_pa_history%rowtype;
223: l_new_effective_date DATE;
224: l_old_effective_date DATE;
225: l_cnt NUMBER;
226: l_log_text ghr_process_log.log_text%TYPE;

Line 262: FROM ghr_pa_history

258:
259: -- Cursor to pick the History Rows for a given Person ID
260: CURSOR c_person_history(p_person_id NUMBER) IS
261: SELECT *
262: FROM ghr_pa_history
263: WHERE person_id = p_person_id
264: AND (
265: (table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR
266: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

Line 330: PROCEDURE build_benefits_rec(p_pa_history_rec IN ghr_pa_history%rowtype,

326: RAISE;
327: END get_person_name_ssn;
328:
329: -- Procedure to BUILD the intermediate Benefits Record
330: PROCEDURE build_benefits_rec(p_pa_history_rec IN ghr_pa_history%rowtype,
331: p_benefits_eit_rec IN OUT nocopy ghr_api.per_benefit_info_type
332: ) IS
333:
334: l_benefits_eit_rec ghr_api.per_benefit_info_type;