APPS.GHR_MASS_CON_PROGRAM dependencies on GHR_PA_REQUEST_EI_SHADOW

Line 87: FROM ghr_pa_request_ei_shadow

83: AND pa_request_id = p_pa_request_id;
84:
85: CURSOR cur_rpa_ei_shadow (p_pa_request_id number) is
86: SELECT pa_request_extra_info_id
87: FROM ghr_pa_request_ei_shadow
88: WHERE information_type = l_information_type
89: AND pa_request_id = p_pa_request_id;
90: l_pa_rei_id number;
91: BEGIN

Line 164: insert into ghr_pa_request_ei_shadow

160: END IF;
161: IF l_pa_request_extra_info_sh_id is null then
162: hr_utility.set_location( l_proc,15);
163: IF p_noa_action ='472' THEN
164: insert into ghr_pa_request_ei_shadow
165: (pa_request_extra_info_id,
166: pa_request_id,
167: information_type,
168: rei_information3)

Line 174: insert into ghr_pa_request_ei_shadow

170: p_pa_request_id,
171: l_information_type,
172: l_employment_type);
173: ELSIF p_noa_action ='292' THEN
174: insert into ghr_pa_request_ei_shadow
175: (pa_request_extra_info_id,
176: pa_request_id,
177: information_type,
178: rei_information8)

Line 188: update ghr_pa_request_ei_shadow

184:
185: ELSE
186: hr_utility.set_location( l_proc,16);
187: IF p_noa_action ='472' THEN
188: update ghr_pa_request_ei_shadow
189: set rei_information3 = l_employment_type
190: where pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
191: ELSIF p_noa_action ='292' THEN
192: update ghr_pa_request_ei_shadow

Line 192: update ghr_pa_request_ei_shadow

188: update ghr_pa_request_ei_shadow
189: set rei_information3 = l_employment_type
190: where pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
191: ELSIF p_noa_action ='292' THEN
192: update ghr_pa_request_ei_shadow
193: set rei_information8 = l_employment_type
194: where pa_request_extra_info_id = l_pa_request_extra_info_sh_id;
195: END IF;
196: END IF;