APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PAY_DEFINED_BALANCES

Line 206: pay_defined_balances pdb

202: IS
203: SELECT pdb.defined_balance_id
204: FROM pay_balance_dimensions pbd,
205: pay_balance_types pbt,
206: pay_defined_balances pdb
207: WHERE pbd.dimension_name = '_PER_CO_TD_REF_ITD'
208: AND pbd.business_group_id IS NULL
209: AND pbd.legislation_code = 'GB'
210: AND pbt.balance_name = 'Court Order'

Line 329: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

325: l_date date;
326:
327:
328: v_initial_det csr_intial_debt%rowtype;
329: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
330: l_business_group_name per_business_groups.name%type;
331: v_payroll pay_payrolls_f.payroll_name%type;
332:
333: l_overpaid_flag varchar2(1);