APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_DEFINED_BALANCES

Line 217: l_defined_bal_id pay_defined_balances.defined_balance_id%type;

213: group by length(paa2.rowid)
214: );
215:
216: l_latest_asg_action pay_assignment_actions.assignment_action_id%type;
217: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
218: l_balance_value number;
219:
220:
221: l_proc varchar2(50) := g_package || 'get_balance';

Line 243: from pay_defined_balances def,

239: );
240:
241: select def.defined_balance_id
242: into l_defined_bal_id
243: from pay_defined_balances def,
244: pay_balance_types pbt,
245: pay_balance_dimensions dim,
246: pay_balance_types_tl pbt_tl
247: where pbt_tl.balance_name = p_balance_name