APPS.PER_APP_ASG_PKG dependencies on DUAL

Line 51: from sys.dual

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

Line 200: from sys.dual;

196: p_supervisor_assignment_id number default null
197: ) is
198: cursor c1 is
199: select per_assignments_s.nextval
200: from sys.dual;
201: cursor c2 is
202: select rowid
203: from per_assignments_f
204: where assignment_id = P_ASSIGNMENT_ID

Line 1613: from sys.dual

1609: l_max_end_date date := p_max_end_date ;
1610: --
1611: cursor c1 is
1612: select 1
1613: from sys.dual
1614: where exists ( select 1
1615: from per_assignments_f
1616: where assignment_id <> p_assignment_id ) ;
1617: --