APPS.HR_EX_EMPLOYEE_API dependencies on DUAL

Line 28: from sys.dual

24: begin
25: hr_utility.set_location(l_proc,10);
26: Select 'X'
27: into v_dummy
28: from sys.dual
29: where exists (select 'Assignments Exist'
30: from per_assignments_f paf
31: where paf.supervisor_id = p_person_id
32: -- Code changes for Bug#13869378 Starts here

Line 72: from sys.dual

68: begin
69: hr_utility.set_location(l_proc,30);
70: select 'X'
71: into v_dummy
72: from sys.dual
73: where exists ( select 'Events exist'
74: from per_events pe
75: , per_bookings pb
76: where pe.business_group_id = pb.business_group_id

Line 96: from sys.dual

92: begin
93: hr_utility.set_location(l_proc,40);
94: select 'X'
95: into v_dummy
96: from sys.dual
97: where exists(select 'Interview rows exist'
98: from per_events pe
99: where pe.business_group_id + 0 = p_business_group_id
100: and pe.event_or_interview = 'I'

Line 128: from sys.dual

124: begin
125: hr_utility.set_location(l_proc,50);
126: select 'X'
127: into v_dummy
128: from sys.dual
129: where exists ( select 'Perf Review rows exist'
130: from per_performance_reviews ppr
131: where ppr.person_id = p_person_id
132: and review_date > p_session_date

Line 146: from sys.dual

142: begin
143: hr_utility.set_location(l_proc,60);
144: select 'X'
145: into v_dummy
146: from sys.dual
147: where exists (select 'Recruiter for vacancy'
148: from per_vacancies pv
149: where
150: -- Fix for Bug 3446782 starts here. this condition is taken

Line 2797: FROM dual

2793: hr_utility.set_location(l_proc,1);
2794: BEGIN
2795: SELECT 'Y'
2796: INTO l_action_chk
2797: FROM dual
2798: WHERE exists
2799: (SELECT null
2800: FROM pay_payroll_actions pac,
2801: pay_assignment_actions act,

Line 2817: FROM dual

2813: IF l_action_chk = 'N' THEN
2814: BEGIN
2815: SELECT 'W'
2816: INTO l_action_chk
2817: FROM dual
2818: WHERE exists
2819: (SELECT null
2820: FROM pay_payroll_actions pac,
2821: pay_assignment_actions act,