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_GB_HR_HELPDESK dependencies on PAY_DEFINED_BALANCES

Line 267: pay_defined_balances pdb,

263: -- cursor to fetch the tax and earnings YTD
264: cursor csr_tx_er_ytd(p_assignment_action_id number,p_bal_name varchar2) is
265: select pai.ACTION_INFORMATION4
266: from pay_action_information pai,
267: pay_defined_balances pdb,
268: pay_balance_types pbt
269: where pai.action_context_id = p_assignment_action_id -- 182069
270: and to_char(pdb.DEFINED_BALANCE_ID) = (pai.ACTION_INFORMATION1)
271: and pdb.BALANCE_TYPE_ID = pbt.BALANCE_TYPE_ID

Line 281: from pay_defined_balances pdb,

277:
278: -- cursor to get the defined balance id
279: cursor csr_def_bal_id(p_assignment_action_id number) is
280: select defined_balance_id
281: from pay_defined_balances pdb,
282: pay_balance_types pbt,
283: pay_balance_dimensions pbd
284: where pbt.balance_name = 'NI '||(select ACTION_INFORMATION23
285: from pay_action_information pai

Line 314: from pay_defined_balances pdb,

310:
311: -- cursor to fetch the netpay balance id
312: cursor csr_netpay_bal_id is
313: select defined_balance_id
314: from pay_defined_balances pdb,
315: pay_balance_types pbt,
316: pay_balance_dimensions pbd
317: where pbt.balance_name = 'Net Pay'
318: and pbd.dimension_name = '_ASG_TD_YTD'