APPS.IRC_OFFERS_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 376: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;

372: l_curr_assg_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
373: --
374: l_datetrack_mode varchar2(30);
375: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
376: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
377: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
378: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
379: --
380: cursor csr_assignment_ovn is

Line 394: ,per_assignment_status_types past

390: cursor csr_prev_assg_status_type is
391: select ias1.assignment_status_type_id
392: ,past.per_system_status
393: from irc_assignment_statuses ias1
394: ,per_assignment_status_types past
395: where past.assignment_status_type_id = ias1.assignment_status_type_id
396: and ias1.assignment_id = p_applicant_assignment_id
397: and ias1.creation_date = (select max(ias2.creation_date)
398: from irc_assignment_statuses ias2