182: WHERE rei.pa_request_id = p_pa_request_id
183: AND rei.information_type = 'GHR_US_PAR_APPT_TRANSFER'
184: AND EXISTS (SELECT 1
185: FROM ghr_noa_families naf
186: ,ghr_pa_request_info_types rit
187: WHERE rei.information_type = rit.information_type
188: AND rit.noa_family_code = naf.noa_family_code
189: AND naf.nature_of_action_id = p_noa_id);
190: --
210: WHERE rei.pa_request_id = p_pa_request_id
211: AND rei.information_type = 'GHR_US_PAR_MASS_TERM'
212: AND EXISTS (SELECT 1
213: FROM ghr_noa_families naf
214: ,ghr_pa_request_info_types rit
215: WHERE rei.information_type = rit.information_type
216: AND rit.noa_family_code = naf.noa_family_code
217: AND naf.nature_of_action_id = p_noa_id);
218: --