APPS.PAY_CN_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 447: FROM pay_balance_types BT

443: , p_bal_adj_tax_unit_id NUMBER
444: , p_bal_adj_original_entry_id NUMBER
445: ) IS
446: SELECT BT.balance_type_id
447: FROM pay_balance_types BT
448: WHERE BT.balance_type_id = p_balance_type_id
449: --
450: -- TAX_UNIT_ID context NB. if the tax unit is used then only those
451: -- adjustments which are for the same tax unit can be included.

Line 464: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

460: -- criteria that has to be met.
461: --
462: AND 1 = 1;
463:
464: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
465:
466: -- Get the tax_unit_id from the original balance batch line
467: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER)
468: IS