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: and paf.business_group_id + 0 = p_business_group_id

Line 49: from sys.dual

45: begin
46: hr_utility.set_location(l_proc,30);
47: select 'X'
48: into v_dummy
49: from sys.dual
50: where exists ( select 'Events exist'
51: from per_events pe
52: , per_bookings pb
53: where pe.business_group_id = pb.business_group_id

Line 73: from sys.dual

69: begin
70: hr_utility.set_location(l_proc,40);
71: select 'X'
72: into v_dummy
73: from sys.dual
74: where exists(select 'Interview rows exist'
75: from per_events pe
76: where pe.business_group_id + 0 = p_business_group_id
77: and pe.event_or_interview = 'I'

Line 105: from sys.dual

101: begin
102: hr_utility.set_location(l_proc,50);
103: select 'X'
104: into v_dummy
105: from sys.dual
106: where exists ( select 'Perf Review rows exist'
107: from per_performance_reviews ppr
108: where ppr.person_id = p_person_id
109: and review_date > p_session_date

Line 123: from sys.dual

119: begin
120: hr_utility.set_location(l_proc,60);
121: select 'X'
122: into v_dummy
123: from sys.dual
124: where exists (select 'Recruiter for vacancy'
125: from per_vacancies pv
126: where
127: -- Fix for Bug 3446782 starts here. this condition is taken

Line 2506: FROM dual

2502: hr_utility.set_location(l_proc,1);
2503: BEGIN
2504: SELECT 'Y'
2505: INTO l_action_chk
2506: FROM dual
2507: WHERE exists
2508: (SELECT null
2509: FROM pay_payroll_actions pac,
2510: pay_assignment_actions act,

Line 2526: FROM dual

2522: IF l_action_chk = 'N' THEN
2523: BEGIN
2524: SELECT 'W'
2525: INTO l_action_chk
2526: FROM dual
2527: WHERE exists
2528: (SELECT null
2529: FROM pay_payroll_actions pac,
2530: pay_assignment_actions act,