APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on DUAL

Line 549: FROM dual

545: SELECT asg.assignment_id
546: FROM per_all_assignments_f asg,
547: (
548: SELECT p_organization_id AS organization_id
549: FROM dual
550: UNION ALL
551: SELECT x.sub_organization_id AS organization_id
552: FROM per_org_hrchy_summary x,
553: per_org_structure_versions v,

Line 582: FROM DUAL) o,

578: START WITH o.organization_id_parent = p_organization_id
579: AND o.org_structure_version_id = p_org_structure_version_id
580: UNION
581: SELECT p_organization_id organization_id_child
582: FROM DUAL) o,
583: hr_organization_units org
584: WHERE o.organization_id_child = org.organization_id)orgs
585: WHERE asg.person_id = p_person_id AND
586: asg.organization_id = orgs.organization_id AND

Line 749: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;

745: l_proc varchar2(72) := g_package||'create_request_member_record';
746:
747: l_person_action_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type := NULL;
748:
749: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
750:
751: BEGIN
752:
753: hr_utility.set_location(' Entering:'||l_proc, 5);

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

2071: BEGIN
2072: hr_utility.set_location('Entering:'||l_proc, 5);
2073:
2074: -- Get the next item key from the sequence
2075: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
2076:
2077: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, p_process);
2078:
2079: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);

Line 3057: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;

3053: l_proc varchar2(72) := g_package||'create_cert_req_member_record';
3054:
3055: l_person_action_id OTA_MAND_MULTI_ENR_REQ_MEMBERS.PERSON_ACTION_ID%type := NULL;
3056:
3057: Cursor C_Sel1 is select OTA_PERSON_ACTIONS_S.nextval from sys.dual;
3058:
3059: BEGIN
3060:
3061: hr_utility.set_location(' Entering:'||l_proc, 5);