APPS.AHL_OSP_ORDERS_PVT dependencies on DUAL

Line 4308: FROM sys.dual;

4304:
4305: --Generate the primary key
4306: SELECT ahl_osp_orders_b_s.NEXTVAL
4307: INTO l_osp_order_id
4308: FROM sys.dual;
4309: --If there is no records in the table, then max(osp_order_number) IS null
4310: --SELECT NVL(MAX(osp_order_number), l_osp_order_id-1)+1
4311: -- INTO l_osp_order_number
4312: -- FROM ahl_osp_orders_b;

Line 4814: FROM sys.dual;

4810:
4811: --Generate the primary key
4812: SELECT ahl_osp_order_lines_s.NEXTVAL
4813: INTO l_osp_line_id
4814: FROM sys.dual;
4815:
4816: --Generate the line number
4817: --NOTE: This logic to generate osp_line number will probably violate the unique
4818: --index defined on osp_line_number if two concurrent users try to add osp order line