APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_RUN_RESULTS

Line 1061: --Retrieve all affected rows in the pay_run_results table.

1057: and pugu.id = g_geo_phase_id);
1058:
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

Line 1083: FROM pay_run_results prr

1079:
1080: CURSOR prr_cur(assign_action_id NUMBER,assign_id NUMBER) IS
1081: SELECT distinct prr.run_result_id,
1082: prr.assignment_action_id, prr.jurisdiction_code
1083: FROM pay_run_results prr
1084: WHERE prr.assignment_action_id = assign_action_id
1085: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1086: where pugu.assignment_id = assign_id
1087: and pugu.table_value_id = prr.run_result_id

Line 1089: and pugu.table_name = 'PAY_RUN_RESULTS'

1085: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1086: where pugu.assignment_id = assign_id
1087: and pugu.table_value_id = prr.run_result_id
1088: and pugu.old_juri_code = prr.jurisdiction_code
1089: and pugu.table_name = 'PAY_RUN_RESULTS'
1090: and pugu.process_mode = g_mode
1091: and pugu.process_type = g_process_type
1092: and pugu.id = g_geo_phase_id);
1093:

Line 1757: FROM pay_run_results prr

1753:
1754: cursor ele_run_results(p_new_juri_code VARCHAR2, p_old_juri_code VARCHAR2, p_run_result_id VARCHAR2,
1755: p_assign_act_id NUMBER)
1756: IS select distinct 'Y'
1757: FROM pay_run_results prr
1758: WHERE prr.jurisdiction_code = p_new_juri_code
1759: AND prr.run_result_id = p_run_result_id
1760: AND prr.assignment_action_id = p_assign_act_id
1761: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu

Line 1765: and pugu.table_name = 'PAY_RUN_RESULTS'

1761: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1762: where pugu.assignment_id = p_assign_id
1763: and pugu.table_value_id = prr.run_result_id
1764: and pugu.old_juri_code = p_old_juri_code
1765: and pugu.table_name = 'PAY_RUN_RESULTS'
1766: and pugu.process_mode = g_mode
1767: and pugu.process_type = g_process_type
1768: and pugu.id = g_geo_phase_id);
1769:

Line 1889: UPDATE pay_run_results

1885: hr_utility.trace('Before update of run results for assignment_action_id: '||to_char(p_assign_act_id));
1886:
1887: IF G_MODE = 'UPGRADE' THEN
1888:
1889: UPDATE pay_run_results
1890: SET jurisdiction_code = p_new_juri_code
1891: WHERE jurisdiction_code = p_old_juri_code
1892: AND run_result_id = p_run_result_id
1893: AND assignment_action_id = p_assign_act_id;

Line 1910: p_location => 'PAY_RUN_RESULTS',

1906: p_person_id => p_person_id,
1907: p_assign_id => p_assign_id,
1908: p_old_juri_code => p_old_juri_code,
1909: p_new_juri_code => p_new_juri_code,
1910: p_location => 'PAY_RUN_RESULTS',
1911: p_id => p_run_result_id);
1912:
1913: CLOSE ele_run_results;
1914:

Line 1936: p_location => 'PAY_RUN_RESULTS',

1932: p_person_id => p_person_id,
1933: p_assign_id => p_assign_id,
1934: p_old_juri_code => p_old_juri_code,
1935: p_new_juri_code => p_new_juri_code,
1936: p_location => 'PAY_RUN_RESULTS',
1937: p_id => p_run_result_id);
1938:
1939: CLOSE ele_run_results;
1940:

Line 1960: p_location => 'PAY_RUN_RESULTS',

1956: p_person_id => p_person_id,
1957: p_assign_id => p_assign_id,
1958: p_old_juri_code => p_old_juri_code,
1959: p_new_juri_code => p_new_juri_code,
1960: p_location => 'PAY_RUN_RESULTS',
1961: p_id => p_run_result_id);
1962:
1963: END IF;
1964: