APPS.BOM_DEFAULT_OP_SEQ dependencies on DUAL

Line 47: FROM SYS.DUAL ;

43: FUNCTION Get_Operation_Sequence_Id RETURN NUMBER
44: IS
45: CURSOR l_op_seq_cur IS
46: SELECT Bom_Operation_Sequences_S.NEXTVAL Op_Seq_Id
47: FROM SYS.DUAL ;
48: BEGIN
49: FOR l_op_seq_rec IN l_op_seq_cur LOOP
50: RETURN l_op_seq_rec.Op_Seq_Id ;
51: END LOOP ;

Line 81: FROM SYS.DUAL ;

77:
78:
79: CURSOR l_rtg_seq_csr IS
80: SELECT Bom_Operational_Routings_S.NEXTVAL Rtg_Seq_Id
81: FROM SYS.DUAL ;
82:
83: l_routing_sequence_id NUMBER;
84:
85: BEGIN

Line 146: FROM SYS.DUAL ;

142: /** time **/
143: SELECT SYSDATE -- Changed for bug 2647027
144: -- SELECT TRUNC(SYSDATE)
145: INTO l_current_date
146: FROM SYS.DUAL ;
147:
148: RETURN l_current_date ;
149:
150: END Get_Start_Effective_Date ;

Line 420: FROM DUAL

416: -- Check if the operatin already has resources
417: CURSOR l_exist_res_cur (p_op_seq_id NUMBER)
418: IS
419: SELECT 'Resource Exist'
420: FROM DUAL
421: WHERE EXISTS ( SELECT NULL
422: FROM BOM_OPERATION_RESOURCES
423: WHERE operation_sequence_id = p_op_seq_id
424: ) ;