121: cursor csr_ovs_def_bal_id
122: is
123: SELECT pdb.defined_balance_id
124: FROM pay_balance_types pbt,
125: pay_defined_balances pdb,
126: pay_balance_dimensions pbd
127: WHERE pbt.balance_name like 'Overseas Earnings'
128: and pbt.legislation_code = 'KR'
129: and pbd.legislation_code = 'KR'
132: and pbd.balance_dimension_id = pdb.balance_dimension_id
133: and pbd.database_item_suffix = '_ASG_YTD';
134: --
135: l_ovs_earnings_bal number:=0;
136: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
137:
138: l_addend number;
139: l_multiplier number;
140: l_subtrahend number;