SQL to find the Navigation for a given Record Name

SELECT  A.PORTAL_URI_SEG2,
RTRIM(E.PORTAL_LABEL)
|| ' >> ' || RTRIM(D.PORTAL_LABEL)
|| ' >> ' || RTRIM(C.PORTAL_LABEL)
|| ' >> ' || RTRIM(B.PORTAL_LABEL)
|| ' >> ' || RTRIM(A.PORTAL_LABEL)
FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME
AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C
ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D
ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E
ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE
A.PORTAL_URI_SEG2 IN (select PNLGRPNAME from PSPNLGROUP WHERE PNLNAME IN (select distinct pnlname from pspnlfield where recname = < RECORD_NAME > ));

What is a fringe benefit?

Fringe Benefit:
Fringe is nothing but an extra/ an edge over something etc.
These are usually paid by employers to the employee to retain the talent pool. Fringe Benefits is a supplemental to employee's salary. Like an Employer can offer Employer Paid Life Insurance to an employee.

Most of the cases , fringe benefits are non-taxable unless until they represent a fair market value.
So these benefits doesn't fall under Employee taxable income. That's the reason the premium deducted in the Pay comes under Pre-Tax.

However, this depends on the  rules set by the IRS (Internal Revenue Service) in US.

Suppose if a coverage limit is set for Life Insurance and if an employers offers more coverage than the coverage limit set by the IRS then the extra perk becomes taxable.

Other examples of Fringe Benefits is like using company provided car, getting stocks etc.

When to go for Partial Position Management.

Good example when to go for Partial Position Mgmnt. Source: Peoplebooks

“If you use PeopleSoft Pension Administration, you track your pension payees—retirees, beneficiaries, and QDRO (qualified domestic relations order) alternate payees—using the same tables that you use to track your workers. You want to drive your retiree organization by person (or in this case, by payee), rather than by position, so that you don't have to establish a different position for each payee in the system. To drive your worker organization by position and your payee organization by person, use the partial position management option.”

By Default, in the installations page, it is set to partial.

What is Person Mgmnt?  We go with this option, if our business has requirement of creating more jobs more often.

What is Position Mgmnt? We go with this option, if our business already defined positions (usually static, say healthcare etc.)and want people filling these positions.