APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on DUAL

Line 231: FROM dual

227: SELECT asg.assignment_id
228: FROM per_all_assignments_f asg,
229: (
230: SELECT p_organization_id AS organization_id
231: FROM dual
232: UNION ALL
233: SELECT x.sub_organization_id AS organization_id
234: FROM per_org_hrchy_summary x,
235: per_org_structure_versions v,

Line 786: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;

782: BEGIN
783: hr_utility.set_location('Entering:'||l_proc, 5);
784:
785: -- Get the next item key from the sequence
786: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
787:
788: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
789:
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);