APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_RUN_RESULT_VALUES

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

850: pev_rec pev_cur%ROWTYPE;
851:
852: --Retrieve all affected rows in the pay_run_results table.
853: --The run_result_id's from this cursor will then be
854: --used to dertermine the rows to update in the pay_run_result_values
855: --table note since run_result_id is driving for the value table we have to pick
856: --up all regardless if the geocode has changed because they may have run result values
857: --that are tagged to a different jurisdiction.
858: --Right now if the patch is reran this cursor will still pick up assignments that have

Line 1495: FROM pay_run_result_values prv

1491: --
1492:
1493: cursor ele_run_result_val(p_new_juri_code VARCHAR2, p_run_result_id VARCHAR2, p_assign_act_id NUMBER,p_assign_id NUMBER)
1494: IS select distinct 'Y'
1495: FROM pay_run_result_values prv
1496: WHERE prv.result_value = p_new_juri_code
1497: AND prv.run_result_id = p_run_result_id
1498: AND EXISTS (SELECT 0
1499: FROM pay_input_values_f piv

Line 1510: and pugu.table_name = 'PAY_RUN_RESULT_VALUES'

1506: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1507: where pugu.assignment_id = p_assign_id
1508: and pugu.table_value_id = prv.run_result_id
1509: and pugu.old_juri_code = p_old_juri_code
1510: and pugu.table_name = 'PAY_RUN_RESULT_VALUES'
1511: and pugu.process_mode = g_mode
1512: and pugu.process_type = g_process_type
1513: and pugu.id = g_geo_phase_id);
1514:

Line 1545: --in the update of pay_run_result_values

1541: hr_utility.trace('Before update of run result values for assignment_action_id: '||to_char(p_assign_act_id));
1542:
1543: --
1544: --Per bug 2996546 changed the where clause in
1545: --in the update of pay_run_result_values
1546: --for piv.legislation_code = 'US'
1547: --to use the function IS_US_OR_CA_LEGISLATION and compare
1548: --input value id stored in pl/sql table to improve performance
1549: --

Line 1554: UPDATE pay_run_result_values prv

1550:
1551:
1552: IF G_MODE = 'UPGRADE' THEN
1553:
1554: UPDATE pay_run_result_values prv
1555: SET prv.result_value = p_new_juri_code
1556: WHERE prv.run_result_id = p_run_result_id
1557: AND prv.result_value = p_old_juri_code
1558: AND EXISTS (SELECT 0

Line 1585: p_location => 'PAY_RUN_RESULT_VALUES',

1581: p_person_id => p_person_id,
1582: p_assign_id => p_assign_id,
1583: p_old_juri_code => p_old_juri_code,
1584: p_new_juri_code => p_new_juri_code,
1585: p_location => 'PAY_RUN_RESULT_VALUES',
1586: p_id => p_run_result_id);
1587:
1588: CLOSE ele_run_result_val;
1589:

Line 1609: p_location => 'PAY_RUN_RESULT_VALUES',

1605: p_person_id => p_person_id,
1606: p_assign_id => p_assign_id,
1607: p_old_juri_code => p_old_juri_code,
1608: p_new_juri_code => p_new_juri_code,
1609: p_location => 'PAY_RUN_RESULT_VALUES',
1610: p_id => p_run_result_id);
1611:
1612: END IF;
1613: