VIEW: APPS.BEN_CNTPT_EE_VALUE_AND_NAME_V

Source

View Text - Preformatted

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.input_value_id = i.input_value_id 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 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 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 and a.result_value is not null

View Text - HTML Formatted

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.INPUT_VALUE_ID = I.INPUT_VALUE_ID
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 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 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
AND A.RESULT_VALUE IS NOT NULL