APPS.WIP_REPETITIVE_ENTITY dependencies on DUAL

Line 42: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;

38: from WIP_REPETITIVE_ITEMS
39: where organization_id = p_org_id
40: and primary_item_id = p_primary_id;
41:
42: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;
43:
44: X_Gen_Object_Id NUMBER;
45:
46: begin

Line 55: from dual;

51: if check_entity%NOTFOUND then
52: -- create new entry in wip_entities
53: select wip_entities_s.nextval
54: into p_entity_id
55: from dual;
56:
57: OPEN C4;
58: FETCH C4 INTO X_Gen_Object_Id;
59: if (C4%NOTFOUND) then