APPS.PAY_KR_YEA20100101_PKG dependencies on PAY_DEFINED_BALANCES

Line 163: pay_defined_balances pdb,

159: cursor csr_ovs_def_bal_id
160: is
161: SELECT pdb.defined_balance_id
162: FROM pay_balance_types pbt,
163: pay_defined_balances pdb,
164: pay_balance_dimensions pbd
165: WHERE pbt.balance_name like 'Overseas Earnings'
166: and pbt.legislation_code = 'KR'
167: and pbd.legislation_code = 'KR'

Line 174: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

170: and pbd.balance_dimension_id = pdb.balance_dimension_id
171: and pbd.database_item_suffix = '_ASG_YTD';
172: --
173: l_ovs_earnings_bal number:=0;
174: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
175:
176: l_addend number;
177: l_multiplier number;
178: l_subtrahend number;