[Home] [Help]
162: cursor csr_def_bal_id(cp_bal_type_id number,
163: cp_bal_dimension varchar2,
164: cp_legislation_code varchar2) is
165: select pdb.defined_balance_id
166: from pay_defined_balances pdb,
167: pay_balance_dimensions pbd
168: where pdb.balance_type_id = cp_bal_type_id
169: and pbd.dimension_name = cp_bal_dimension
170: and pbd.balance_dimension_id = pdb.balance_dimension_id
172: pbd.business_group_id is null)
173: or (pbd.legislation_code is null and
174: pbd.business_group_id is not null));
175:
176: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
177: l_balance_type_id pay_balance_types.balance_type_id%type;
178:
179: begin
180:
851: l_archive_item_id number;
852:
853: /* Variable holding the balance to be tested. */
854:
855: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
856:
857: /* Indicator variables used to control how the people are grouped. */
858:
859: l_group_by_gre boolean := FALSE;
1874: l_beneficiary_name varchar2(150);
1875: l_beneficiary_sin varchar2(20);
1876: ln_no_gross_earnings NUMBER := 0;
1877:
1878: ln_defined_balance_id pay_defined_balances.defined_balance_id%type;
1879: lv_serial_number varchar2(30);
1880: lv_BoxL_excess_amt varchar2(30);
1881: lv_BoxO_excess_amt varchar2(30);
1882: lv_BoxL_Maxlimit varchar2(30);