APPS.MODAL_DELETE dependencies on DUAL

Line 67: FROM SYS.DUAL;

63: status_value NUMBER;
64: del_header NUMBER;
65: Cursor GetNewGroup is
66: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id
67: FROM SYS.DUAL;
68: Cursor GetEntity is
69: Select bde.delete_entity_sequence_id
70: From bom_delete_entities bde
71: Where bde.delete_group_sequence_id = new_group_seq_id_v

Line 79: From sys.dual;

75: And nvl(bde.organization_id, 0) = nvl(org_id, 0);
76: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;
77: Cursor GetNewEntity is
78: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id
79: From sys.dual;
80: Cursor GetComponent is
81: SELECT BIC.COMPONENT_SEQUENCE_ID,
82: BIC.EFFECTIVITY_DATE,
83: BIC.DISABLE_DATE,

Line 438: FROM SYS.DUAL;

434: WHERE DELETE_GROUP_NAME = name;
435:
436: Cursor GetNewGroup is
437: SELECT BOM_DELETE_GROUPS_S.NEXTVAL group_id
438: FROM SYS.DUAL;
439:
440: Cursor GetEntity is
441: Select bde.delete_entity_sequence_id
442: From bom_delete_entities bde

Line 453: From sys.dual;

449: X_EntSeqId bom_delete_entities.delete_entity_sequence_id%type := null;
450:
451: Cursor GetNewEntity is
452: Select BOM_DELETE_ENTITIES_S.NEXTVAL Entity_Id
453: From sys.dual;
454:
455: Cursor GetComponent is
456: SELECT BIC.COMPONENT_SEQUENCE_ID,
457: BIC.EFFECTIVITY_DATE,