APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_US_GEO_UPD_PKG

Line 52: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)

48: hr_utility.trace('Start of Initial Setup');
49:
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:

Line 283: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)

279: AND pps.legislation_code = 'US')
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;

Line 312: pay_us_geo_upd_pkg.upgrade_geocodes(l_assignment_id,l_assignment_id,l_id,l_mode,l_patch_name);

308: CLOSE c_patch_details;
309:
310: hr_utility.trace('Calling Geocode Upgrade for Assignment '||l_assignment_id);
311:
312: pay_us_geo_upd_pkg.upgrade_geocodes(l_assignment_id,l_assignment_id,l_id,l_mode,l_patch_name);
313:
314: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.archive_code');
315: hr_utility.trace('for Assignment Action ID : '||p_xfr_action_id);
316:

Line 349: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)

345: AND DECODE(pugu.status,'C','C','E')
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