1635: ,p_ele_type_id NUMBER
1636: ,p_assignment_action_id NUMBER) IS
1637: SELECT rrv.result_value ,rr.element_entry_id
1638: FROM pay_run_result_values rrv
1639: ,pay_run_results rr
1640: ,pay_assignment_actions paa
1641: ,pay_payroll_actions ppa
1642: WHERE rrv.input_value_id = p_iv_id
1643: AND rr.element_type_id = p_ele_type_id
1654: ,p_assignment_action_id NUMBER
1655: ,p_EE_ID NUMBER) IS
1656: SELECT rrv.result_value
1657: FROM pay_run_result_values rrv
1658: ,pay_run_results rr
1659: ,pay_assignment_actions paa
1660: ,pay_payroll_actions ppa
1661: WHERE rrv.input_value_id = p_iv_id
1662: AND rr.element_type_id = p_ele_type_id
1687: SELECT sum(rrv.result_value) result_value
1688: ,count(rrv.RUN_RESULT_ID) record_count
1689: ,rrv.result_value UNIT_PRICE
1690: FROM pay_run_result_values rrv
1691: ,pay_run_results rr
1692: ,pay_assignment_actions paa
1693: ,pay_payroll_actions ppa
1694: WHERE rrv.input_value_id = p_iv_id
1695: AND rr.element_type_id = p_ele_type_id
1708: ,count(rrv.RUN_RESULT_ID) record_count
1709: ,rrv.result_value UNIT_PRICE
1710: FROM pay_run_result_values pr
1711: ,pay_run_result_values rrv
1712: ,pay_run_results rr
1713: ,pay_assignment_actions paa
1714: ,pay_payroll_actions ppa
1715: WHERE pr.input_value_id(+) = p_group_by
1716: AND rrv.input_value_id = p_iv_id
1730: SELECT sum(rrv.result_value) result_value
1731: ,count(rrv.RUN_RESULT_ID) record_count
1732: ,rrv.result_value UNIT_PRICE
1733: FROM pay_run_result_values rrv
1734: ,pay_run_results rr
1735: ,pay_assignment_actions paa
1736: ,pay_payroll_actions ppa
1737: WHERE rrv.input_value_id = p_iv_id
1738: AND rr.element_type_id = p_ele_type_id
1755: ,p_assignment_action_id NUMBER
1756: ) IS
1757: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
1758: FROM pay_run_result_values rrv1
1759: ,pay_run_results rr1
1760: ,pay_assignment_actions paa
1761: ,pay_payroll_actions ppa
1762: ,pay_run_result_values rrv2
1763: ,pay_run_results rr2
1759: ,pay_run_results rr1
1760: ,pay_assignment_actions paa
1761: ,pay_payroll_actions ppa
1762: ,pay_run_result_values rrv2
1763: ,pay_run_results rr2
1764: ,pay_run_result_values rrv3
1765: ,pay_run_results rr3
1766: WHERE rrv1.input_value_id = p_iv_id_UNIT
1767: AND rr1.element_type_id = p_ele_type_id
1761: ,pay_payroll_actions ppa
1762: ,pay_run_result_values rrv2
1763: ,pay_run_results rr2
1764: ,pay_run_result_values rrv3
1765: ,pay_run_results rr3
1766: WHERE rrv1.input_value_id = p_iv_id_UNIT
1767: AND rr1.element_type_id = p_ele_type_id
1768: AND rr1.run_result_id = rrv1.run_result_id
1769: AND rr1.assignment_action_id = paa.assignment_action_id
1789: ,p_assignment_action_id NUMBER
1790: ) IS
1791: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
1792: FROM pay_run_result_values rrv1
1793: ,pay_run_results rr1
1794: ,pay_assignment_actions paa
1795: ,pay_payroll_actions ppa
1796: ,pay_run_result_values rrv2
1797: ,pay_run_results rr2
1793: ,pay_run_results rr1
1794: ,pay_assignment_actions paa
1795: ,pay_payroll_actions ppa
1796: ,pay_run_result_values rrv2
1797: ,pay_run_results rr2
1798: ,pay_run_result_values rrv3
1799: ,pay_run_results rr3
1800: WHERE rrv1.input_value_id = p_iv_id_UNIT
1801: AND rr1.element_type_id = p_ele_type_id
1795: ,pay_payroll_actions ppa
1796: ,pay_run_result_values rrv2
1797: ,pay_run_results rr2
1798: ,pay_run_result_values rrv3
1799: ,pay_run_results rr3
1800: WHERE rrv1.input_value_id = p_iv_id_UNIT
1801: AND rr1.element_type_id = p_ele_type_id
1802: AND rr1.run_result_id = rrv1.run_result_id
1803: AND rr1.assignment_action_id = paa.assignment_action_id
2888: ,p_ele_type_id NUMBER
2889: ,p_assignment_action_id NUMBER) IS
2890: SELECT rrv.result_value,rr.element_entry_id
2891: FROM pay_run_result_values rrv
2892: ,pay_run_results rr
2893: ,pay_assignment_actions paa
2894: ,pay_payroll_actions ppa
2895: WHERE rrv.input_value_id = p_iv_id
2896: AND rr.element_type_id = p_ele_type_id
2907: ,p_assignment_action_id NUMBER
2908: ,p_EE_ID NUMBER) IS
2909: SELECT rrv.result_value
2910: FROM pay_run_result_values rrv
2911: ,pay_run_results rr
2912: ,pay_assignment_actions paa
2913: ,pay_payroll_actions ppa
2914: WHERE rrv.input_value_id = p_iv_id
2915: AND rr.element_type_id = p_ele_type_id
2938: SELECT sum(rrv.result_value) result_value
2939: ,count(rrv.RUN_RESULT_ID) record_count
2940: ,rrv.result_value UNIT_PRICE
2941: FROM pay_run_result_values rrv
2942: ,pay_run_results rr
2943: ,pay_assignment_actions paa
2944: ,pay_payroll_actions ppa
2945: WHERE rrv.input_value_id = p_iv_id
2946: AND rr.element_type_id = p_ele_type_id
2959: ,count(rrv.RUN_RESULT_ID) record_count
2960: ,rrv.result_value UNIT_PRICE
2961: FROM pay_run_result_values pr
2962: ,pay_run_result_values rrv
2963: ,pay_run_results rr
2964: ,pay_assignment_actions paa
2965: ,pay_payroll_actions ppa
2966: WHERE pr.input_value_id(+) = p_group_by
2967: AND rrv.input_value_id = p_iv_id
2979: ,p_ele_type_id NUMBER
2980: ,p_assignment_action_id NUMBER) IS
2981: SELECT sum(rrv.result_value) result_value
2982: FROM pay_run_result_values rrv
2983: ,pay_run_results rr
2984: ,pay_assignment_actions paa
2985: ,pay_payroll_actions ppa
2986: WHERE rrv.input_value_id = p_iv_id
2987: AND rr.element_type_id = p_ele_type_id
3006: ,p_assignment_action_id NUMBER
3007: ) IS
3008: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
3009: FROM pay_run_result_values rrv1
3010: ,pay_run_results rr1
3011: ,pay_assignment_actions paa
3012: ,pay_payroll_actions ppa
3013: ,pay_run_result_values rrv2
3014: ,pay_run_results rr2
3010: ,pay_run_results rr1
3011: ,pay_assignment_actions paa
3012: ,pay_payroll_actions ppa
3013: ,pay_run_result_values rrv2
3014: ,pay_run_results rr2
3015: ,pay_run_result_values rrv3
3016: ,pay_run_results rr3
3017: WHERE rrv1.input_value_id = p_iv_id_UNIT
3018: AND rr1.element_type_id = p_ele_type_id
3012: ,pay_payroll_actions ppa
3013: ,pay_run_result_values rrv2
3014: ,pay_run_results rr2
3015: ,pay_run_result_values rrv3
3016: ,pay_run_results rr3
3017: WHERE rrv1.input_value_id = p_iv_id_UNIT
3018: AND rr1.element_type_id = p_ele_type_id
3019: AND rr1.run_result_id = rrv1.run_result_id
3020: AND rr1.assignment_action_id = paa.assignment_action_id
3040: ,p_assignment_action_id NUMBER
3041: ) IS
3042: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
3043: FROM pay_run_result_values rrv1
3044: ,pay_run_results rr1
3045: ,pay_assignment_actions paa
3046: ,pay_payroll_actions ppa
3047: ,pay_run_result_values rrv2
3048: ,pay_run_results rr2
3044: ,pay_run_results rr1
3045: ,pay_assignment_actions paa
3046: ,pay_payroll_actions ppa
3047: ,pay_run_result_values rrv2
3048: ,pay_run_results rr2
3049: ,pay_run_result_values rrv3
3050: ,pay_run_results rr3
3051: WHERE rrv1.input_value_id = p_iv_id_UNIT
3052: AND rr1.element_type_id = p_ele_type_id
3046: ,pay_payroll_actions ppa
3047: ,pay_run_result_values rrv2
3048: ,pay_run_results rr2
3049: ,pay_run_result_values rrv3
3050: ,pay_run_results rr3
3051: WHERE rrv1.input_value_id = p_iv_id_UNIT
3052: AND rr1.element_type_id = p_ele_type_id
3053: AND rr1.run_result_id = rrv1.run_result_id
3054: AND rr1.assignment_action_id = paa.assignment_action_id