Rehired Employees are Unable to retrieve employment letter using the current user name

Ashok Kumar Sharma

• ---- For example:
Person Number: 187775
Current Username: A187775 (Results in an error)
Old User Name: uakhokh (Fetches data correctly or could download the letter using this old user name)---- Query Segment with Possible Issue:
The following part of the query (at the end) seems to be refencing the
    and papf.PERSON_ID = (Select PERSON_ID from Per_PERSONS
    WHERE person_id = HRC_SESSION_UTIL.get_user_personid)
value, which may not be correctly associated with employee's acual Person ID and could be fetching outdated information
SQL
WHERE person_id = HRC_SESSION_UTIL.get_user_personid---- Error message encountered: When the employee attempts to retrieve employment letter using the current user name (A187775), he gets the error. However query successfuly works and retrieves teh letter when the old username ( uakhokh) is used.----Query:
select papf.person_id 
    ,papf.person_number 
    ,ppnf.first_name||' '||ppnf.last_name "NAME"
    ,TO_CHAR(ppos.ADJUSTED_SVC_DATE,'fmMonth DD, YYYY','NLS_DATE_LANGUAGE = AMERICAN') "HIRE_DATE"
    ,TO_CHAR(SYSDATE,'fmMonth DD, YYYY','NLS_DATE_LANGUAGE = AMERICAN') "CURRENT_DATE"
    ,TO_CHAR(ppos.ADJUSTED_SVC_DATE,'DD fmMonth YYYY','NLS_DATE_LANGUAGE = FRENCH') "FHIRE_DATE"
    ,TO_CHAR(SYSDATE,'DD fmMonth YYYY','NLS_DATE_LANGUAGE = FRENCH') "FCURRENT_D