-
-

Which balances does my element feed

ELEMENTS

Query returns information similar to Element Description form Balance Feeds button.

SELECT substr(BT.BALANCE_NAME,1,20) bal_name , substr(BF.EFFECTIVE_START_DATE,1,15) start_date , substr(BF.EFFECTIVE_END_DATE,1,15) end_date , substr(IV.NAME,1,15) INPUT_VAL_NAME , substr(HL.MEANING,1,10) ADD_OR_SUBTR , substr(HL2.MEANING,1,10) UOM FROM PAY_BALANCE_FEEDS_F BF , PAY_BALANCE_TYPES BT , PAY_INPUT_VALUES_F IV , PAY_ELEMENT_TYPES_F ET , HR_LOOKUPS HL , HR_LOOKUPS HL2 WHERE ET.ELEMENT_NAME = <&element_name> AND BT.BALANCE_TYPE_ID = BF.BALANCE_TYPE_ID AND IV.INPUT_VALUE_ID = BF.INPUT_VALUE_ID AND ET.ELEMENT_TYPE_ID = IV.ELEMENT_TYPE_ID AND HL.LOOKUP_TYPE = 'ADD_SUBTRACT' AND HL.LOOKUP_CODE = BF.SCALE AND HL2.LOOKUP_TYPE = 'UNITS' AND HL2.LOOKUP_CODE = IV.UOM AND sysdate BETWEEN BF.EFFECTIVE_START_DATE AND BF.EFFECTIVE_END_DATE AND sysdate BETWEEN IV.EFFECTIVE_START_DATE AND IV.EFFECTIVE_END_DATE AND sysdate BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE ;