APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PAY_DEFINED_BALANCES

Line 216: l_defined_bal_id pay_defined_balances.defined_balance_id%type;

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

Line 242: from pay_defined_balances def,

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