DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on GHR_ASSIGNMENT_EXTRA_INFO_H_V

Line 3430: FROM ghr_assignment_extra_info_h_v

3426:
3427: Cursor nte_date
3428: is
3429: SELECT aei_information4
3430: FROM ghr_assignment_extra_info_h_v
3431: WHERE pa_history_id = (SELECT max(pa_history_id)
3432: FROM ghr_assignment_extra_info_h_v ASG,
3433: ghr_nature_of_actions NAT
3434: WHERE information_type = 'GHR_US_ASG_NTE_DATES'

Line 3432: FROM ghr_assignment_extra_info_h_v ASG,

3428: is
3429: SELECT aei_information4
3430: FROM ghr_assignment_extra_info_h_v
3431: WHERE pa_history_id = (SELECT max(pa_history_id)
3432: FROM ghr_assignment_extra_info_h_v ASG,
3433: ghr_nature_of_actions NAT
3434: WHERE information_type = 'GHR_US_ASG_NTE_DATES'
3435: AND asg.nature_of_action_id = nat.nature_of_action_id
3436: AND (code LIKE '1%' OR code LIKE '5%' OR code IN ('750','760','761','762','765'))