DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_RUN_RESULTS

Line 486: pay_run_results RR,

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,
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)

Line 588: pay_run_results RR,

584: WHERE RINTL.locked_action_id = ASSACT.assignment_action_id
585: AND RASSACT.assignment_action_id = RINTL.locking_action_id
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')

Line 691: pay_run_results RR,

687: and HROG.organization_id = BACT.business_group_id
688: and HROG.org_information_context = 'Business Group Information') V1,
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