349: and UE.user_entity_id = DI.user_entity_id
350: and Ue.creator_type = 'B'
351: and UE.legislation_code = 'CA';
352:
353: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
354:
355: begin
356:
357: open csr_defined_balance;
515: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
516:
517: /* Variable holding the balance to be tested. */
518:
519: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
520:
521: /* Indicator variables used to control how the people are grouped. */
522:
523: l_group_by_gre boolean := FALSE;