APPS.PQP_TIAALOD_PKG dependencies on PAY_DEFINED_BALANCES

Line 101: pay_defined_balances db,

97:
98: CURSOR c1 IS
99: SELECT db.defined_balance_id, pbt.balance_name
100: FROM pay_balance_types pbt,
101: pay_defined_balances db,
102: pay_balance_dimensions bd
103: WHERE pbt.balance_name IN ('RA GRA PLAN BY INST',
104: 'RA GRA PLAN REDUCT',
105: 'RA PLAN DEDUCT',

Line 359: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;

355: l_balance NUMBER;
356: l_balance_start NUMBER;
357: l_balance_end NUMBER;
358: l_defined_balance_id NUMBER;
359: l_def_balance_id pay_defined_balances.defined_balance_id%TYPE;
360: l_balance_name pay_balance_types.balance_name%TYPE := ' ';
361: l_tax_id NUMBER;
362: l_count_bal NUMBER :=0;
363: l_input_date per_assignments_f.effective_end_date%TYPE;