eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 463: pay_assignment_actions paa

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')
467: AND ppa.effective_date >= to_date('01-01-2012','DD-MM-YYYY')

Line 473: pay_assignment_actions paa

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')
477: AND ppa.report_type = 'XFR_INTERFACE'

Line 484: pay_assignment_actions paa

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')
488: AND ppa.report_type = 'PSD_MAG_XML'

Line 530: TYPE rec_assignment_action_id IS TABLE OF pay_assignment_actions.assignment_action_id%TYPE INDEX BY BINARY_INTEGER;

526: AND substr(pumg1.city_name,1,6) = substr(pumg2.city_name,8,6)
527: AND substr(pumg2.city_name,1,6) = substr(pumg1.city_name,8,6)
528: ORDER BY 1,2;
529:
530: TYPE rec_assignment_action_id IS TABLE OF pay_assignment_actions.assignment_action_id%TYPE INDEX BY BINARY_INTEGER;
531: tab_assignment_action_id rec_assignment_action_id;
532:
533: l_old_psd_code VARCHAR2(6);
534: l_new_psd_code VARCHAR2(6);

Line 1350: SELECT pay_assignment_actions_s.nextval

1346: WHILE (c_generate_assignments%FOUND)
1347:
1348: LOOP
1349:
1350: SELECT pay_assignment_actions_s.nextval
1351: INTO l_locking_action_id
1352: FROM DUAL;
1353:
1354: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,

Line 1384: SELECT pay_assignment_actions_s.nextval

1380: WHILE (c_upgrade_assignments%FOUND)
1381:
1382: LOOP
1383:
1384: SELECT pay_assignment_actions_s.nextval
1385: INTO l_locking_action_id
1386: FROM DUAL;
1387:
1388: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,

Line 1430: l_object_id pay_assignment_actions.object_id%TYPE;

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;
1434: l_id pay_patch_status.id%TYPE;

Line 1431: l_object_type pay_assignment_actions.object_type%TYPE;

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;
1434: l_id pay_patch_status.id%TYPE;
1435: l_date DATE;