APPS.AHL_OSP_ORDERS_PVT dependencies on DUAL

Line 3966: FROM sys.dual;

3962:
3963: --Generate the primary key
3964: SELECT ahl_osp_orders_b_s.NEXTVAL
3965: INTO l_osp_order_id
3966: FROM sys.dual;
3967: --If there is no records in the table, then max(osp_order_number) IS null
3968: --SELECT NVL(MAX(osp_order_number), l_osp_order_id-1)+1
3969: -- INTO l_osp_order_number
3970: -- FROM ahl_osp_orders_b;

Line 4472: FROM sys.dual;

4468:
4469: --Generate the primary key
4470: SELECT ahl_osp_order_lines_s.NEXTVAL
4471: INTO l_osp_line_id
4472: FROM sys.dual;
4473:
4474: --Generate the line number
4475: --NOTE: This logic to generate osp_line number will probably violate the unique
4476: --index defined on osp_line_number if two concurrent users try to add osp order line