APPS.CUG_GENERIC_WF_PKG dependencies on CUG_SR_TYPE_DUP_CHK_INFO

Line 64: select INCIDENT_TYPE_ID, SR_DUP_CHECK_FLAG from CUG_SR_TYPE_DUP_CHK_INFO

60:
61: -- End of changes by ANEEMUCH date 09-May-2002
62:
63: CURSOR l_CheckIfSRHdrInfoPresent_csr IS
64: select INCIDENT_TYPE_ID, SR_DUP_CHECK_FLAG from CUG_SR_TYPE_DUP_CHK_INFO
65: WHERE INCIDENT_TYPE_ID = l_incident_type_id;
66: l_CheckIfSRHdrInfoPresent_rec l_CheckIfSRHdrInfoPresent_csr%ROWTYPE;
67:
68: CURSOR l_CheckIfSRAttrPresent_csr IS

Line 221: select resource_id FROM CUG_SR_TYPE_DUP_CHK_INFO

217: l_msg_data VARCHAR2(64);
218: l_return_status VARCHAR2(64);
219:
220: CURSOR l_GetResourceID_csr IS
221: select resource_id FROM CUG_SR_TYPE_DUP_CHK_INFO
222: WHERE incident_type_id = l_incident_type_id;
223: l_GetResourceID_rec l_GetResourceID_csr%ROWTYPE;
224:
225:

Line 481: select SR_DUP_CHECK_FLAG from CUG_SR_TYPE_DUP_CHK_INFO

477:
478: l_API_ERROR EXCEPTION;
479:
480: CURSOR c_CheckIfDupCheckOn_csr IS
481: select SR_DUP_CHECK_FLAG from CUG_SR_TYPE_DUP_CHK_INFO
482: WHERE INCIDENT_TYPE_ID = l_request_type_id;
483:
484:
485: BEGIN

Line 941: select RESOURCE_ID into l_default_owner_id FROM CUG_SR_TYPE_DUP_CHK_INFO

937:
938: select INCIDENT_TYPE_ID into l_request_type_id FROM
939: CS_INCIDENTS_ALL_VL WHERE INCIDENT_ID = l_request_id;
940:
941: select RESOURCE_ID into l_default_owner_id FROM CUG_SR_TYPE_DUP_CHK_INFO
942: WHERE Incident_Type_ID = l_request_type_id;
943:
944:
945: IF (l_default_owner_id is not null ) THEN

Line 1568: SELECT duplicate_offset, duplicate_uom FROM CUG_SR_TYPE_DUP_CHK_INFO

1564: WHERE INCIDENT_ID = l_request_id;
1565:
1566:
1567: CURSOR c_DuplicateTimeInfo_csr IS
1568: SELECT duplicate_offset, duplicate_uom FROM CUG_SR_TYPE_DUP_CHK_INFO
1569: WHERE INCIDENT_TYPE_ID = l_request_type_id;
1570: l_DuplicateTimeInfo_rec c_DuplicateTimeInfo_csr%ROWTYPE;
1571:
1572: CURSOR c_UOM_Conversion_Rate_csr IS