APPS.HR_INTERVIEW dependencies on DUAL

Line 106: FROM sys.dual

102: hr_utility.set_location('hr_interview.insert_interview',2);
103: --
104: SELECT 'Y'
105: INTO p_dummy
106: FROM sys.dual
107: WHERE EXISTS
108: ( SELECT '1'
109: FROM per_assignments_f
110: WHERE assignment_id = p_assignment_id

Line 853: FROM sys.dual

849: hr_utility.set_location('hr_interview.update_interview',2);
850: --
851: SELECT 'Y'
852: INTO p_no_update
853: FROM sys.dual
854: WHERE EXISTS
855: (SELECT '1'
856: FROM per_assignments_f a
857: WHERE a.assignment_id = p_assignment_id

Line 977: FROM sys.dual

973: BEGIN
974: --
975: SELECT 'Y'
976: INTO p_no_update
977: FROM sys.dual
978: WHERE EXISTS
979: (SELECT '1'
980: FROM per_assignments_f a
981: WHERE a.assignment_id = p_assignment_id