274. Q. Which are the effects of the Sacrament of Extreme Unction?A. The effects of Extreme Unction are:
1.To comfort us in the pains of sickness and to strengthen us against temptation;
2.To remit venial sins and to cleanse our soul from the remains of sin;
3.To restore us to health, when God sees fit.275. Q. What do you mean by the remains of sin?
A. By the remains of sin I mean the inclination to evil and the weakness of the will which are the result of our sins, and which remain after our sins have been forgiven.
14 Is anyone among you sick? He should summon the presbyters of the church, and they should pray over him and anoint (him) with oil in the name of the Lord,In this passage, "Presbyters" was the word used for "Priests" in the early church. The Sacrament of the Sick is a Sacrament which can be given to people by the priest (some Sacraments require a Bishop like Confirmation).
15 and the prayer of faith will save the sick person, and the Lord will raise him up. If he has committed any sins, he will be forgiven.
Source:New American Bible, Baltimore Catechism