DBA Data[Home] [Help]

APPS.HR_JPDRB dependencies on PAY_BALANCE_DIMENSIONS

Line 66: FROM pay_balance_dimensions DIM,

62: --
63: cursor balance_dimension
64: is
65: SELECT RTRIM(SUBSTRB(DIM.dimension_name,31,15),' ')
66: FROM pay_balance_dimensions DIM,
67: pay_defined_balances DB
68: WHERE DB.defined_balance_id = p_defined_balance_id
69: AND DIM.balance_dimension_id = DB.balance_dimension_id;
70: --

Line 171: FROM pay_balance_dimensions pbd,

167: --
168: cursor get_dimension_type(c_defined_balance_id IN NUMBER)
169: IS
170: SELECT pbd.dimension_name
171: FROM pay_balance_dimensions pbd,
172: pay_defined_balances pdb
173: WHERE pdb.defined_balance_id = c_defined_balance_id
174: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
175: --