APPS.IRC_OFFERS_API dependencies on PER_ASSIGNMENT_STATUS_TYPES_V

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 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