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 FND_NUMBER

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

119:
120: cursor csr_uk_earnings_cv(p_assignment_action_id number) is
121: SELECT /*+ leading(lck,paa2) */
122: --pai.action_information4 NARRATIVE,
123: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
124: FROM pay_action_interlocks lck, -- archive action locking prepayment
125: pay_assignment_actions paa1, -- prepayment action
126: pay_assignment_actions paa2, -- archive action
127: pay_payroll_actions ppa, -- prepayment

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

163:
164: -- cursor to fetch the tax and national insurance current value
165: cursor csr_uk_tx_cv(p_assignment_action_id number) is
166: SELECT /*+ leading(lck,paa2) */
167: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
168: FROM pay_action_interlocks lck, -- archive action locking prepayment
169: pay_assignment_actions paa1, -- prepayment action
170: pay_assignment_actions paa2, -- archive action
171: pay_payroll_actions ppa, -- prepayment

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

208:
209: -- cursor to fetch the tax and national insurance current value
210: cursor csr_uk_ni_cv(p_assignment_action_id number) is
211: SELECT /*+ leading(lck,paa2) */
212: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value
213: FROM pay_action_interlocks lck, -- archive action locking prepayment
214: pay_assignment_actions paa1, -- prepayment action
215: pay_assignment_actions paa2, -- archive action
216: pay_payroll_actions ppa, -- prepayment