24: index by binary_integer;
25: g_cache_person_process g_cache_person_process_rec;
26:
27: type g_cache_person_rec is record
28: (full_name per_people_f.full_name%type
29: ,date_of_birth per_people_f.date_of_birth%type
30: ,date_of_death per_people_f.date_of_death%type
31: ,benefit_group ben_benfts_grp.name%type
32: ,benefit_group_id per_people_f.benefit_group_id%type
25: g_cache_person_process g_cache_person_process_rec;
26:
27: type g_cache_person_rec is record
28: (full_name per_people_f.full_name%type
29: ,date_of_birth per_people_f.date_of_birth%type
30: ,date_of_death per_people_f.date_of_death%type
31: ,benefit_group ben_benfts_grp.name%type
32: ,benefit_group_id per_people_f.benefit_group_id%type
33: ,postal_code per_addresses.postal_code%type
26:
27: type g_cache_person_rec is record
28: (full_name per_people_f.full_name%type
29: ,date_of_birth per_people_f.date_of_birth%type
30: ,date_of_death per_people_f.date_of_death%type
31: ,benefit_group ben_benfts_grp.name%type
32: ,benefit_group_id per_people_f.benefit_group_id%type
33: ,postal_code per_addresses.postal_code%type
34: ,person_has_type_emp varchar2(1)
28: (full_name per_people_f.full_name%type
29: ,date_of_birth per_people_f.date_of_birth%type
30: ,date_of_death per_people_f.date_of_death%type
31: ,benefit_group ben_benfts_grp.name%type
32: ,benefit_group_id per_people_f.benefit_group_id%type
33: ,postal_code per_addresses.postal_code%type
34: ,person_has_type_emp varchar2(1)
35: ,assignment_id per_assignments_f.assignment_id%type
36: ,per_system_status per_assignment_status_types.per_system_status%type