APPS.PAY_KR_YEA20040101_PKG dependencies on PAY_DEFINED_BALANCES

Line 98: pay_defined_balances pdb,

94: cursor csr_ovs_def_bal_id
95: is
96: SELECT pdb.defined_balance_id
97: FROM pay_balance_types pbt,
98: pay_defined_balances pdb,
99: pay_balance_dimensions pbd
100: WHERE pbt.balance_name like 'Overseas Earnings'
101: and pbt.legislation_code = 'KR'
102: and pbd.legislation_code = 'KR'

Line 109: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

105: and pbd.balance_dimension_id = pdb.balance_dimension_id
106: and pbd.database_item_suffix = '_ASG_YTD';
107: --
108: l_ovs_earnings_bal number:=0;
109: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
110:
111: l_addend number;
112: l_multiplier number;
113: l_subtrahend number;