DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_RUN_RESULT_VALUES

Line 487: pay_run_result_values TARGET,

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)
491: AND PACT.payroll_action_id = ASSACT.payroll_action_id

Line 589: pay_run_result_values TARGET,

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')
593: AND TARGET.run_result_id = RR.run_result_id

Line 692: pay_run_result_values TARGET,

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
696: -- AND ASSACT.action_sequence <= decode(V1.action_type,'N',ASSACT.action_sequence,V1.action_sequence)