APPS.IRC_NOTIFICATION_DATA_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 498: from PER_ASSIGNMENT_STATUS_TYPES_V

494: || per_system_status
495: || ';IRC_APPL_NEW_EXTERNAL_STATUS:'
496: || external_status
497: || ';'
498: from PER_ASSIGNMENT_STATUS_TYPES_V
499: where ASSIGNMENT_STATUS_TYPE_ID = c_assignmentStatusCode;
500: l_applicationExtStatus varchar2(500);
501: l_func_name varchar2(50) := 'getApplicationExtStatus';
502: begin

Line 527: from PER_ASSIGNMENT_STATUS_TYPES

523: || per_system_status
524: || ';IRC_JOB_APPL_NEW_USER_STATUS:'
525: || user_status
526: || ';'
527: from PER_ASSIGNMENT_STATUS_TYPES
528: where ASSIGNMENT_STATUS_TYPE_ID = c_assignmentStatusCode;
529: l_applicationStatus varchar2(500);
530: l_func varchar2(50) := 'getApplicationStatus';
531: begin

Line 584: from PER_ASSIGNMENT_STATUS_TYPES_V

580: cursor csrApplicationOldExtStatus (c_assignmentOldStatusCode in number) is
581: select 'IRC_JOB_APPL_OLD_STATUS:'
582: || external_status
583: || ';'
584: from PER_ASSIGNMENT_STATUS_TYPES_V
585: where ASSIGNMENT_STATUS_TYPE_ID = c_assignmentOldStatusCode;
586: l_applicationOldExtStatus varchar2(500);
587: l_func_name varchar2(50) := 'getApplicationOldExtStatus';
588: begin