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 328: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

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