APPS.PAY_MX_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 285: FROM pay_balance_types BT

281: , p_bal_adj_source_id NUMBER
282: , p_bal_adj_original_entry_id NUMBER
283: ) IS
284: SELECT BT.balance_type_id
285: FROM pay_balance_types BT
286: WHERE BT.balance_type_id = p_balance_type_id
287: --
288: -- JURISDICTION_CODE context NB. if the jurisdiction code is
289: -- used then only those adjustments which are for the same

Line 304: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

300: -- criteria that has to be met.
301: --
302: AND 1 = 1;
303:
304: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
305:
306: -- Get the jurisdiction code from the original balance batch line
307: --
308: cursor csr_get_source_id(p_batch_line_id number)