APPS.PER_DB_PER_ADDITIONAL dependencies on DUAL

Line 141: FROM sys.dual;

137: --
138: hr_utility.set_location('per_db_per_additional.insert_period_of_service',1);
139: SELECT per_periods_of_service_s.nextval
140: INTO l_period_of_service_id
141: FROM sys.dual;
142: --
143: hr_utility.set_location('per_db_per_additional.insert_period_of_service',2);
144: --
145: -- Note : this check will only work for NEW employees - ie no

Line 150: FROM sys.dual

146: -- previous periods of service.
147: --
148: SELECT 'Y'
149: INTO l_emp_check
150: FROM sys.dual
151: WHERE p_date_start = (SELECT min(effective_start_date)
152: FROM per_people_f pp
153: WHERE pp.person_id = p_person_id
154: AND pp.current_employee_flag = 'Y');

Line 243: FROM sys.dual;

239: --
240: hr_utility.set_location('per_db_per_additional.insert_application',1);
241: SELECT per_applications_s.nextval
242: INTO l_application_id
243: FROM sys.dual;
244: --
245: hr_utility.set_location('per_db_per_additional.insert_application',2);
246: --
247: -- Note : this check will only work for NEW applicants - ie no

Line 252: FROM sys.dual

248: -- previous applications .
249: --
250: SELECT 'Y'
251: INTO l_apl_check
252: FROM sys.dual
253: WHERE p_date_received = (SELECT min(effective_start_date)
254: FROM per_people_f pp
255: WHERE pp.person_id = p_person_id
256: AND pp.current_applicant_flag = 'Y');

Line 341: FROM sys.dual;

337: l_employee_number := p_employee_number;
338: --
339: SELECT per_people_s.nextval
340: INTO l_person_id
341: FROM sys.dual;
342: --
343: hr_utility.set_location('per_db_per_additional.insert_person',2);
344: hr_person.validate_national_identifier(p_national_identifier,
345: l_person_id,

Line 742: FROM sys.dual;

738: else
739: hr_utility.set_location('per_db_per_additional.insert_assignment',35);
740: SELECT per_letter_requests_s.nextval
741: INTO l_letter_request_id
742: FROM sys.dual;
743: --
744: hr_utility.set_location('per_db_per_additional.insert_assignment',40);
745: INSERT INTO per_letter_requests
746: (letter_request_id

Line 2281: FROM sys.dual;

2277: --
2278: hr_utility.set_location('per_db_per_additional.create_contact',7);
2279: SELECT per_contact_relationships_s.nextval
2280: INTO l_contact_relationship_id
2281: FROM sys.dual;
2282: --
2283: --
2284: hr_utility.set_location('per_db_per_additional.create_contact',8);
2285: INSERT INTO per_contact_relationships