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 351: -- To get the tax_unit_id from pay_balance_batch_lines

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

Line 355: FROM pay_balance_batch_lines pbbl

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

Line 362: FROM pay_balance_batch_lines pbbl

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

Line 377: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;

373: FROM pay_temp_balance_adjustments
374: WHERE batch_line_id = p_test_batch_line_id;
375:
376: -- The balance returned by the include check.
377: l_orig_entry_id pay_balance_batch_lines.original_entry_id%TYPE;
378: l_adj_orig_entry_id pay_temp_balance_adjustments.original_entry_id%TYPE;
379: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;
380: l_adj_tax_unit_id pay_temp_balance_adjustments.tax_unit_id%TYPE;
381:

Line 379: l_tax_unit_id pay_balance_batch_lines.tax_unit_id%TYPE;

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