APPS.HR_JPRTS dependencies on PAY_RUN_RESULTS

Line 483: pay_run_results RR,

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,
485: pay_balance_feeds_f FEED
486: WHERE ASSACT.assignment_id = P_ASSIGNMENT_ID
487: -- AND ASSACT.action_sequence <= NVL(P_ACTION_SEQUENCE,ASSACT.action_sequence)

Line 585: pay_run_results RR,

581: WHERE RINTL.locked_action_id = ASSACT.assignment_action_id
582: AND RASSACT.assignment_action_id = RINTL.locking_action_id
583: AND RPACT.payroll_action_id = RASSACT.payroll_action_id
584: AND RPACT.action_type = 'V')) V1,
585: pay_run_results RR,
586: pay_run_result_values TARGET,
587: pay_balance_feeds_f FEED
588: WHERE RR.assignment_action_id = V1.assignment_action_id
589: AND RR.status IN ('P','PA')

Line 666: pay_run_results RR,

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,
668: pay_assignment_actions ASSACT,
669: ( select BAL_ASSACT.assignment_id assignment_id,
670: BAL_ASSACT.action_sequence action_sequence,