453: l_dob_null_warning boolean;
454: l_orig_hire_warning boolean;
455: l_assignment_id number;
456: l_asg_object_version_number number;
457: l_assignment_sequence per_assignments_f.assignment_sequence%type;
458: l_assignment_number per_assignments_f.assignment_number%type;
459: l_name_combination_warning boolean;
460: l_period_of_placement_id number;
461: l_pdp_object_version_number number;
454: l_orig_hire_warning boolean;
455: l_assignment_id number;
456: l_asg_object_version_number number;
457: l_assignment_sequence per_assignments_f.assignment_sequence%type;
458: l_assignment_number per_assignments_f.assignment_number%type;
459: l_name_combination_warning boolean;
460: l_period_of_placement_id number;
461: l_pdp_object_version_number number;
462: l_phn_object_version_number number;
1132: l_pdp_object_version_number number;
1133: l_assignment_id number;
1134: l_asg_object_version_number number;
1135: l_assignment_sequence number;
1136: l_assignment_number per_assignments_f.assignment_number%type;
1137: --
1138: cursor csr_per_details
1139: (p_person_id number
1140: ,p_effective_date date