APPS.PER_APP_ASG_PKG dependencies on DUAL

Line 54: from sys.dual

50: --
51: BEGIN
52: select 'Y'
53: into p_del_flag
54: from sys.dual
55: where exists (
56: select null
57: from per_assignment_budget_values_f
58: where assignment_id = p_assignment_id

Line 207: from sys.dual;

203: p_supervisor_assignment_id number default null
204: ) is
205: cursor c1 is
206: select per_assignments_s.nextval
207: from sys.dual;
208: cursor c2 is
209: select rowid
210: from per_assignments_f
211: where assignment_id = P_ASSIGNMENT_ID

Line 1812: from sys.dual

1808: l_max_end_date date := p_max_end_date ;
1809: --
1810: cursor c1 is
1811: select 1
1812: from sys.dual
1813: where exists ( select 1
1814: from per_assignments_f
1815: where assignment_id <> p_assignment_id ) ;
1816: --