APPS.CUG_GENERIC_WF_PKG dependencies on CUG_TSK_TYP_ATTR_DEPS_VL

Line 1079: SELECT * FROM CUG_TSK_TYP_ATTR_DEPS_VL WHERE INCIDENT_TYPE_ID = l_request_type_id AND

1075: l_API_ERROR EXCEPTION;
1076:
1077: CURSOR c_SRTasks_csr
1078: IS
1079: SELECT * FROM CUG_TSK_TYP_ATTR_DEPS_VL WHERE INCIDENT_TYPE_ID = l_request_type_id AND
1080: (START_DATE_ACTIVE IS NULL OR
1081: to_number(to_char(START_DATE_ACTIVE, 'YYYYMMDD')) <= to_number(to_char(sysdate, 'YYYYMMDD')) ) AND
1082: (END_DATE_ACTIVE is NULL OR
1083: to_number(to_char(END_DATE_ACTIVE, 'YYYYMMDD')) >= to_number(to_char(sysdate, 'YYYYMMDD')) );