APPS.OKE_DELIVERABLE_UTILS_PUB dependencies on DUAL

Line 295: FROM dual

291: AND action_type = 'REQ';
292:
293: CURSOR d IS
294: SELECT 1
295: FROM dual
296: WHERE EXISTS ( SELECT 1
297: FROM po_requisitions_interface_all
298: WHERE oke_contract_deliverable_id = p_action_id
299: AND process_flag = 'ERROR');

Line 561: FROM DUAL;

557: END IF;
558:
559: SELECT oke_k_deliverables_s.nextval
560: INTO l_id
561: FROM DUAL;
562:
563: OPEN c;
564: FETCH c INTO L_Deliverable_ID, L_Deliverable_Description, L_Deliverable_Comments;
565: CLOSE c;

Line 1624: SELECT oke_k_deliverables_s.NEXTVAL INTO L_ID FROM DUAL;

1620: AND SOURCE_DELIVERABLE_ID = P_SOURCE_DELIVERABLE_ID;
1621:
1622: BEGIN
1623:
1624: SELECT oke_k_deliverables_s.NEXTVAL INTO L_ID FROM DUAL;
1625:
1626: OPEN c;
1627: FETCH c INTO L_Deliverable_ID;
1628: CLOSE c;