APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on IRC_ASSIGNMENT_STATUSES

Line 1197: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;

1193: l_assignment_id NUMBER;
1194: l_back2back BOOLEAN;
1195: l_person_type_id NUMBER;
1196: -- Start of fix 3564129
1197: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
1198: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
1199: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1200: -- End of fix 3564129
1201: --

Line 1198: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;

1194: l_back2back BOOLEAN;
1195: l_person_type_id NUMBER;
1196: -- Start of fix 3564129
1197: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
1198: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
1199: l_asg_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1200: -- End of fix 3564129
1201: --
1202: -- supervisor cursor.

Line 1327: from irc_assignment_statuses iass

1323: -- Start of fix 3564129
1324: -- Cusror for iRecruitment assignment status
1325: cursor irc_asg_status is
1326: select iass.assignment_status_id, iass.object_version_number
1327: from irc_assignment_statuses iass
1328: where iass.assignment_status_id =
1329: (select max(iass.assignment_status_id)
1330: from irc_assignment_statuses iass
1331: where iass.assignment_id = l_assignment_id

Line 1330: from irc_assignment_statuses iass

1326: select iass.assignment_status_id, iass.object_version_number
1327: from irc_assignment_statuses iass
1328: where iass.assignment_status_id =
1329: (select max(iass.assignment_status_id)
1330: from irc_assignment_statuses iass
1331: where iass.assignment_id = l_assignment_id
1332: and iass.assignment_status_type_id = l_asg_status_type_id);
1333: -- End of fix 3564129
1334: --