29: AND approval_date IS NOT NULL
30: AND a.pa_request_id = b.pa_request_id
31: AND noa.code = a.first_noa_code
32: AND c_poi =
33: (SELECT POEI_INFORMATION3 FROM per_position_extra_info
34: WHERE information_type = 'GHR_US_POS_GRP1'
35: AND position_id = NVL(a.to_position_id,a.from_position_id))
36: AND action_taken = 'FUTURE_ACTION'
37: AND EXISTS
54: AND approval_date IS NOT NULL
55: AND a.pa_request_id = b.pa_request_id
56: AND noa.code = a.first_noa_code
57: AND c_poi =
58: (SELECT POEI_INFORMATION3 FROM per_position_extra_info
59: WHERE information_type = 'GHR_US_POS_GRP1'
60: AND position_id = NVL(a.to_position_id,a.from_position_id))
61: AND action_taken = 'FUTURE_ACTION'
62: AND EXISTS