APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 1063: --used to dertermine the rows to update in the pay_run_result_values

1059: pev_rec pev_cur%ROWTYPE;
1060:
1061: --Retrieve all affected rows in the pay_run_results table.
1062: --The run_result_id's from this cursor will then be
1063: --used to dertermine the rows to update in the pay_run_result_values
1064: --table note since run_result_id is driving for the value table we have to pick
1065: --up all regardless if the geocode has changed because they may have run result values
1066: --that are tagged to a different jurisdiction.
1067: --Right now if the patch is reran this cursor will still pick up assignments that have

Line 1733: FROM pay_run_result_values prv

1729: --
1730:
1731: cursor ele_run_result_val(p_new_juri_code VARCHAR2, p_run_result_id VARCHAR2, p_assign_act_id NUMBER,p_assign_id NUMBER)
1732: IS select distinct 'Y'
1733: FROM pay_run_result_values prv
1734: WHERE prv.result_value = p_new_juri_code
1735: AND prv.run_result_id = p_run_result_id
1736: AND EXISTS (SELECT 0
1737: FROM pay_input_values_f piv

Line 1748: and pugu.table_name = 'PAY_RUN_RESULT_VALUES'

1744: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1745: where pugu.assignment_id = p_assign_id
1746: and pugu.table_value_id = prv.run_result_id
1747: and pugu.old_juri_code = p_old_juri_code
1748: and pugu.table_name = 'PAY_RUN_RESULT_VALUES'
1749: and pugu.process_mode = g_mode
1750: and pugu.process_type = g_process_type
1751: and pugu.id = g_geo_phase_id);
1752:

Line 1783: --in the update of pay_run_result_values

1779: hr_utility.trace('Before update of run result values for assignment_action_id: '||to_char(p_assign_act_id));
1780:
1781: --
1782: --Per bug 2996546 changed the where clause in
1783: --in the update of pay_run_result_values
1784: --for piv.legislation_code = 'US'
1785: --to use the function IS_US_OR_CA_LEGISLATION and compare
1786: --input value id stored in pl/sql table to improve performance
1787: --

Line 1792: UPDATE pay_run_result_values prv

1788:
1789:
1790: IF G_MODE = 'UPGRADE' THEN
1791:
1792: UPDATE pay_run_result_values prv
1793: SET prv.result_value = p_new_juri_code
1794: WHERE prv.run_result_id = p_run_result_id
1795: AND prv.result_value = p_old_juri_code
1796: AND EXISTS (SELECT 0

Line 1822: p_location => 'PAY_RUN_RESULT_VALUES',

1818: p_person_id => p_person_id,
1819: p_assign_id => p_assign_id,
1820: p_old_juri_code => p_old_juri_code,
1821: p_new_juri_code => p_new_juri_code,
1822: p_location => 'PAY_RUN_RESULT_VALUES',
1823: p_id => p_run_result_id);
1824:
1825: CLOSE ele_run_result_val;
1826:

Line 1848: p_location => 'PAY_RUN_RESULT_VALUES',

1844: p_person_id => p_person_id,
1845: p_assign_id => p_assign_id,
1846: p_old_juri_code => p_old_juri_code,
1847: p_new_juri_code => p_new_juri_code,
1848: p_location => 'PAY_RUN_RESULT_VALUES',
1849: p_id => p_run_result_id);
1850:
1851: CLOSE ele_run_result_val;
1852:

Line 1873: p_location => 'PAY_RUN_RESULT_VALUES',

1869: p_person_id => p_person_id,
1870: p_assign_id => p_assign_id,
1871: p_old_juri_code => p_old_juri_code,
1872: p_new_juri_code => p_new_juri_code,
1873: p_location => 'PAY_RUN_RESULT_VALUES',
1874: p_id => p_run_result_id);
1875:
1876: END IF;
1877: