APPS.HR_ASSIGNMENT_SWI dependencies on IRC_ASSIGNMENT_STATUSES

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

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

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

Line 90: from irc_assignment_statuses ias

86: cursor csr_last_irc_assignment is
87: select ias.assignment_status_id
88: ,ias.object_version_number
89: ,ias.status_change_date
90: from irc_assignment_statuses ias
91: where ias.assignment_id = p_assignment_id
92: and not exists(select null
93: from irc_assignment_statuses
94: where assignment_id = p_assignment_id

Line 93: from irc_assignment_statuses

89: ,ias.status_change_date
90: from irc_assignment_statuses ias
91: where ias.assignment_id = p_assignment_id
92: and not exists(select null
93: from irc_assignment_statuses
94: where assignment_id = p_assignment_id
95: and assignment_status_id > ias.assignment_status_id
96: );
97: --