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 1066: from sys.dual

1062: IS
1063: cursor primary_exists
1064: is
1065: select 'Y'
1066: from sys.dual
1067: where exists (select 1 from
1068: per_assignments_f
1069: where person_id =X_person_id
1070: and X_eff_dt between effective_start_date