382: where DI.user_name = p_db_item_name
383: and UE.user_entity_id = DI.user_entity_id
384: and Ue.creator_type = 'B';
385:
386: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
387:
388: begin
389:
390: open csr_defined_balance;
1050: l_archive_item_id number;
1051:
1052: /* Variable holding the balance to be tested. */
1053:
1054: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
1055:
1056: /* Indicator variables used to control how the people are grouped. */
1057:
1058: l_group_by_gre boolean := FALSE;