View: HR_PAY_INTERFACE_OAB_OPTION_V

Product:	PER - Human Resources
Description:	Payroll interface toolkit view
Implementation/DBA Data:	APPS.HR_PAY_INTERFACE_OAB_OPTION_V

View Text

SELECT OPT.NAME
, COP.PL_ID
, COP.OIPL_ID
, GREATEST(NVL(COP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, OPT.EFFECTIVE_START_DATE)
, COP.EFFECTIVE_START_DATE
, COP.EFFECTIVE_END_DATE
FROM BEN_OPT_F OPT
, BEN_OIPL_F COP
WHERE OPT.OPT_ID = COP.OPT_ID
AND COP.EFFECTIVE_START_DATE = (SELECT MAX(COP1.EFFECTIVE_START_DATE)
FROM BEN_OIPL_F COP1
WHERE COP1.OIPL_ID = COP.OIPL_ID
AND COP1.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE )
AND OPT.EFFECTIVE_START_DATE = (SELECT MAX(OPT1.EFFECTIVE_START_DATE)
FROM BEN_OPT_F OPT1
WHERE OPT1.OPT_ID = OPT.OPT_ID
AND OPT1.EFFECTIVE_START_DATE <= HR_PAY_INTERFACE_PKG.GET_EXTRACT_DATE )

Columns