APPS.CS_SR_MASS_UPDATE_PKG dependencies on DUAL

Line 66: Into l_cs_auto_assignment From dual;

62:
63: CS_SERVICEREQUEST_PVT.INITIALIZE_REC(p_sr_record => l_sr_rec);
64:
65: Select nvl(fnd_profile.value('CS_AUTO_ASSIGN_OWNER_FORMS'), 'N')
66: Into l_cs_auto_assignment From dual;
67:
68: if(l_cs_auto_assignment = 'Y') then
69: if (p_owner_group_id is not NULL and p_owner_id is not NULL) then
70: l_sr_rec.owner_group_id := p_owner_group_id;

Line 115: select fnd_global.resp_id into l_responsibility_id from dual;

111: end if;
112: if (p_resolution_code is NOT NULL ) THEN
113: l_sr_rec.resolution_code := p_resolution_code;
114: end if;
115: select fnd_global.resp_id into l_responsibility_id from dual;
116:
117: l_temp_close_value := FND_PROFILE.VALUE('CS_SR_AUTO_CLOSE_CHILDREN');
118: if (l_temp_close_value = 'CS_SR_VALIDATE_AND_CLOSE') then
119: l_auto_close_child_entities := 'Y';