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 PAY_BALANCE_FEEDS_F

Line 482: INDEX(FEED PAY_BALANCE_FEEDS_F_N50) */

478: -- SELECT /*+ RULE */
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,

Line 488: pay_balance_feeds_f FEED

484: FROM pay_assignment_actions ASSACT,
485: pay_payroll_actions PACT,
486: pay_run_results RR,
487: pay_run_result_values TARGET,
488: pay_balance_feeds_f FEED
489: WHERE ASSACT.assignment_id = P_ASSIGNMENT_ID
490: -- AND ASSACT.action_sequence <= NVL(P_ACTION_SEQUENCE,ASSACT.action_sequence)
491: AND PACT.payroll_action_id = ASSACT.payroll_action_id
492: AND PACT.date_earned >= P_FROM_DATE

Line 590: pay_balance_feeds_f FEED

586: AND RPACT.payroll_action_id = RASSACT.payroll_action_id
587: AND RPACT.action_type = 'V')) V1,
588: pay_run_results RR,
589: pay_run_result_values TARGET,
590: pay_balance_feeds_f FEED
591: WHERE RR.assignment_action_id = V1.assignment_action_id
592: AND RR.status IN ('P','PA')
593: AND TARGET.run_result_id = RR.run_result_id
594: AND nvl(TARGET.result_value, '0') <> '0'

Line 666: INDEX(FEED PAY_BALANCE_FEEDS_F_N50) */

662: baltype IN NUMBER)
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,

Line 693: pay_balance_feeds_f FEED

689: pay_assignment_actions ASSACT,
690: pay_payroll_actions PACT,
691: pay_run_results RR,
692: pay_run_result_values TARGET,
693: pay_balance_feeds_f FEED
694: WHERE ASSACT.assignment_id = V1.assignment_id
695: AND PACT.payroll_action_id = ASSACT.payroll_action_id
696: -- AND ASSACT.action_sequence <= decode(V1.action_type,'N',ASSACT.action_sequence,V1.action_sequence)
697: /* -- AND ( (V1.action_type = 'N')