APPS.PAY_KR_YEA20030101_PKG dependencies on PAY_DEFINED_BALANCES

Line 16: pay_defined_balances pdb,

12: cursor csr_ovs_def_bal_id
13: is
14: SELECT pdb.defined_balance_id
15: FROM pay_balance_types pbt,
16: pay_defined_balances pdb,
17: pay_balance_dimensions pbd
18: WHERE pbt.balance_name like 'Overseas Earnings'
19: and pbt.legislation_code = 'KR'
20: and pbt.balance_type_id = pdb.balance_type_id

Line 25: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

21: and pbd.balance_dimension_id = pdb.balance_dimension_id
22: and pbd.database_item_suffix = '_ASG_YTD';
23:
24: l_ovs_earnings_bal number:=0;
25: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
26:
27: l_addend number;
28: l_multiplier number;
29: l_subtrahend number;