APPS.POS_WC_CREATE_UPDATE_PVT dependencies on DUAL

Line 512: SELECT sysdate INTO l_request_date FROM DUAL;

508: RSL.SHIPMENT_LINE_ID = p_wc_pay_item_id;
509:
510: ELSIF(p_wc_stage = 'PO') THEN
511:
512: SELECT sysdate INTO l_request_date FROM DUAL;
513:
514: END IF;
515: if(l_wc_status = 'DRAFT') THEN
516: l_request_date := sysdate ;

Line 686: from sys.dual;

682: --2)Kick off the workflow again
683:
684: select to_char(PO_WF_ITEMKEY_S.NEXTVAL)
685: into l_seq_for_item_key
686: from sys.dual;
687:
688: l_itemkey := to_char(p_wc_header_id) || '-' ||
689: l_seq_for_item_key;
690:

Line 1190: from dual;

1186: FOR i IN 1..2 LOOP
1187:
1188: select rcv_transactions_interface_s.nextval
1189: into l_interface_id
1190: from dual;
1191:
1192: IF (i = 1) THEN
1193:
1194: l_transaction_type := 'DELIVER';