50: /*Get the MODE of Execution for the User Defined City Upgrade Process*/
51:
52: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)
53: INTO l_mode
54: FROM pay_payroll_actions ppa
55: WHERE ppa.payroll_action_id = pactid;
56:
57: SELECT pay_patch_status_s.NEXTVAL
58: INTO l_id FROM dual;
280: ORDER BY pps.id DESC;
281:
282: CURSOR c_mode (p_payroll_action_id NUMBER) IS
283: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
284: FROM pay_payroll_actions ppa
285: WHERE ppa.payroll_action_id = p_payroll_action_id;
286:
287: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
288: l_assignment_id pay_assignment_actions.object_id%TYPE;
283: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
284: FROM pay_payroll_actions ppa
285: WHERE ppa.payroll_action_id = p_payroll_action_id;
286:
287: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
288: l_assignment_id pay_assignment_actions.object_id%TYPE;
289: l_mode VARCHAR2(8);
290: l_id pay_patch_status.id%TYPE;
291: l_patch_name pay_patch_status.patch_name%TYPE;
346: = DECODE(p_status,'ALL',DECODE(pugu.status,'C','C','E'),p_status));
347:
348: CURSOR c_mode ( p_payroll_action_id NUMBER) IS
349: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
350: FROM pay_payroll_actions ppa
351: WHERE ppa.payroll_action_id = p_payroll_action_id;
352:
353: CURSOR get_user_city_update_details IS
354: SELECT pugu.old_juri_code,