APPS.PAY_AU_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 346: FROM pay_balance_types BT

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

Line 351: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

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