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_ALL_ASSIGNMENTS_F

Line 815: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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;
816: l_rec per_all_assignments_f%ROWTYPE;
817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;

Line 816: l_rec per_all_assignments_f%ROWTYPE;

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;
816: l_rec per_all_assignments_f%ROWTYPE;
817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

Line 817: l_created_by per_all_assignments_f.created_by%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;
816: l_rec per_all_assignments_f%ROWTYPE;
817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
821: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

Line 818: l_creation_date per_all_assignments_f.creation_date%TYPE;

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;
816: l_rec per_all_assignments_f%ROWTYPE;
817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
821: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
822: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;

815: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%TYPE;
816: l_rec per_all_assignments_f%ROWTYPE;
817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
821: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
822: l_legislation_code per_business_groups.legislation_code%TYPE;
823: --

Line 820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;

816: l_rec per_all_assignments_f%ROWTYPE;
817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
821: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
822: l_legislation_code per_business_groups.legislation_code%TYPE;
823: --
824: -- 115.16 (START)

Line 821: l_last_update_login per_all_assignments_f.last_update_login%TYPE;

817: l_created_by per_all_assignments_f.created_by%TYPE;
818: l_creation_date per_all_assignments_f.creation_date%TYPE;
819: l_last_update_date per_all_assignments_f.last_update_date%TYPE;
820: l_last_updated_by per_all_assignments_f.last_updated_by%TYPE;
821: l_last_update_login per_all_assignments_f.last_update_login%TYPE;
822: l_legislation_code per_business_groups.legislation_code%TYPE;
823: --
824: -- 115.16 (START)
825: --

Line 921: FROM per_assignment_status_types ast,per_all_assignments_f paaf

917: --
918:
919: CURSOR csr_get_ast_status_details(p_assignment_id NUMBER) IS
920: SELECT ast.per_system_status
921: FROM per_assignment_status_types ast,per_all_assignments_f paaf
922: WHERE ast.assignment_status_type_id = paaf.assignment_status_type_id
923: AND paaf.assignment_id=p_assignment_id
924: AND ast.per_system_status='TERM_ASSIGN'
925: AND paaf.effective_end_date=p_old_final_process_date;

Line 928: SELECT * from per_all_assignments_f paaf

924: AND ast.per_system_status='TERM_ASSIGN'
925: AND paaf.effective_end_date=p_old_final_process_date;
926:
927: CURSOR assgn_rec (p_assignment_id NUMBER) is
928: SELECT * from per_all_assignments_f paaf
929: WHERE paaf.assignment_id=p_assignment_id
930: AND paaf.effective_end_date=p_old_final_process_date;
931:
932:

Line 1136: INSERT INTO per_all_assignments_f

1132: ,p_person_type => l_assignment_status_type_id);
1133:
1134: hr_utility.set_location(l_proc, 85);
1135:
1136: INSERT INTO per_all_assignments_f
1137: ( assignment_id,
1138: effective_start_date,
1139: effective_end_date,
1140: business_group_id,