DBA Data[Home] [Help]

APPS.ENG_DEFAULT_REV_COMPONENT dependencies on DUAL

Line 34: FROM SYS.DUAL;

30: RETURN NUMBER
31: IS
32: CURSOR Comp_Seq IS
33: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
34: FROM SYS.DUAL;
35: BEGIN
36:
37: FOR c_Comp_Seq IN Comp_Seq LOOP
38: RETURN c_Comp_Seq.Component_Sequence;

Line 343: FROM SYS.DUAL;

339: IF l_Bill_Sequence_Id IS NULL
340: THEN
341: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal
342: INTO l_Bill_Sequence_Id
343: FROM SYS.DUAL;
344:
345: RETURN l_Bill_Sequence_id;
346: ELSE
347: Return l_bill_sequence_id;