APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1637: ,pay_run_results rr

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
1641: AND rr.element_type_id = p_ele_type_id

Line 1656: ,pay_run_results rr

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
1660: AND rr.element_type_id = p_ele_type_id

Line 1689: ,pay_run_results rr

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
1693: AND rr.element_type_id = p_ele_type_id

Line 1710: ,pay_run_results rr

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
1714: AND rrv.input_value_id = p_iv_id

Line 1732: ,pay_run_results rr

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
1736: AND rr.element_type_id = p_ele_type_id

Line 1757: ,pay_run_results rr1

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
1761: ,pay_run_results rr2

Line 1761: ,pay_run_results rr2

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
1765: AND rr1.element_type_id = p_ele_type_id

Line 1763: ,pay_run_results rr3

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
1767: AND rr1.assignment_action_id = paa.assignment_action_id

Line 1789: ,pay_run_results rr1

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
1793: ,pay_run_results rr2

Line 1793: ,pay_run_results rr2

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
1797: AND rr1.element_type_id = p_ele_type_id

Line 1795: ,pay_run_results rr3

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
1799: AND rr1.assignment_action_id = paa.assignment_action_id

Line 2880: ,pay_run_results rr

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
2884: AND rr.element_type_id = p_ele_type_id

Line 2899: ,pay_run_results rr

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
2903: AND rr.element_type_id = p_ele_type_id

Line 2930: ,pay_run_results rr

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
2934: AND rr.element_type_id = p_ele_type_id

Line 2951: ,pay_run_results rr

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
2955: AND rrv.input_value_id = p_iv_id

Line 2971: ,pay_run_results rr

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
2975: AND rr.element_type_id = p_ele_type_id

Line 2998: ,pay_run_results rr1

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
3002: ,pay_run_results rr2

Line 3002: ,pay_run_results rr2

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
3006: AND rr1.element_type_id = p_ele_type_id

Line 3004: ,pay_run_results rr3

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
3008: AND rr1.assignment_action_id = paa.assignment_action_id

Line 3030: ,pay_run_results rr1

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
3034: ,pay_run_results rr2

Line 3034: ,pay_run_results rr2

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
3038: AND rr1.element_type_id = p_ele_type_id

Line 3036: ,pay_run_results rr3

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
3040: AND rr1.assignment_action_id = paa.assignment_action_id