APPS.OZF_APPROVAL_PVT dependencies on DUAL

Line 708: FROM dual;

704: l_workflow_itemkey VARCHAR2(80);
705:
706: CURSOR c_id IS
707: SELECT ozf_approval_access_s.NEXTVAL
708: FROM dual;
709:
710: BEGIN
711: -- Standard begin of API savepoint
712: SAVEPOINT Add_Access_PVT;

Line 1376: -- '(:itemtype, :entity_id, :usertype, :status) FROM dual'

1372:
1373: -- execute callback api to get users to send notification
1374: -- BUG 5058027 (+)
1375: -- EXECUTE IMMEDIATE 'SELECT ' || l_user_callback_api ||
1376: -- '(:itemtype, :entity_id, :usertype, :status) FROM dual'
1377: -- INTO l_role_list
1378: -- USING l_object_type, l_object_id, l_user_type, l_status ;
1379:
1380: -- l_execute_str := 'BEGIN ' ||

Line 1388: '(:itemtype, :entity_id, :usertype, :status) FROM dual'

1384: --
1385: -- Bug 5534346: Undone above changes - callback to a function doesnt work this way
1386:
1387: EXECUTE IMMEDIATE 'SELECT ' || l_user_callback_api ||
1388: '(:itemtype, :entity_id, :usertype, :status) FROM dual'
1389: INTO l_role_list
1390: USING l_object_type, l_object_id, l_user_type, l_status ;
1391:
1392: -- execute pre-defined user list criterias

Line 2613: FROM dual;

2609: l_insert_mode VARCHAR2(1) := 'N';
2610:
2611: CURSOR c_id IS
2612: SELECT OZF_SD_REQUEST_ACCESS_S.NEXTVAL
2613: FROM dual;
2614:
2615: CURSOR CSR_EXISTING_OWNER (p_object_id IN NUMBER) IS
2616: SELECT resource_id, user_id, approver_flag, object_version_number
2617: FROM OZF_SD_REQUEST_ACCESS