APPS.PAY_AU_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 344: FROM pay_balance_types BT

340: , p_tax_unit_id NUMBER
341: , p_bal_adj_tax_unit_id NUMBER
342: ) IS
343: SELECT BT.balance_type_id
344: FROM pay_balance_types BT
345: WHERE BT.balance_type_id = p_balance_type_id
346: and ((p_tax_unit_id is null) or
347: (p_tax_unit_id is not null and p_tax_unit_id = p_bal_adj_tax_unit_id)) ;
348:

Line 349: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

345: WHERE BT.balance_type_id = p_balance_type_id
346: and ((p_tax_unit_id is null) or
347: (p_tax_unit_id is not null and p_tax_unit_id = p_bal_adj_tax_unit_id)) ;
348:
349: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
350:
351: -- To get the tax_unit_id from pay_balance_batch_lines
352:
353: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER) IS