APPS.PO_CREATE_REQUISITION_SV dependencies on DUAL

Line 668: FROM sys.dual;

664:
665: -- Cursor to get unique Requisition_Header_ID
666: CURSOR req_header_id_cur IS
667: SELECT po_requisition_headers_s.nextval
668: FROM sys.dual;
669:
670: -- Cursor to get unique Requisition_Line_ID
671: CURSOR req_line_id_cur IS
672: SELECT po_requisition_lines_s.nextval

Line 673: FROM sys.dual;

669:
670: -- Cursor to get unique Requisition_Line_ID
671: CURSOR req_line_id_cur IS
672: SELECT po_requisition_lines_s.nextval
673: FROM sys.dual;
674:
675: -- Cursor to get unique Distribution_id
676: CURSOR dist_line_id_cur IS
677: SELECT po_req_distributions_s.nextval

Line 678: FROM sys.dual;

674:
675: -- Cursor to get unique Distribution_id
676: CURSOR dist_line_id_cur IS
677: SELECT po_req_distributions_s.nextval
678: FROM sys.dual;
679:
680: -- Cursor to get Accrual Account ID and Variance Account ID
681: -- For Destination Type Code INVENTORY get accrual account id
682: -- from MTL_PARAMETERS

Line 805: SELECT Sysdate INTO l_today FROM dual;

801: l_header_rec := px_header_rec;
802: l_line_tbl := px_line_table;
803:
804: -- get all the values required to insert into po_requisition_header table
805: SELECT Sysdate INTO l_today FROM dual;
806:
807: l_user_id := fnd_global.user_id;
808: l_login_id := fnd_global.login_id;
809:

Line 826: FROM DUAL

822: -- check for uniqueness of requisition_number
823: BEGIN
824:
825: SELECT 'X' INTO l_dummy
826: FROM DUAL
827: WHERE NOT EXISTS
828: ( SELECT 'X'
829: FROM po_requisition_headers
830: WHERE Segment1 = l_header_rec.segment1);