131: ,c_business_group_id IN Number) IS
132: SELECT db.defined_balance_id
133: FROM pay_balance_types pbt
134: ,pay_defined_balances db
135: ,pay_balance_dimensions bd
136: WHERE pbt.balance_name = c_balance_name
137: AND pbt.balance_type_id = db.balance_type_id
138: AND bd.balance_dimension_id = db.balance_dimension_id
139: AND bd.dimension_name = c_dimension_name
149: ,c_dimension_name IN Varchar2
150: ,c_business_group_id IN Number) IS
151: SELECT db.defined_balance_id
152: FROM pay_defined_balances db
153: ,pay_balance_dimensions bd
154: WHERE db.balance_type_id = c_balance_type_id
155: AND bd.balance_dimension_id = db.balance_dimension_id
156: AND bd.dimension_name = c_dimension_name
157: AND (db.business_group_id = c_business_group_id OR
3184: -- Cursor to get the Assignment Run level dimension id
3185: --
3186: CURSOR csr_asg_dimId IS
3187: SELECT balance_dimension_id
3188: FROM pay_balance_dimensions
3189: WHERE legislation_code = 'NL'
3190: AND database_item_suffix = '_ASG_RUN';
3191:
3192: -- Cursor to check if there is a change in hire date