APPS.PAY_KR_YEA20110101_PKG dependencies on PAY_DEFINED_BALANCES

Line 168: pay_defined_balances pdb,

164: cursor csr_ovs_def_bal_id
165: is
166: SELECT pdb.defined_balance_id
167: FROM pay_balance_types pbt,
168: pay_defined_balances pdb,
169: pay_balance_dimensions pbd
170: WHERE pbt.balance_name like 'Overseas Earnings'
171: and pbt.legislation_code = 'KR'
172: and pbd.legislation_code = 'KR'

Line 179: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

175: and pbd.balance_dimension_id = pdb.balance_dimension_id
176: and pbd.database_item_suffix = '_ASG_YTD';
177: --
178: l_ovs_earnings_bal number:=0;
179: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
180:
181: l_addend number;
182: l_multiplier number;
183: l_subtrahend number;