APPS.PO_ACCEPTANCES_INS_PVT dependencies on DUAL

Line 76: FROM SYS.DUAL;

72: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence
73: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table
74: CURSOR c_next_id IS
75: SELECT PO_ACCEPTANCES_S.nextval
76: FROM SYS.DUAL;
77:
78: BEGIN
79:
80: IF (x_acceptance_id IS NULL) THEN

Line 83: FROM SYS.DUAL;

79:
80: IF (x_acceptance_id IS NULL) THEN
81: SELECT PO_ACCEPTANCES_S.nextval
82: INTO l_id
83: FROM SYS.DUAL;
84: ELSE
85: l_id := x_acceptance_id;
86: END IF;
87: