DBA Data[Home] [Help]

APPS.CUG_WF_EMAIL_UTIL dependencies on CUG_SR_TASK_ATTR_VALS_VL

Line 186: cug_sr_task_attr_vals_vl cvals,

182: -- Process for Each Attribute one by one in the loop by getting the attribute name and value.
183: SELECT cvals.task_type_attr_value, wiav.name, wiav.type
184: INTO lv_task_type_attr_value, lv_task_type_attr_name, lv_task_type_attr_type
185: FROM CUG_TSK_TYP_ATTR_MAPS_VL cttamv,
186: cug_sr_task_attr_vals_vl cvals,
187: WF_ITEM_ATTRIBUTES_VL wiav,
188: CUG_TSK_TYP_ATTR_DEPS_VL cttadv
189: WHERE cttamv.tsk_typ_attr_map_id = cvals.task_type_attr_map_id
190: AND cttamv.task_type_attribute_code = wiav.name