APPS.PER_ASSIGNMENTS_V7_PKG dependencies on DUAL

Line 92: CURSOR C2 IS SELECT per_assignments_s.nextval FROM sys.dual;

88: X_Title VARCHAR2
89: ) IS
90: CURSOR C IS SELECT rowid FROM PER_ASSIGNMENTS_F
91: WHERE assignment_id = X_Assignment_Id;
92: CURSOR C2 IS SELECT per_assignments_s.nextval FROM sys.dual;
93: cursor c3 is
94: select past.assignment_status_type_id
95: from per_assignment_status_types past
96: , per_ass_status_type_amends pasa

Line 1061: from sys.dual

1057: IS
1058: cursor primary_exists
1059: is
1060: select 'Y'
1061: from sys.dual
1062: where exists (select 1 from
1063: per_assignments_f
1064: where person_id =X_person_id
1065: and sysdate between effective_start_date