eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1638: FROM pay_run_result_values rrv

1634: CURSOR csr_result_value(p_iv_id NUMBER
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

Line 1657: FROM pay_run_result_values rrv

1653: ,p_ele_type_id NUMBER
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

Line 1690: FROM pay_run_result_values rrv

1686: ) IS
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

Line 1710: FROM pay_run_result_values pr

1706: ,p_group_by NUMBER) IS
1707: SELECT sum(rrv.result_value) result_value
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

Line 1711: ,pay_run_result_values rrv

1707: SELECT sum(rrv.result_value) result_value
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

Line 1733: FROM pay_run_result_values rrv

1729: ,p_assignment_action_id NUMBER) IS
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

Line 1758: FROM pay_run_result_values rrv1

1754: ,p_ele_type_id NUMBER
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

Line 1762: ,pay_run_result_values rrv2

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
1764: ,pay_run_result_values rrv3
1765: ,pay_run_results rr3
1766: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 1764: ,pay_run_result_values rrv3

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
1768: AND rr1.run_result_id = rrv1.run_result_id

Line 1792: FROM pay_run_result_values rrv1

1788: ,p_ele_type_id NUMBER
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

Line 1796: ,pay_run_result_values rrv2

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
1798: ,pay_run_result_values rrv3
1799: ,pay_run_results rr3
1800: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 1798: ,pay_run_result_values rrv3

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
1802: AND rr1.run_result_id = rrv1.run_result_id

Line 1820: l_result_value pay_run_result_values.result_value%TYPE := 0;

1816:
1817: -----------------------------------------------------------------------------
1818:
1819: rec_get_element csr_get_element%ROWTYPE;
1820: l_result_value pay_run_result_values.result_value%TYPE := 0;
1821: l_action_info_id NUMBER;
1822: l_ovn NUMBER;
1823: l_element_context VARCHAR2(10);
1824: l_index NUMBER := 0;

Line 2891: FROM pay_run_result_values rrv

2887: CURSOR csr_result_value(p_iv_id NUMBER
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

Line 2910: FROM pay_run_result_values rrv

2906: ,p_ele_type_id NUMBER
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

Line 2941: FROM pay_run_result_values rrv

2937: ) IS
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

Line 2961: FROM pay_run_result_values pr

2957: ,p_group_by NUMBER) IS
2958: SELECT sum(rrv.result_value) result_value
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

Line 2962: ,pay_run_result_values rrv

2958: SELECT sum(rrv.result_value) result_value
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

Line 2982: FROM pay_run_result_values rrv

2978: /*CURSOR csr_sum_of_result_values(p_iv_id NUMBER
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

Line 2999: l_result_value pay_run_result_values.result_value%TYPE := 0;

2995: */
2996:
2997:
2998: rec_group_by csr_group_by%ROWTYPE;
2999: l_result_value pay_run_result_values.result_value%TYPE := 0;
3000:
3001: -----------------------------------------------------------------------------
3002: /* Cursor to retrieve sum of all run result value for an given Main Element */
3003: -----------------------------------------------------------------------------

Line 3009: FROM pay_run_result_values rrv1

3005: ,p_ele_type_id NUMBER
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

Line 3013: ,pay_run_result_values rrv2

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
3015: ,pay_run_result_values rrv3
3016: ,pay_run_results rr3
3017: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 3015: ,pay_run_result_values rrv3

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
3019: AND rr1.run_result_id = rrv1.run_result_id

Line 3043: FROM pay_run_result_values rrv1

3039: ,p_ele_type_id NUMBER
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

Line 3047: ,pay_run_result_values rrv2

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
3049: ,pay_run_result_values rrv3
3050: ,pay_run_results rr3
3051: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 3049: ,pay_run_result_values rrv3

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
3053: AND rr1.run_result_id = rrv1.run_result_id