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 202: update per_applications

198: and effective_start_date=l_hire_date;
199: --
200: l_per_object_version_number:=l_per_object_version_number+1;
201: --
202: update per_applications
203: set date_received=l_hire_date-1
204: where person_id=p_person_id
205: and date_received=l_hire_date;
206: --

Line 608: update per_applications

604: --
605: -- the application may need moving
606: --
607: begin
608: update per_applications
609: set date_received=l_hire_date-1
610: where person_id=p_person_id
611: and date_received=l_hire_date;
612: exception

Line 677: update per_applications

673: --
674: -- the application may need moving
675: --
676: begin
677: update per_applications
678: set date_received=l_hire_date-1
679: where person_id=p_person_id
680: and date_received=l_hire_date;
681: exception