DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_RUN_RESULT_VALUES

Line 484: pay_run_result_values TARGET,

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

Line 586: pay_run_result_values TARGET,

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

Line 665: pay_run_result_values TARGET,

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