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_CA_BAL_UPLOAD dependencies on PAY_BALANCE_BATCH_LINES

Line 328: from pay_balance_batch_lines pbbl

324: (
325: p_batch_line_id number
326: ) is
327: select htuv.tax_unit_id
328: from pay_balance_batch_lines pbbl
329: ,hr_tax_units_v htuv
330: where pbbl.batch_line_id = p_batch_line_id
331: and pbbl.tax_unit_id = htuv.tax_unit_id
332: and pbbl.tax_unit_id is not null

Line 335: from pay_balance_batch_lines pbbl

331: and pbbl.tax_unit_id = htuv.tax_unit_id
332: and pbbl.tax_unit_id is not null
333: union all
334: select htuv.tax_unit_id
335: from pay_balance_batch_lines pbbl
336: ,hr_tax_units_v htuv
337: where pbbl.batch_line_id = p_batch_line_id
338: and upper(pbbl.gre_name) = upper(htuv.name)
339: and pbbl.tax_unit_id is null;

Line 348: from pay_balance_batch_lines pbbl

344: (
345: p_batch_line_id number
346: ) is
347: select prov.province_abbrev
348: from pay_balance_batch_lines pbbl
349: ,pay_ca_provinces_v prov
350: where pbbl.batch_line_id = p_batch_line_id
351: and pbbl.jurisdiction_code = prov.province_abbrev
352: and pbbl.jurisdiction_code is not null;