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.HR_PERIODS_OF_SERVICE_API dependencies on PER_ASSIGNMENTS_F

Line 779: ,per_assignments_f asg

775: CURSOR csr_compl_pay_act IS
776: SELECT NULL
777: FROM pay_payroll_actions ppa
778: ,pay_assignment_actions paa
779: ,per_assignments_f asg
780: ,per_periods_of_service pds
781: WHERE pds.period_of_service_id = p_period_of_service_id
782: AND pds.person_id = asg.person_id
783: AND asg.period_of_service_id = pds.period_of_service_id

Line 800: FROM per_assignments_f asg

796: ,asg.effective_start_date
797: ,asg.effective_end_date
798: ,asg.object_version_number
799: ,pds.actual_termination_date
800: FROM per_assignments_f asg
801: ,per_periods_of_service pds
802: WHERE pds.period_of_service_id = p_period_of_service_id
803: AND pds.person_id = asg.person_id
804: AND pds.period_of_service_id = asg.period_of_service_id

Line 807: l_assignment_id per_assignments_f.assignment_id%TYPE;

803: AND pds.person_id = asg.person_id
804: AND pds.period_of_service_id = asg.period_of_service_id
805: AND asg.effective_end_date = p_old_final_process_date;
806: --
807: l_assignment_id per_assignments_f.assignment_id%TYPE;
808: l_object_version_number per_assignments_f.object_version_number%TYPE;
809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 808: l_object_version_number per_assignments_f.object_version_number%TYPE;

804: AND pds.period_of_service_id = asg.period_of_service_id
805: AND asg.effective_end_date = p_old_final_process_date;
806: --
807: l_assignment_id per_assignments_f.assignment_id%TYPE;
808: l_object_version_number per_assignments_f.object_version_number%TYPE;
809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
812: l_new_final_process_date per_periods_of_service.final_process_date%TYPE;

Line 810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

806: --
807: l_assignment_id per_assignments_f.assignment_id%TYPE;
808: l_object_version_number per_assignments_f.object_version_number%TYPE;
809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
812: l_new_final_process_date per_periods_of_service.final_process_date%TYPE;
813:
814: l_system_status per_assignment_status_types.per_system_status%TYPE;

Line 811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;

807: l_assignment_id per_assignments_f.assignment_id%TYPE;
808: l_object_version_number per_assignments_f.object_version_number%TYPE;
809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
812: l_new_final_process_date per_periods_of_service.final_process_date%TYPE;
813:
814: l_system_status per_assignment_status_types.per_system_status%TYPE;
815: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;

Line 835: FROM per_assignments_f asg

831: --
832: CURSOR csr_asg_ovn (p_assignment_id NUMBER
833: ,p_effective_date DATE) IS
834: SELECT asg.object_version_number
835: FROM per_assignments_f asg
836: WHERE asg.assignment_id = csr_asg_ovn.p_assignment_id
837: AND csr_asg_ovn.p_effective_date BETWEEN asg.effective_start_date
838: AND asg.effective_end_date;
839: --

Line 847: FROM per_assignments_f asg

843: -- Locking ladder cursors
844: --
845: CURSOR csr_asgs IS
846: SELECT NULL
847: FROM per_assignments_f asg
848: ,per_periods_of_service pds
849: WHERE pds.period_of_service_id = p_period_of_service_id
850: AND pds.period_of_service_id = asg.period_of_service_id
851: AND pds.person_id = asg.person_id

Line 1099: UPDATE per_assignments_f

1095: IF csr_get_ast_status_details%FOUND THEN
1096:
1097: hr_utility.set_location(l_proc, 81);
1098:
1099: UPDATE per_assignments_f
1100: SET effective_end_date = l_new_final_process_date
1101: WHERE assignment_id = l_assignment_id
1102: AND effective_start_date = l_effective_start_date
1103: AND effective_end_date = l_effective_end_date