DBA Data[Home] [Help]

APPS.PAY_DK_EMP_TRAINEE_REIMBURSE dependencies on PAY_BALANCE_TYPES

Line 237: FROM PAY_BALANCE_TYPES PBT

233: -- Cursor to fetch the defined balance id for the given balance and dimension name.
234: CURSOR C2 (BAL_NAME VARCHAR2, DIM_NAME VARCHAR2)
235: IS
236: SELECT DEFINED_BALANCE_ID
237: FROM PAY_BALANCE_TYPES PBT
238: , PAY_DEFINED_BALANCES PDB
239: , PAY_BALANCE_DIMENSIONS PBD
240: WHERE PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
241: AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID