APPS.IRC_OFFERS_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 378: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;

374: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
375: --
376: l_datetrack_mode varchar2(30);
377: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
378: l_expected_system_status per_assignment_status_types.per_system_status%TYPE;
379: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
380: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
381: l_base_asg_id per_all_assignments_f.assignment_id%TYPE;
382: --

Line 397: from PER_ASSIGNMENT_STATUS_TYPES_V

393: --
394: --
395: cursor csr_get_offer_user_status(p_business_group_id number) is
396: select ASSIGNMENT_STATUS_TYPE_ID
397: from PER_ASSIGNMENT_STATUS_TYPES_V
398: where PER_SYSTEM_STATUS='OFFER'
399: and DEFAULT_FLAG = 'Y'
400: and BUSINESS_GROUP_ID = p_business_group_id;
401: --

Line 404: from PER_ASSIGNMENT_STATUS_TYPES_V

400: and BUSINESS_GROUP_ID = p_business_group_id;
401: --
402: cursor csr_get_accepted_user_status(p_business_group_id number) is
403: select ASSIGNMENT_STATUS_TYPE_ID
404: from PER_ASSIGNMENT_STATUS_TYPES_V
405: where PER_SYSTEM_STATUS='ACCEPTED'
406: and DEFAULT_FLAG = 'Y'
407: and BUSINESS_GROUP_ID = p_business_group_id;
408: --

Line 413: ,per_assignment_status_types past

409: cursor csr_prev_assg_status_type(p_business_group_id number) is
410: select ias1.assignment_status_type_id
411: ,past.per_system_status
412: from irc_assignment_statuses ias1
413: ,per_assignment_status_types past
414: where past.assignment_status_type_id = ias1.assignment_status_type_id
415: and ias1.assignment_id = p_applicant_assignment_id
416: and ias1.creation_date = (select max(ias2.creation_date)
417: from irc_assignment_statuses ias2

Line 421: from PER_ASSIGNMENT_STATUS_TYPES_V

417: from irc_assignment_statuses ias2
418: where ias2.assignment_id = p_applicant_assignment_id
419: and ias2.assignment_status_type_id not in (5,6)
420: and ias2.assignment_status_type_id not in (select ASSIGNMENT_STATUS_TYPE_ID
421: from PER_ASSIGNMENT_STATUS_TYPES_V
422: where PER_SYSTEM_STATUS in ('OFFER','ACCEPTED')
423: and BUSINESS_GROUP_ID = p_business_group_id));
424: --
425: cursor csr_linked_base_asg is