DBA Data[Home] [Help]

APPS.CUG_WF_EMAIL_UTIL dependencies on CUG_SR_TYPE_ATTR_MAPS_VL

Line 482: CUG_SR_TYPE_ATTR_MAPS_VL cstamv

478:
479: CURSOR c_all_sr_attrs_details IS
480: SELECT flv.lookup_code, flv.description
481: FROM FND_LOOKUPS flv,
482: CUG_SR_TYPE_ATTR_MAPS_VL cstamv
483: WHERE flv.lookup_code = cstamv.sr_attribute_code
484: AND cstamv.incident_type_id = lv_incident_type_id
485: AND lookup_type = 'CUG_SR_TYPE_ATTRIBUTES';
486: -- AND (cstamv.end_date_active is null or