This query returns the SCREEN_ENTRY_VALUE from PAY_ELEMENT_ENTRY_VALUES_F by joining element entries, element types, and input values tables.
SELECT PEEVFF4.SCREEN_ENTRY_VALUE
FROM PAY_ELEMENT_ENTRIES_F PEEFF1,
PAY_ELEMENT_TYPES_F PETFF2,
PAY_INPUT_VALUES_F PIVFF3,
PAY_ELEMENT_ENTRY_VALUES_F PEEVFF4,
pay_entry_usages peus5,
pay_rel_groups_dn prgdn6
WHERE
1=1
AND PEEFF1.ELEMENT_TYPE_ID = PETFF2.ELEMENT_TYPE_ID
--AND PETFF2.BASE_ELEMENT_NAME like ('Put your Element Name Here')
AND PETFF2.ELEMENT_TYPE_ID = PIVFF3.ELEMENT_TYPE_ID
AND PIVFF3.BASE_NAME IN ('Amount','Total_Amount')
AND PEEFF1.ELEMENT_ENTRY_ID = PEEVFF4.ELEMENT_ENTRY_ID
AND PIVFF3.INPUT_VALUE_ID = PEEVFF4.INPUT_VALUE_ID
--AND prgdn6.ASSIGNMENT_ID = :{PARAMETER.ASG_ID}
and PEEFF1.ELEMENT_ENTRY_ID = peus5.ELEMENT_ENTRY_ID
and peus5.payroll_assignment_id = prgdn6.relationship_group_id
AND ROWNUM = 1
Output Results
