APPS.PAY_ARCHIVE dependencies on PAY_DEFINED_BALANCES

Line 148: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

144: and UE.creator_type = 'B'
145: and (UE.legislation_code = l_legislation_code
146: or UE.business_group_id = l_business_group_id);
147: --
148: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
149: --
150: begin
151: --
152: hr_utility.set_location('pay_archive.bal_db_item - opening cursor', 1);

Line 386: pay_defined_balances pdb

382: -----------------------------------------------------------
383: SELECT jurisdiction_level jur_lev
384: INTO l_balance_dbis.jur_level(l_balance_dbis.sz)
385: FROM pay_balance_types pbt,
386: pay_defined_balances pdb
387: WHERE pbt.balance_type_id= pdb.balance_type_id AND
388: pdb.defined_balance_id =
389: l_balance_dbis.balance_id(l_balance_dbis.sz);
390: --