Dúvida Oracle AME (Approvals Managment)

FUNCTION GET_APPROVER(P_TRANSACTION_ID NUMBER ) RETURN T_APPROVER_RETURN PIPELINED IS

—

            SELECT PAPF.PERSON_ID

              INTO P_APPROVER_ID

              FROM PER_ALL_PEOPLE_F      PAPF

                  ,PER_ALL_ASSIGNMENTS_F PAAF

                  ,HR_ALL_POSITIONS_F    HAPF

             WHERE HAPF.POSITION_ID = P_POSITION_ID

               AND PAPF.PERSON_ID = PAAF.PERSON_ID

               AND PAAF.POSITION_ID = HAPF.POSITION_ID

               AND trunc(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE

               AND trunc(SYSDATE) BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE

               AND EXISTS (SELECT EMPLOYEE_ID

                      FROM FND_USER FU

                     WHERE FU.EMPLOYEE_ID = PAPF.PERSON_ID

                       AND NVL(FU.END_DATE, trunc(SYSDATE) + 1) > trunc(SYSDATE));