DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG2 dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 186: ,ghr_pa_request_info_types rit

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: --

Line 214: ,ghr_pa_request_info_types rit

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: --