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_JPRTS dependencies on FND_NUMBER

Line 483: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)

479: -- SELECT /* Hint removed : see bug :4256073 */
480: select /*+ ORDERED
481: USE_NL(FEED)
482: INDEX(FEED PAY_BALANCE_FEEDS_F_N50) */
483: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
484: FROM pay_assignment_actions ASSACT,
485: pay_payroll_actions PACT,
486: pay_run_results RR,
487: pay_run_result_values TARGET,

Line 567: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)

563: cursor csr_balance
564: is
565: -- SELECT /*+ RULE */
566: SELECT /*+ ORDERED */
567: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
568: FROM ( select /*+ ORDERED */
569: ASSACT.assignment_action_id,
570: PACT.effective_date
571: from pay_assignment_actions ASSACT,

Line 667: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)

663: is
664: -- SELECT /*+ RULE */
665: SELECT /*+ ORDERED
666: INDEX(FEED PAY_BALANCE_FEEDS_F_N50) */
667: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
668: FROM
669: ( select BAL_ASSACT.assignment_id assignment_id,
670: BAL_ASSACT.action_sequence action_sequence,
671: -- BACT.action_type action_type,