APPS.PER_QH_ACTION dependencies on PER_APPLICATIONS

Line 34: l_application_id per_applications.application_id%TYPE;

30: l_system_person_type per_person_types.system_person_type%TYPE;
31: l_system_person_type2 per_person_types.system_person_type%TYPE;
32: l_business_group_id per_all_people_f.business_group_id%TYPE;
33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;
36: l_per_effective_start_date per_all_people_f.effective_start_date%type;
37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;
38: l_per_effective_end_date per_all_people_f.effective_end_date%type;

Line 35: l_apl_object_version_number per_applications.application_id%TYPE;

31: l_system_person_type2 per_person_types.system_person_type%TYPE;
32: l_business_group_id per_all_people_f.business_group_id%TYPE;
33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;
36: l_per_effective_start_date per_all_people_f.effective_start_date%type;
37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;
38: l_per_effective_end_date per_all_people_f.effective_end_date%type;
39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;

Line 227: update per_applications

223: and effective_start_date=l_hire_date;
224: --
225: l_per_object_version_number:=l_per_object_version_number+1;
226: --
227: update per_applications
228: set date_received=l_hire_date-1
229: where person_id=p_person_id
230: and date_received=l_hire_date;
231: --

Line 633: update per_applications

629: --
630: -- the application may need moving
631: --
632: begin
633: update per_applications
634: set date_received=l_hire_date-1
635: where person_id=p_person_id
636: and date_received=l_hire_date;
637: exception

Line 702: update per_applications

698: --
699: -- the application may need moving
700: --
701: begin
702: update per_applications
703: set date_received=l_hire_date-1
704: where person_id=p_person_id
705: and date_received=l_hire_date;
706: exception