APPS.PER_DB_PER_ADDITIONAL dependencies on PER_APPLICATIONS

Line 241: SELECT per_applications_s.nextval

237: begin
238: --
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);

Line 259: INSERT INTO per_applications

255: WHERE pp.person_id = p_person_id
256: AND pp.current_applicant_flag = 'Y');
257: --
258: hr_utility.set_location('per_db_per_additional.insert_application',5);
259: INSERT INTO per_applications
260: (application_id
261: ,business_group_id
262: ,person_id
263: ,date_received

Line 579: FROM per_applications

575: nvl(actual_termination_date,to_date('4712/12/31','YYYY/MM/DD'));
576: else -- Applicant
577: SELECT application_id
578: INTO l_application_id
579: FROM per_applications
580: WHERE person_id = p_person_id
581: AND p_effective_start_date BETWEEN date_received AND
582: nvl(date_end,to_date('4712/12/31','YYYY/MM/DD'))
583: AND p_effective_end_date <=