APPS.AHL_PP_RESRC_ASSIGN_PVT dependencies on DUAL

Line 1021: SELECT 1 FROM dual

1017: )
1018: IS
1019: -- Check to see schedule Resource id exists
1020: CURSOR Sch_id_exists (x_id IN NUMBER) IS
1021: SELECT 1 FROM dual
1022: WHERE EXISTS (SELECT 1
1023: FROM AHL_WORK_ASSIGNMENTS
1024: WHERE ASSIGNMENT_ID = x_id);
1025:

Line 1827: INTO l_assignment_id FROM DUAL;

1823:
1824: --
1825: -- Get Sequence Number for Resource Assignment ID
1826: SELECT AHL_WORK_ASSIGNMENTS_S.NEXTVAL
1827: INTO l_assignment_id FROM DUAL;
1828:
1829: --Check for Record Exists
1830: OPEN Sch_id_exists(l_assignment_id);
1831: FETCH Sch_id_exists INTO l_dummy;