DBA Data[Home] [Help]

APPS.PAY_KR_YEA20060101_PKG dependencies on PAY_DEFINED_BALANCES

Line 104: pay_defined_balances pdb,

100: cursor csr_ovs_def_bal_id
101: is
102: SELECT pdb.defined_balance_id
103: FROM pay_balance_types pbt,
104: pay_defined_balances pdb,
105: pay_balance_dimensions pbd
106: WHERE pbt.balance_name like 'Overseas Earnings'
107: and pbt.legislation_code = 'KR'
108: and pbd.legislation_code = 'KR'

Line 115: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

111: and pbd.balance_dimension_id = pdb.balance_dimension_id
112: and pbd.database_item_suffix = '_ASG_YTD';
113: --
114: l_ovs_earnings_bal number:=0;
115: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
116:
117: l_addend number;
118: l_multiplier number;
119: l_subtrahend number;