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 1636: FROM pay_run_result_values rrv

1632: CURSOR csr_result_value(p_iv_id NUMBER
1633: ,p_ele_type_id NUMBER
1634: ,p_assignment_action_id NUMBER) IS
1635: SELECT rrv.result_value ,rr.element_entry_id
1636: FROM pay_run_result_values rrv
1637: ,pay_run_results rr
1638: ,pay_assignment_actions paa
1639: ,pay_payroll_actions ppa
1640: WHERE rrv.input_value_id = p_iv_id

Line 1655: FROM pay_run_result_values rrv

1651: ,p_ele_type_id NUMBER
1652: ,p_assignment_action_id NUMBER
1653: ,p_EE_ID NUMBER) IS
1654: SELECT rrv.result_value
1655: FROM pay_run_result_values rrv
1656: ,pay_run_results rr
1657: ,pay_assignment_actions paa
1658: ,pay_payroll_actions ppa
1659: WHERE rrv.input_value_id = p_iv_id

Line 1688: FROM pay_run_result_values rrv

1684: ) IS
1685: SELECT sum(rrv.result_value) result_value
1686: ,count(rrv.RUN_RESULT_ID) record_count
1687: ,rrv.result_value UNIT_PRICE
1688: FROM pay_run_result_values rrv
1689: ,pay_run_results rr
1690: ,pay_assignment_actions paa
1691: ,pay_payroll_actions ppa
1692: WHERE rrv.input_value_id = p_iv_id

Line 1708: FROM pay_run_result_values pr

1704: ,p_group_by NUMBER) IS
1705: SELECT sum(rrv.result_value) result_value
1706: ,count(rrv.RUN_RESULT_ID) record_count
1707: ,rrv.result_value UNIT_PRICE
1708: FROM pay_run_result_values pr
1709: ,pay_run_result_values rrv
1710: ,pay_run_results rr
1711: ,pay_assignment_actions paa
1712: ,pay_payroll_actions ppa

Line 1709: ,pay_run_result_values rrv

1705: SELECT sum(rrv.result_value) result_value
1706: ,count(rrv.RUN_RESULT_ID) record_count
1707: ,rrv.result_value UNIT_PRICE
1708: FROM pay_run_result_values pr
1709: ,pay_run_result_values rrv
1710: ,pay_run_results rr
1711: ,pay_assignment_actions paa
1712: ,pay_payroll_actions ppa
1713: WHERE pr.input_value_id(+) = p_group_by

Line 1731: FROM pay_run_result_values rrv

1727: ,p_assignment_action_id NUMBER) IS
1728: SELECT sum(rrv.result_value) result_value
1729: ,count(rrv.RUN_RESULT_ID) record_count
1730: ,rrv.result_value UNIT_PRICE
1731: FROM pay_run_result_values rrv
1732: ,pay_run_results rr
1733: ,pay_assignment_actions paa
1734: ,pay_payroll_actions ppa
1735: WHERE rrv.input_value_id = p_iv_id

Line 1756: FROM pay_run_result_values rrv1

1752: ,p_ele_type_id NUMBER
1753: ,p_assignment_action_id NUMBER
1754: ) IS
1755: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
1756: FROM pay_run_result_values rrv1
1757: ,pay_run_results rr1
1758: ,pay_assignment_actions paa
1759: ,pay_payroll_actions ppa
1760: ,pay_run_result_values rrv2

Line 1760: ,pay_run_result_values rrv2

1756: FROM pay_run_result_values rrv1
1757: ,pay_run_results rr1
1758: ,pay_assignment_actions paa
1759: ,pay_payroll_actions ppa
1760: ,pay_run_result_values rrv2
1761: ,pay_run_results rr2
1762: ,pay_run_result_values rrv3
1763: ,pay_run_results rr3
1764: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 1762: ,pay_run_result_values rrv3

1758: ,pay_assignment_actions paa
1759: ,pay_payroll_actions ppa
1760: ,pay_run_result_values rrv2
1761: ,pay_run_results rr2
1762: ,pay_run_result_values rrv3
1763: ,pay_run_results rr3
1764: WHERE rrv1.input_value_id = p_iv_id_UNIT
1765: AND rr1.element_type_id = p_ele_type_id
1766: AND rr1.run_result_id = rrv1.run_result_id

Line 1788: FROM pay_run_result_values rrv1

1784: ,p_ele_type_id NUMBER
1785: ,p_assignment_action_id NUMBER
1786: ) IS
1787: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
1788: FROM pay_run_result_values rrv1
1789: ,pay_run_results rr1
1790: ,pay_assignment_actions paa
1791: ,pay_payroll_actions ppa
1792: ,pay_run_result_values rrv2

Line 1792: ,pay_run_result_values rrv2

1788: FROM pay_run_result_values rrv1
1789: ,pay_run_results rr1
1790: ,pay_assignment_actions paa
1791: ,pay_payroll_actions ppa
1792: ,pay_run_result_values rrv2
1793: ,pay_run_results rr2
1794: ,pay_run_result_values rrv3
1795: ,pay_run_results rr3
1796: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 1794: ,pay_run_result_values rrv3

1790: ,pay_assignment_actions paa
1791: ,pay_payroll_actions ppa
1792: ,pay_run_result_values rrv2
1793: ,pay_run_results rr2
1794: ,pay_run_result_values rrv3
1795: ,pay_run_results rr3
1796: WHERE rrv1.input_value_id = p_iv_id_UNIT
1797: AND rr1.element_type_id = p_ele_type_id
1798: AND rr1.run_result_id = rrv1.run_result_id

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

1810:
1811: -----------------------------------------------------------------------------
1812:
1813: rec_get_element csr_get_element%ROWTYPE;
1814: l_result_value pay_run_result_values.result_value%TYPE := 0;
1815: l_action_info_id NUMBER;
1816: l_ovn NUMBER;
1817: l_element_context VARCHAR2(10);
1818: l_index NUMBER := 0;

Line 2879: FROM pay_run_result_values rrv

2875: CURSOR csr_result_value(p_iv_id NUMBER
2876: ,p_ele_type_id NUMBER
2877: ,p_assignment_action_id NUMBER) IS
2878: SELECT rrv.result_value,rr.element_entry_id
2879: FROM pay_run_result_values rrv
2880: ,pay_run_results rr
2881: ,pay_assignment_actions paa
2882: ,pay_payroll_actions ppa
2883: WHERE rrv.input_value_id = p_iv_id

Line 2898: FROM pay_run_result_values rrv

2894: ,p_ele_type_id NUMBER
2895: ,p_assignment_action_id NUMBER
2896: ,p_EE_ID NUMBER) IS
2897: SELECT rrv.result_value
2898: FROM pay_run_result_values rrv
2899: ,pay_run_results rr
2900: ,pay_assignment_actions paa
2901: ,pay_payroll_actions ppa
2902: WHERE rrv.input_value_id = p_iv_id

Line 2929: FROM pay_run_result_values rrv

2925: ) IS
2926: SELECT sum(rrv.result_value) result_value
2927: ,count(rrv.RUN_RESULT_ID) record_count
2928: ,rrv.result_value UNIT_PRICE
2929: FROM pay_run_result_values rrv
2930: ,pay_run_results rr
2931: ,pay_assignment_actions paa
2932: ,pay_payroll_actions ppa
2933: WHERE rrv.input_value_id = p_iv_id

Line 2949: FROM pay_run_result_values pr

2945: ,p_group_by NUMBER) IS
2946: SELECT sum(rrv.result_value) result_value
2947: ,count(rrv.RUN_RESULT_ID) record_count
2948: ,rrv.result_value UNIT_PRICE
2949: FROM pay_run_result_values pr
2950: ,pay_run_result_values rrv
2951: ,pay_run_results rr
2952: ,pay_assignment_actions paa
2953: ,pay_payroll_actions ppa

Line 2950: ,pay_run_result_values rrv

2946: SELECT sum(rrv.result_value) result_value
2947: ,count(rrv.RUN_RESULT_ID) record_count
2948: ,rrv.result_value UNIT_PRICE
2949: FROM pay_run_result_values pr
2950: ,pay_run_result_values rrv
2951: ,pay_run_results rr
2952: ,pay_assignment_actions paa
2953: ,pay_payroll_actions ppa
2954: WHERE pr.input_value_id(+) = p_group_by

Line 2970: FROM pay_run_result_values rrv

2966: /*CURSOR csr_sum_of_result_values(p_iv_id NUMBER
2967: ,p_ele_type_id NUMBER
2968: ,p_assignment_action_id NUMBER) IS
2969: SELECT sum(rrv.result_value) result_value
2970: FROM pay_run_result_values rrv
2971: ,pay_run_results rr
2972: ,pay_assignment_actions paa
2973: ,pay_payroll_actions ppa
2974: WHERE rrv.input_value_id = p_iv_id

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

2983: */
2984:
2985:
2986: rec_group_by csr_group_by%ROWTYPE;
2987: l_result_value pay_run_result_values.result_value%TYPE := 0;
2988:
2989: -----------------------------------------------------------------------------
2990: /* Cursor to retrieve sum of all run result value for an given Main Element */
2991: -----------------------------------------------------------------------------

Line 2997: FROM pay_run_result_values rrv1

2993: ,p_ele_type_id NUMBER
2994: ,p_assignment_action_id NUMBER
2995: ) IS
2996: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
2997: FROM pay_run_result_values rrv1
2998: ,pay_run_results rr1
2999: ,pay_assignment_actions paa
3000: ,pay_payroll_actions ppa
3001: ,pay_run_result_values rrv2

Line 3001: ,pay_run_result_values rrv2

2997: FROM pay_run_result_values rrv1
2998: ,pay_run_results rr1
2999: ,pay_assignment_actions paa
3000: ,pay_payroll_actions ppa
3001: ,pay_run_result_values rrv2
3002: ,pay_run_results rr2
3003: ,pay_run_result_values rrv3
3004: ,pay_run_results rr3
3005: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 3003: ,pay_run_result_values rrv3

2999: ,pay_assignment_actions paa
3000: ,pay_payroll_actions ppa
3001: ,pay_run_result_values rrv2
3002: ,pay_run_results rr2
3003: ,pay_run_result_values rrv3
3004: ,pay_run_results rr3
3005: WHERE rrv1.input_value_id = p_iv_id_UNIT
3006: AND rr1.element_type_id = p_ele_type_id
3007: AND rr1.run_result_id = rrv1.run_result_id

Line 3029: FROM pay_run_result_values rrv1

3025: ,p_ele_type_id NUMBER
3026: ,p_assignment_action_id NUMBER
3027: ) IS
3028: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
3029: FROM pay_run_result_values rrv1
3030: ,pay_run_results rr1
3031: ,pay_assignment_actions paa
3032: ,pay_payroll_actions ppa
3033: ,pay_run_result_values rrv2

Line 3033: ,pay_run_result_values rrv2

3029: FROM pay_run_result_values rrv1
3030: ,pay_run_results rr1
3031: ,pay_assignment_actions paa
3032: ,pay_payroll_actions ppa
3033: ,pay_run_result_values rrv2
3034: ,pay_run_results rr2
3035: ,pay_run_result_values rrv3
3036: ,pay_run_results rr3
3037: WHERE rrv1.input_value_id = p_iv_id_UNIT

Line 3035: ,pay_run_result_values rrv3

3031: ,pay_assignment_actions paa
3032: ,pay_payroll_actions ppa
3033: ,pay_run_result_values rrv2
3034: ,pay_run_results rr2
3035: ,pay_run_result_values rrv3
3036: ,pay_run_results rr3
3037: WHERE rrv1.input_value_id = p_iv_id_UNIT
3038: AND rr1.element_type_id = p_ele_type_id
3039: AND rr1.run_result_id = rrv1.run_result_id