[Home] [Help]
935: IS
936: SELECT paa.assignment_action_id, paa.source_action_id
937: FROM pay_assignment_actions paa
938: ,pay_payroll_actions ppa
939: ,pay_run_results prr
940: WHERE paa.assignment_id = p_assignment_id
941: AND ppa.action_status = 'C'
942: AND paa.action_status = 'C'
943: AND paa.payroll_action_id = ppa.payroll_action_id
956: ,p_asg_act_id NUMBER
957: )
958: IS
959: SELECT prr.*
960: FROM pay_run_results prr
961: WHERE prr.assignment_action_id = p_asg_act_id
962: AND prr.source_id = p_source_id;
963:
964:
1028: IS
1029: SELECT to_number(prrv.result_value) result,
1030: prrv.run_result_id -- to be used as ee.source_id for retro elements
1031: FROM pay_run_result_values prrv
1032: ,pay_run_results prr
1033: WHERE prrv.run_result_id = prr.run_result_id
1034: AND prr.assignment_action_id = p_asg_act_id
1035: -- AND prr.element_type_id = p_element_type_id
1036: AND prr.source_id = p_element_entry_id
1052: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N51 )
1053: INDEX (ASSACT PAY_ASSIGNMENT_ACTIONS_N1 )
1054: INDEX (PACT PAY_PAYROLL_ACTIONS_PK)
1055: INDEX (EE PAY_ELEMENT_ENTRIES_F_N50)
1056: INDEX (RR PAY_RUN_RESULTS_N51)
1057: INDEX (RRV PAY_RUN_RESULT_VALUES_N50)
1058: */
1059: RRV.input_value_id,
1060: RRV.result_value,
1071: pay_payroll_actions BACT,
1072: pay_assignment_actions ASSACT,
1073: pay_payroll_actions PACT,
1074: pay_element_entries_f EE,
1075: pay_run_results RR,
1076: pay_run_result_values RRV
1077: where BAL_ASSACT.assignment_action_id = p_assignment_action_id
1078: and BACT.payroll_action_id = BAL_ASSACT.payroll_action_id
1079: and BACT.action_type <> 'V'
1098: and RRV.run_result_id = RR.run_result_id
1099: and nvl(RRV.result_value, '0') <> '0'
1100: and not exists(
1101: select null
1102: from pay_run_results VRR
1103: where VRR.source_id = RR.run_result_id
1104: and VRR.source_type in ('R', 'V'));
1105:
1106: