APPS.PAY_KR_YEA20020101_PKG dependencies on PAY_DEFINED_BALANCES

Line 17: pay_defined_balances pdb,

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

Line 26: l_ovs_def_bal_id pay_defined_balances.defined_balance_id%TYPE;

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