APPS.OTA_UTILITY dependencies on WF_ACTIVITY_ATTRIBUTES

Line 156: select text_default from wf_activity_attributes where NAME = 'HR_APPROVAL_REQ_FLAG'

152: AND WAAV.NAME = 'HR_APPROVAL_REQ_FLAG' ;
153:
154: -- if above returns null then take from below
155: cursor default_value is
156: select text_default from wf_activity_attributes where NAME = 'HR_APPROVAL_REQ_FLAG'
157: and activity_item_type = 'HRSSA'
158: and activity_name = 'OTA_COMPETENCE_NOTIFY_APPROVAL';
159:
160: cursor value_course_level is