APPS.HR_PERIODS_OF_SERVICE_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 814: l_system_status per_assignment_status_types.per_system_status%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;
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;

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;