APPS.CUG_GENERIC_WF_PKG dependencies on CUG_SR_TASK_TYPE_DETS_B

Line 1379: SELECT cst.owner_id from CUG_SR_TASK_TYPE_DETS_B cst, CUG_TSK_TYP_ATTR_DEPS_B cta WHERE

1375: -- Begin of changes by ANEEMUCH date 23-May-2002
1376: -- Bug# 2347600
1377: /*
1378: CURSOR c_GetTaskOwnerId_csr IS
1379: SELECT cst.owner_id from CUG_SR_TASK_TYPE_DETS_B cst, CUG_TSK_TYP_ATTR_DEPS_B cta WHERE
1380: cst.tsk_typ_attr_dep_id = cta.tsk_typ_attr_dep_id AND
1381: cta.task_type_id = l_task_type_id AND
1382: cta.incident_type_id = l_request_type_id;
1383:

Line 1391: from CUG_SR_TASK_TYPE_DETS_B cst, CUG_TSK_TYP_ATTR_DEPS_B cta

1387: */
1388:
1389: CURSOR c_GetTaskOwnerId_csr IS
1390: SELECT cst.owner_id, cst.owner_type_code
1391: from CUG_SR_TASK_TYPE_DETS_B cst, CUG_TSK_TYP_ATTR_DEPS_B cta
1392: WHERE cst.tsk_typ_attr_dep_id = cta.tsk_typ_attr_dep_id AND
1393: cta.task_type_id = l_task_type_id AND
1394: cta.incident_type_id = l_request_type_id;
1395: