APPS.PAY_KR_YEA20070101_PKG dependencies on PAY_DEFINED_BALANCES

Line 110: pay_defined_balances pdb,

106: cursor csr_ovs_def_bal_id
107: is
108: SELECT pdb.defined_balance_id
109: FROM pay_balance_types pbt,
110: pay_defined_balances pdb,
111: pay_balance_dimensions pbd
112: WHERE pbt.balance_name like 'Overseas Earnings'
113: and pbt.legislation_code = 'KR'
114: and pbd.legislation_code = 'KR'

Line 121: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

117: and pbd.balance_dimension_id = pdb.balance_dimension_id
118: and pbd.database_item_suffix = '_ASG_YTD';
119: --
120: l_ovs_earnings_bal number:=0;
121: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
122:
123: l_addend number;
124: l_multiplier number;
125: l_subtrahend number;