eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 353: -- To get the tax_unit_id from pay_balance_batch_lines

349: (p_tax_unit_id is not null and p_tax_unit_id = p_bal_adj_tax_unit_id)) ;
350:
351: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
352:
353: -- To get the tax_unit_id from pay_balance_batch_lines
354:
355: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER) IS
356: SELECT htuv.tax_unit_id
357: FROM pay_balance_batch_lines pbbl

Line 357: FROM pay_balance_batch_lines pbbl

353: -- To get the tax_unit_id from pay_balance_batch_lines
354:
355: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER) IS
356: SELECT htuv.tax_unit_id
357: FROM pay_balance_batch_lines pbbl
358: ,hr_tax_units_v htuv
359: WHERE pbbl.batch_line_id = p_batch_line_id
360: AND pbbl.tax_unit_id = htuv.tax_unit_id
361: AND pbbl.tax_unit_id IS NOT NULL

Line 364: FROM pay_balance_batch_lines pbbl

360: AND pbbl.tax_unit_id = htuv.tax_unit_id
361: AND pbbl.tax_unit_id IS NOT NULL
362: UNION ALL
363: SELECT htuv.tax_unit_id
364: FROM pay_balance_batch_lines pbbl
365: ,hr_tax_units_v htuv
366: WHERE pbbl.batch_line_id = p_batch_line_id
367: AND upper(pbbl.gre_name) = UPPER(htuv.name)
368: AND pbbl.tax_unit_id IS NULL;

Line 379: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;

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;
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:

Line 381: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;

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
385: