APPS.PAY_US_GEO_UPD_PKG dependencies on PAY_RUN_RESULTS

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

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

Line 874: FROM pay_run_results prr

870:
871: CURSOR prr_cur(assign_action_id NUMBER,assign_id NUMBER) IS
872: SELECT distinct prr.run_result_id,
873: prr.assignment_action_id, prr.jurisdiction_code
874: FROM pay_run_results prr
875: WHERE prr.assignment_action_id = assign_action_id
876: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
877: where pugu.assignment_id = assign_id
878: and pugu.table_value_id = prr.run_result_id

Line 880: and pugu.table_name = 'PAY_RUN_RESULTS'

876: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
877: where pugu.assignment_id = assign_id
878: and pugu.table_value_id = prr.run_result_id
879: and pugu.old_juri_code = prr.jurisdiction_code
880: and pugu.table_name = 'PAY_RUN_RESULTS'
881: and pugu.process_mode = g_mode
882: and pugu.process_type = g_process_type
883: and pugu.id = g_geo_phase_id);
884:

Line 1519: FROM pay_run_results prr

1515:
1516: cursor ele_run_results(p_new_juri_code VARCHAR2, p_old_juri_code VARCHAR2, p_run_result_id VARCHAR2,
1517: p_assign_act_id NUMBER)
1518: IS select distinct 'Y'
1519: FROM pay_run_results prr
1520: WHERE prr.jurisdiction_code = p_new_juri_code
1521: AND prr.run_result_id = p_run_result_id
1522: AND prr.assignment_action_id = p_assign_act_id
1523: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu

Line 1527: and pugu.table_name = 'PAY_RUN_RESULTS'

1523: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
1524: where pugu.assignment_id = p_assign_id
1525: and pugu.table_value_id = prr.run_result_id
1526: and pugu.old_juri_code = p_old_juri_code
1527: and pugu.table_name = 'PAY_RUN_RESULTS'
1528: and pugu.process_mode = g_mode
1529: and pugu.process_type = g_process_type
1530: and pugu.id = g_geo_phase_id);
1531:

Line 1625: UPDATE pay_run_results

1621: hr_utility.trace('Before update of run results for assignment_action_id: '||to_char(p_assign_act_id));
1622:
1623: IF G_MODE = 'UPGRADE' THEN
1624:
1625: UPDATE pay_run_results
1626: SET jurisdiction_code = p_new_juri_code
1627: WHERE jurisdiction_code = p_old_juri_code
1628: AND run_result_id = p_run_result_id
1629: AND assignment_action_id = p_assign_act_id;

Line 1648: p_location => 'PAY_RUN_RESULTS',

1644: p_person_id => p_person_id,
1645: p_assign_id => p_assign_id,
1646: p_old_juri_code => p_old_juri_code,
1647: p_new_juri_code => p_new_juri_code,
1648: p_location => 'PAY_RUN_RESULTS',
1649: p_id => p_run_result_id);
1650:
1651: CLOSE ele_run_results;
1652:

Line 1670: p_location => 'PAY_RUN_RESULTS',

1666: p_person_id => p_person_id,
1667: p_assign_id => p_assign_id,
1668: p_old_juri_code => p_old_juri_code,
1669: p_new_juri_code => p_new_juri_code,
1670: p_location => 'PAY_RUN_RESULTS',
1671: p_id => p_run_result_id);
1672:
1673: END IF;
1674: