APPS.GHR_MASS_CON_PROGRAM dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 81: FROM ghr_pa_request_extra_info

77:
78: CURSOR cur_rpa_ei (p_pa_request_id number) is
79: SELECT pa_request_extra_info_id,
80: object_version_number
81: FROM ghr_pa_request_extra_info
82: WHERE information_type = l_information_type
83: AND pa_request_id = p_pa_request_id;
84:
85: CURSOR cur_rpa_ei_shadow (p_pa_request_id number) is

Line 169: values (ghr_pa_request_extra_info_s.nextval,

165: (pa_request_extra_info_id,
166: pa_request_id,
167: information_type,
168: rei_information3)
169: values (ghr_pa_request_extra_info_s.nextval,
170: p_pa_request_id,
171: l_information_type,
172: l_employment_type);
173: ELSIF p_noa_action ='292' THEN

Line 179: values (ghr_pa_request_extra_info_s.nextval,

175: (pa_request_extra_info_id,
176: pa_request_id,
177: information_type,
178: rei_information8)
179: values (ghr_pa_request_extra_info_s.nextval,
180: p_pa_request_id,
181: l_information_type,
182: l_employment_type);
183: END IF;