420: fnd_file.put_line(fnd_file.log,'Processing required');
421:
422: /*Get the MODE of Execution for the PSDCODE Process*/
423:
424: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)
425: INTO l_mode
426: FROM pay_payroll_actions ppa
427: WHERE ppa.payroll_action_id = p_payroll_action_id;
428:
1194: IF l_upgrade_needed = 'Y' THEN
1195:
1196: /*Get the MODE of Execution for the PSDCODE Process*/
1197:
1198: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)
1199: INTO l_mode
1200: FROM pay_payroll_actions ppa
1201: WHERE ppa.payroll_action_id = pactid;
1202:
1268: endperson IN NUMBER,
1269: chunk IN NUMBER) IS
1270:
1271: CURSOR c_mode (p_payroll_action_id number) IS
1272: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)
1273: FROM pay_payroll_actions ppa
1274: WHERE ppa.payroll_action_id = p_payroll_action_id;
1275:
1276: CURSOR c_generate_assignments
1421: FROM pay_temp_object_actions paa
1422: WHERE paa.object_action_id = p_assignment_action_id;
1423:
1424: CURSOR c_mode ( p_payroll_action_id NUMBER) IS
1425: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
1426: FROM pay_payroll_actions ppa
1427: WHERE ppa.payroll_action_id = p_payroll_action_id;
1428:
1429: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1690: AND pugu.assignment_id > 0
1691: AND NVL(pugu.status,'NULL') = DECODE(p_status,'ALL',NVL(pugu.status,'NULL'),p_status));
1692:
1693: CURSOR c_mode ( p_payroll_action_id NUMBER) IS
1694: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
1695: FROM pay_payroll_actions ppa
1696: WHERE ppa.payroll_action_id = p_payroll_action_id;
1697:
1698: -- Added for bug 14213838.