Use this query in SQL Developer

The Two Ewes Driver enables you to run this query directly against your Oracle Fusion Applications, right from SQL Developer. Give it a try right now with a no obligation trial period.

Contributed By

Two Ewes

Send Email

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 ;