DBA Data[Home] [Help]

APPS.HR_JPDRB dependencies on PAY_DEFINED_BALANCES

Line 67: pay_defined_balances DB

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: --
71: BEGIN

Line 172: pay_defined_balances pdb

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: --
176: cursor csr_business_group