View: BEN_EE_VALUE_AND_NAME_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_EE_VALUE_AND_NAME_V

View Text

SELECT A.RESULT_VALUE
, B.ELEMENT_NAME
, E.DATE_EARNED
, C.PERSON_ID
, I.ACTY_BASE_RT_ID
FROM PAY_RUN_RESULT_VALUES A
, PAY_ELEMENT_TYPES_F B
, PER_ASSIGNMENTS_F C
, PAY_ASSIGNMENT_ACTIONS D
, PAY_PAYROLL_ACTIONS E
, PAY_PAYROLLS_F F
, PER_TIME_PERIODS G
, PAY_RUN_RESULTS H
, BEN_ACTY_BASE_RT_F I
, PAY_INPUT_VALUES_F J
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND C.ASSIGNMENT_ID = D.ASSIGNMENT_ID
AND C.PRIMARY_FLAG = 'Y'
AND D.PAYROLL_ACTION_ID = E.PAYROLL_ACTION_ID
AND C.PAYROLL_ID = F.PAYROLL_ID
AND B.ELEMENT_TYPE_ID = J.ELEMENT_TYPE_ID
AND J.UOM = 'M'
AND I.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
AND SE.EFFECTIVE_DATE BETWEEN F.EFFECTIVE_START_DATE
AND F.EFFECTIVE_END_DATE
AND F.PAYROLL_ID = G.PAYROLL_ID
AND SE.EFFECTIVE_DATE BETWEEN G.START_DATE
AND G.END_DATE
AND B.ELEMENT_TYPE_ID = H.ELEMENT_TYPE_ID
AND D.ASSIGNMENT_ACTION_ID = H.ASSIGNMENT_ACTION_ID
AND E.DATE_EARNED BETWEEN G.START_DATE
AND G.END_DATE
AND A.INPUT_VALUE_ID = J.INPUT_VALUE_ID
AND A.RUN_RESULT_ID = H.RUN_RESULT_ID
AND A.RESULT_VALUE IS NOT NULL
AND SE.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN C.EFFECTIVE_START_DATE
AND C.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN I.EFFECTIVE_START_DATE
AND I.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN J.EFFECTIVE_START_DATE
AND J.EFFECTIVE_END_DATE

Columns