APPS.PAY_CONTACT_PKG dependencies on DUAL

Line 66: from dual

62: , 'PAYROLL_CONTACT'
63: , p_contact_name
64: , p_phone
65: , p_email
66: from dual
67: where not exists (select 1
68: from per_all_assignments_f paf
69: , per_assignment_extra_info aei
70: where paf.assignment_id = aei.assignment_id

Line 77: from dual;

73: and aei.aei_information_category = 'PAYROLL_CONTACT');
74: --
75: select per_assignment_extra_info_s.currval
76: into l_extra_info_id
77: from dual;
78: --
79: ELSE
80: hr_utility.trace('row found so update');
81: CLOSE c_contact_details;