APPS.HR_ASSIGNMENT_SWI dependencies on IRC_ASSIGNMENT_STATUSES

Line 35: l_ias_status_id irc_assignment_statuses.assignment_status_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;
37: l_ias_date irc_assignment_statuses.status_change_date%TYPE;
38: L_ACTIVATE_APL_ASG constant varchar2(30) := 'ACTIVE_APL';
39: L_OFFER_APL_ASG constant varchar2(30) := 'OFFER';

Line 36: l_ias_ovn irc_assignment_statuses.object_version_number%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;
37: l_ias_date irc_assignment_statuses.status_change_date%TYPE;
38: L_ACTIVATE_APL_ASG constant varchar2(30) := 'ACTIVE_APL';
39: L_OFFER_APL_ASG constant varchar2(30) := 'OFFER';
40: L_ACCEPT_APL_ASG constant varchar2(30) := 'ACCEPTED';

Line 37: l_ias_date irc_assignment_statuses.status_change_date%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;
37: l_ias_date irc_assignment_statuses.status_change_date%TYPE;
38: L_ACTIVATE_APL_ASG constant varchar2(30) := 'ACTIVE_APL';
39: L_OFFER_APL_ASG constant varchar2(30) := 'OFFER';
40: L_ACCEPT_APL_ASG constant varchar2(30) := 'ACCEPTED';
41: L_INTERVIEW1_APL_ASG constant varchar2(30) := 'INTERVIEW1';

Line 84: from irc_assignment_statuses ias

80: cursor csr_last_irc_assignment is
81: select ias.assignment_status_id
82: ,ias.object_version_number
83: ,ias.status_change_date
84: from irc_assignment_statuses ias
85: where ias.assignment_id = p_assignment_id
86: and not exists(select null
87: from irc_assignment_statuses
88: where assignment_id = p_assignment_id

Line 87: from irc_assignment_statuses

83: ,ias.status_change_date
84: from irc_assignment_statuses ias
85: where ias.assignment_id = p_assignment_id
86: and not exists(select null
87: from irc_assignment_statuses
88: where assignment_id = p_assignment_id
89: and assignment_status_id > ias.assignment_status_id
90: );
91: --