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 FND_NUMBER

Line 2173: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value

2169:
2170: cursor csr_uk_earnings_cv(p_assignment_action_id number) is
2171: SELECT /*+ leading(lck,paa2) */
2172: --pai.action_information4 NARRATIVE,
2173: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2174: FROM pay_action_interlocks lck, -- archive action locking prepayment
2175: pay_assignment_actions paa1, -- prepayment action
2176: pay_assignment_actions paa2, -- archive action
2177: pay_payroll_actions ppa, -- prepayment

Line 2217: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value

2213:
2214: -- cursor to fetch the tax and national insurance current value
2215: cursor csr_uk_tx_cv(p_assignment_action_id number) is
2216: SELECT /*+ leading(lck,paa2) */
2217: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2218: FROM pay_action_interlocks lck, -- archive action locking prepayment
2219: pay_assignment_actions paa1, -- prepayment action
2220: pay_assignment_actions paa2, -- archive action
2221: pay_payroll_actions ppa, -- prepayment

Line 2262: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value

2258:
2259: -- cursor to fetch the tax and national insurance current value
2260: cursor csr_uk_ni_cv(p_assignment_action_id number) is
2261: SELECT /*+ leading(lck,paa2) */
2262: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
2263: FROM pay_action_interlocks lck, -- archive action locking prepayment
2264: pay_assignment_actions paa1, -- prepayment action
2265: pay_assignment_actions paa2, -- archive action
2266: pay_payroll_actions ppa, -- prepayment