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.HR_PERSON_RECORD dependencies on PAY_DEFINED_BALANCES

Line 2317: pay_defined_balances pdb,

2313: -- cursor to fetch the tax and earnings YTD
2314: cursor csr_tx_er_ytd(p_assignment_action_id number,p_bal_name varchar2) is
2315: select pai.ACTION_INFORMATION4
2316: from pay_action_information pai,
2317: pay_defined_balances pdb,
2318: pay_balance_types pbt
2319: where pai.action_context_id = p_assignment_action_id -- 182069
2320: and to_char(pdb.DEFINED_BALANCE_ID) = (pai.ACTION_INFORMATION1)
2321: and pdb.BALANCE_TYPE_ID = pbt.BALANCE_TYPE_ID

Line 2331: from pay_defined_balances pdb,

2327:
2328: -- cursor to get the defined balance id
2329: cursor csr_def_bal_id(p_assignment_action_id number) is
2330: select defined_balance_id
2331: from pay_defined_balances pdb,
2332: pay_balance_types pbt,
2333: pay_balance_dimensions pbd
2334: where pbt.balance_name = 'NI '||(select ACTION_INFORMATION23
2335: from pay_action_information pai

Line 2363: from pay_defined_balances pdb,

2359:
2360: -- cursor to fetch the netpay balance id
2361: cursor csr_netpay_bal_id is
2362: select defined_balance_id
2363: from pay_defined_balances pdb,
2364: pay_balance_types pbt,
2365: pay_balance_dimensions pbd
2366: where pbt.balance_name = 'Net Pay'
2367: and pbd.dimension_name = '_ASG_TD_YTD'