APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 426: FROM pay_payroll_actions ppa

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:
429: hr_utility.trace('Mode of Execution ' ||l_mode);
430:

Line 462: FROM pay_payroll_actions ppa,

458: p_element_set_id pay_element_sets.element_set_id%TYPE) IS
459:
460: CURSOR get_assignment_actions(p_assignment_id NUMBER) IS
461: SELECT assignment_action_id
462: FROM pay_payroll_actions ppa,
463: pay_assignment_actions paa
464: WHERE paa.assignment_id = p_assignment_id
465: AND ppa.payroll_action_id = paa.payroll_action_id
466: AND ppa.action_type in ('Q','B','R','I','V')

Line 472: FROM pay_payroll_actions ppa,

468: AND paa.action_status = 'C';
469:
470: CURSOR get_archive_asg_actions(p_assignment_id NUMBER) IS
471: SELECT assignment_action_id
472: FROM pay_payroll_actions ppa,
473: pay_assignment_actions paa
474: WHERE paa.assignment_id = p_assignment_id
475: AND ppa.payroll_action_id = paa.payroll_action_id
476: AND ppa.action_type in ('X')

Line 483: FROM pay_payroll_actions ppa,

479:
480: -- Added for bug 14213838.
481: CURSOR get_psd_archive_asg_actions(p_assignment_id NUMBER) IS
482: SELECT assignment_action_id
483: FROM pay_payroll_actions ppa,
484: pay_assignment_actions paa
485: WHERE paa.assignment_id = p_assignment_id
486: AND ppa.payroll_action_id = paa.payroll_action_id
487: AND ppa.action_type in ('X')

Line 1200: FROM pay_payroll_actions ppa

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:
1203: IF l_mode = 'GENERATE' THEN
1204:

Line 1273: FROM pay_payroll_actions ppa

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
1277: (

Line 1426: FROM pay_payroll_actions ppa

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;
1430: l_object_id pay_assignment_actions.object_id%TYPE;

Line 1429: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

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;
1430: l_object_id pay_assignment_actions.object_id%TYPE;
1431: l_object_type pay_assignment_actions.object_type%TYPE;
1432: l_mode VARCHAR2(8);
1433: l_element_set_id pay_element_sets.element_set_id%TYPE;

Line 1695: FROM pay_payroll_actions ppa

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.
1699: CURSOR get_psd_pact_id IS

Line 1702: FROM pay_payroll_actions ppa

1698: -- Added for bug 14213838.
1699: CURSOR get_psd_pact_id IS
1700: SELECT DISTINCT
1701: ppa.payroll_action_id
1702: FROM pay_payroll_actions ppa
1703: WHERE ppa.report_type='PSD_MAG_XML';
1704:
1705: -- Added for bug 14213838.
1706: CURSOR get_hr_org_upgrade_details(p_mode VARCHAR2,p_date DATE) IS