APPS.HR_ASSIGNMENT_SWI dependencies on PER_ALL_PEOPLE_F

Line 31: l_person_id per_all_people_f.person_id%TYPE;

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

Line 32: l_ovn per_all_people_f.object_version_number%TYPE;

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

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

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