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