DBA Data[Home] [Help]

APPS.GHR_PROC_FUT_MT dependencies on PER_POSITION_EXTRA_INFO

Line 33: (SELECT POEI_INFORMATION3 FROM per_position_extra_info

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

Line 58: (SELECT POEI_INFORMATION3 FROM per_position_extra_info

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