APPS.HR_ASSIGNMENT_SWI dependencies on PER_ALL_PEOPLE_F

Line 32: l_person_id per_all_people_f.person_id%TYPE;

28: l_new_per_system_status
29: per_assignment_status_types.per_system_status%type;
30: l_assignment_status_type_id
31: per_assignment_status_types.assignment_status_type_id%type;
32: l_person_id per_all_people_f.person_id%TYPE;
33: l_ovn per_all_people_f.object_version_number%TYPE;
34: l_effective_date date;
35: l_num_asg number;
36: l_ias_status_id irc_assignment_statuses.assignment_status_id%TYPE;

Line 33: l_ovn per_all_people_f.object_version_number%TYPE;

29: per_assignment_status_types.per_system_status%type;
30: l_assignment_status_type_id
31: per_assignment_status_types.assignment_status_type_id%type;
32: l_person_id per_all_people_f.person_id%TYPE;
33: l_ovn per_all_people_f.object_version_number%TYPE;
34: l_effective_date date;
35: l_num_asg number;
36: l_ias_status_id irc_assignment_statuses.assignment_status_id%TYPE;
37: l_ias_ovn irc_assignment_statuses.object_version_number%TYPE;

Line 67: Cursor csr_count(p_person_id per_all_people_f.person_id%type) is

63:
64: -- count the number of applicant assignments tomorrow, i.e. the number
65: -- that have not been terminated yet.
66:
67: Cursor csr_count(p_person_id per_all_people_f.person_id%type) is
68: SELECT count(*)
69: FROM per_all_assignments_f asg
70: WHERE asg.person_id=p_person_id
71: AND asg.assignment_type='A'