APPS.GHR_SF52_PRE_UPDATE dependencies on GHR_PA_REQUEST_EI_SHADOW

Line 2677: from ghr_pa_request_ei_shadow

2673: cursor c_get_shadow_rec(p_pa_request_id in number,
2674: p_information_type in varchar2)
2675: is
2676: select *
2677: from ghr_pa_request_ei_shadow
2678: where pa_request_id = p_pa_request_id
2679: and information_type = p_information_type;
2680:
2681: --Bug # 12562230

Line 2704: shadow_ei_rec ghr_pa_request_ei_shadow%rowtype;

2700: p_pa_request_rec.effective_date)) IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX');
2701:
2702:
2703:
2704: shadow_ei_rec ghr_pa_request_ei_shadow%rowtype;
2705: l_curr_bg per_all_people_f.business_group_id%type;
2706: l_prev_enrollment pay_element_entry_values_f.screen_entry_value%type;
2707:
2708: BEGIN