APPS.WIP_DISCRETE_J_PKG dependencies on DUAL

Line 93: CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL;

89: CURSOR C(we_id NUMBER) IS SELECT rowid FROM WIP_DISCRETE_JOBS
90: WHERE wip_entity_id = we_id
91: AND organization_id = X_Organization_Id;
92:
93: CURSOR C2 IS SELECT wip_entities_s.nextval FROM DUAL;
94:
95: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES
96: WHERE wip_entity_id = we_id
97: AND organization_id = X_Organization_Id;

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

95: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES
96: WHERE wip_entity_id = we_id
97: AND organization_id = X_Organization_Id;
98:
99: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;
100:
101: X_Gen_Object_Id NUMBER;
102:
103: BEGIN

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

414: CURSOR C3(we_id NUMBER) IS SELECT rowid FROM WIP_ENTITIES
415: WHERE wip_entity_id = we_id
416: AND organization_id = X_Organization_Id;
417:
418: CURSOR C4 IS SELECT MTL_GEN_OBJECT_ID_S.nextval FROM DUAL;
419:
420: X_Gen_Object_Id NUMBER;
421:
422: dummy NUMBER;