APPS.PAY_CN_BAL_UPLOAD dependencies on PAY_TEMP_BALANCE_ADJUSTMENTS

Line 497: FROM pay_temp_balance_adjustments

493: -- Get tax_unit_id and original_entry_id for previously tested adjustments
494: CURSOR csr_get_tested_adjustments(p_test_batch_line_id NUMBER) IS
495: SELECT tax_unit_id
496: ,original_entry_id
497: FROM pay_temp_balance_adjustments
498: WHERE batch_line_id = p_test_batch_line_id;
499:
500: -- The balance returned by the include check.
501: l_tax_unit_id hr_tax_units_v.tax_unit_id%TYPE;

Line 502: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;

498: WHERE batch_line_id = p_test_batch_line_id;
499:
500: -- The balance returned by the include check.
501: l_tax_unit_id hr_tax_units_v.tax_unit_id%TYPE;
502: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
503: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
504:
505: BEGIN
506: hr_utility.trace('Entering pay_cn_bal_upload.include_adjustment_test');

Line 503: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;

499:
500: -- The balance returned by the include check.
501: l_tax_unit_id hr_tax_units_v.tax_unit_id%TYPE;
502: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
503: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
504:
505: BEGIN
506: hr_utility.trace('Entering pay_cn_bal_upload.include_adjustment_test');
507: