APPS.PAY_AU_BAL_UPLOAD dependencies on PAY_TEMP_BALANCE_ADJUSTMENTS

Line 375: FROM pay_temp_balance_adjustments

371: -- Get tax_unit_id for previously tested adjustments
372:
373: CURSOR csr_get_tested_adjustments(p_test_batch_line_id NUMBER) IS
374: SELECT tax_unit_id
375: FROM pay_temp_balance_adjustments
376: WHERE batch_line_id = p_test_batch_line_id;
377:
378: -- The balance returned by the include check.
379: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;

Line 380: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;

376: WHERE batch_line_id = p_test_batch_line_id;
377:
378: -- The balance returned by the include check.
379: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
380: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
381: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
382: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
383:
384: BEGIN

Line 382: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;

378: -- The balance returned by the include check.
379: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
380: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
381: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
382: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
383:
384: BEGIN
385:
386: OPEN csr_get_tax_unit(p_batch_line_id);