APPS.PAY_KR_YEA20120101_PKG dependencies on PAY_DEFINED_BALANCES

Line 184: pay_defined_balances pdb,

180: cursor csr_ovs_def_bal_id
181: is
182: SELECT pdb.defined_balance_id
183: FROM pay_balance_types pbt,
184: pay_defined_balances pdb,
185: pay_balance_dimensions pbd
186: WHERE pbt.balance_name like 'Overseas Earnings'
187: and pbt.legislation_code = 'KR'
188: and pbd.legislation_code = 'KR'

Line 196: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

192: and pbd.database_item_suffix = '_ASG_YTD';
193: --
194:
195: l_ovs_earnings_bal number:=0;
196: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
197:
198: l_addend number;
199: l_multiplier number;
200: l_subtrahend number;