[Home] [Help]
928: IS
929: SELECT paa.assignment_action_id, paa.source_action_id
930: FROM pay_assignment_actions paa
931: ,pay_payroll_actions ppa
932: ,pay_run_results prr
933: WHERE paa.assignment_id = p_assignment_id
934: AND ppa.action_status = 'C'
935: AND paa.action_status = 'C'
936: AND paa.payroll_action_id = ppa.payroll_action_id
949: ,p_asg_act_id NUMBER
950: )
951: IS
952: SELECT prr.*
953: FROM pay_run_results prr
954: WHERE prr.assignment_action_id = p_asg_act_id
955: AND prr.source_id = p_source_id;
956:
957:
999: IS
1000: SELECT to_number(prrv.result_value) result,
1001: prrv.run_result_id -- to be used as ee.source_id for retro elements
1002: FROM pay_run_result_values prrv
1003: ,pay_run_results prr
1004: WHERE prrv.run_result_id = prr.run_result_id
1005: AND prr.assignment_action_id = p_asg_act_id
1006: -- AND prr.element_type_id = p_element_type_id
1007: AND prr.source_id = p_element_entry_id
1023: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1024: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1025: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1026: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1027: INDEX (RR PAY_RUN_RESULTS_N51)
1028: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1029: */
1030: RRV.input_value_id,
1031: RRV.result_value,
1042: pay_payroll_actions BACT,
1043: pay_assignment_actions ASSACT,
1044: pay_payroll_actions PACT,
1045: pay_element_entries_f EE,
1046: pay_run_results RR,
1047: pay_run_result_values RRV
1048: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1049: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
1050: and BACT.action_type <> 'V'
1069: and RRV.run_result_id = RR.run_result_id
1070: and nvl(RRV.result_value, '0') <> '0'
1071: and not exists(
1072: select null
1073: from pay_run_results VRR
1074: where VRR.source_id = RR.run_result_id
1075: and VRR.source_type in ('R', 'V'));
1076:
1077: