APPS.PAY_IN_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 466: FROM pay_balance_types BT

462: , p_bal_adj_source_text VARCHAR2
463: , p_bal_adj_source_text2 VARCHAR2
464: ) IS
465: SELECT BT.balance_type_id
466: FROM pay_balance_types BT
467: WHERE BT.balance_type_id = p_balance_type_id
468: and ((p_source_id is null) or
469: (p_source_id is not null and p_source_id = p_bal_adj_source_id))
470: and ((p_tax_unit_id is null) or

Line 480: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

476: and ((p_source_text2 is null) or
477: (p_source_text2 is not null and p_source_text2 = p_bal_adj_source_text2))
478: AND 1 = 1;
479:
480: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
481:
482: -- Get the jurisdiction code from the original balance batch line
483: --
484: cursor csr_get_details(p_batch_line_id number)