DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on FND_NUMBER

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

476: cursor csr_balance
477: is
478: -- SELECT /*+ RULE */
479: SELECT /* Hint removed : see bug :4256073 */
480: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
481: FROM pay_assignment_actions ASSACT,
482: pay_payroll_actions PACT,
483: pay_run_results RR,
484: pay_run_result_values TARGET,

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

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

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

659: baltype IN NUMBER)
660: is
661: -- SELECT /*+ RULE */
662: SELECT
663: NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(TARGET.result_value) * FEED.scale),0)
664: FROM pay_balance_feeds_f FEED,
665: pay_run_result_values TARGET,
666: pay_run_results RR,
667: pay_payroll_actions PACT,