APPS.CUG_WF_EMAIL_UTIL dependencies on CUG_INCIDNT_ATTR_VALS_VL

Line 501: FROM CUG_INCIDNT_ATTR_VALS_VL

497: WHERE INCIDENT_ID = lv_incident_id;
498:
499: CURSOR c_get_sr_attr_value IS
500: SELECT sr_attribute_value
501: FROM CUG_INCIDNT_ATTR_VALS_VL
502: WHERE sr_attribute_code = lv_attr_code
503: AND incident_id = lv_incident_id ;
504:
505:

Line 550: -- FROM CUG_INCIDNT_ATTR_VALS_VL

546: /* Roopa begin - to fix bug 2347352 */
547: -- removed the following explicit select and using a cursor instead to fetch records
548: -- SELECT sr_attribute_value
549: -- INTO lv_attr_value
550: -- FROM CUG_INCIDNT_ATTR_VALS_VL
551: -- WHERE sr_attribute_code = lv_attr_code
552: -- AND incident_id = lv_incident_id ;
553:
554: OPEN c_get_sr_attr_value;