APPS.PAY_IN_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 470: FROM pay_balance_types BT

466: , p_bal_adj_source_text VARCHAR2
467: , p_bal_adj_source_text2 VARCHAR2
468: ) IS
469: SELECT BT.balance_type_id
470: FROM pay_balance_types BT
471: WHERE BT.balance_type_id = p_balance_type_id
472: and ((p_source_id is null) or
473: (p_source_id is not null and p_source_id = p_bal_adj_source_id))
474: and ((p_tax_unit_id is null) or

Line 484: l_bal_type_id pay_balance_types.balance_type_id%TYPE;

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