APPS.PAY_KR_YEA20080101_PKG dependencies on PAY_DEFINED_BALANCES

Line 120: pay_defined_balances pdb,

116: cursor csr_ovs_def_bal_id
117: is
118: SELECT pdb.defined_balance_id
119: FROM pay_balance_types pbt,
120: pay_defined_balances pdb,
121: pay_balance_dimensions pbd
122: WHERE pbt.balance_name like 'Overseas Earnings'
123: and pbt.legislation_code = 'KR'
124: and pbd.legislation_code = 'KR'

Line 131: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

127: and pbd.balance_dimension_id = pdb.balance_dimension_id
128: and pbd.database_item_suffix = '_ASG_YTD';
129: --
130: l_ovs_earnings_bal number:=0;
131: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
132:
133: l_addend number;
134: l_multiplier number;
135: l_subtrahend number;