[Home] [Help]
201: cursor csr_def_bal_id(cp_bal_type_id number,
202: cp_bal_dimension varchar2,
203: cp_legislation_code varchar2) is
204: select pdb.defined_balance_id
205: from pay_defined_balances pdb,
206: pay_balance_dimensions pbd
207: where pdb.balance_type_id = cp_bal_type_id
208: and pbd.dimension_name = cp_bal_dimension
209: and pbd.balance_dimension_id = pdb.balance_dimension_id
211: pbd.business_group_id is null)
212: or (pbd.legislation_code is null and
213: pbd.business_group_id is not null));
214:
215: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
216: l_balance_type_id pay_balance_types.balance_type_id%type;
217:
218: begin
219:
910: l_archive_item_id number;
911:
912: /* Variable holding the balance to be tested. */
913:
914: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
915:
916: /* Indicator variables used to control how the people are grouped. */
917:
918: l_group_by_gre boolean := FALSE;
2567: l_beneficiary_name varchar2(150);
2568: l_beneficiary_sin varchar2(20);
2569: ln_no_gross_earnings NUMBER := 0;
2570:
2571: ln_defined_balance_id pay_defined_balances.defined_balance_id%type;
2572: lv_serial_number varchar2(30);
2573: lv_BoxL_excess_amt varchar2(30);
2574: lv_BoxO_excess_amt varchar2(30);
2575: lv_BoxL_Maxlimit varchar2(30);