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 259: FROM ghr_pa_history

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

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

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