43: g_audit_flag boolean :=false;
44: -- Types declaration.
45: --
46: Type g_cache_person_rec is record
47: (full_name per_people_f.full_name%type
48: ,date_of_birth per_people_f.date_of_birth%type
49: ,date_of_death per_people_f.date_of_death%type
50: ,benefit_group ben_benfts_grp.name%type
51: ,benefit_group_id per_people_f.benefit_group_id%type
44: -- Types declaration.
45: --
46: Type g_cache_person_rec is record
47: (full_name per_people_f.full_name%type
48: ,date_of_birth per_people_f.date_of_birth%type
49: ,date_of_death per_people_f.date_of_death%type
50: ,benefit_group ben_benfts_grp.name%type
51: ,benefit_group_id per_people_f.benefit_group_id%type
52: ,postal_code per_addresses.postal_code%type
45: --
46: Type g_cache_person_rec is record
47: (full_name per_people_f.full_name%type
48: ,date_of_birth per_people_f.date_of_birth%type
49: ,date_of_death per_people_f.date_of_death%type
50: ,benefit_group ben_benfts_grp.name%type
51: ,benefit_group_id per_people_f.benefit_group_id%type
52: ,postal_code per_addresses.postal_code%type
53: ,national_identifier per_people_f.national_identifier%type
47: (full_name per_people_f.full_name%type
48: ,date_of_birth per_people_f.date_of_birth%type
49: ,date_of_death per_people_f.date_of_death%type
50: ,benefit_group ben_benfts_grp.name%type
51: ,benefit_group_id per_people_f.benefit_group_id%type
52: ,postal_code per_addresses.postal_code%type
53: ,national_identifier per_people_f.national_identifier%type
54: ,person_has_type_emp varchar2(1)
55: ,assignment_id per_assignments_f.assignment_id%type
49: ,date_of_death per_people_f.date_of_death%type
50: ,benefit_group ben_benfts_grp.name%type
51: ,benefit_group_id per_people_f.benefit_group_id%type
52: ,postal_code per_addresses.postal_code%type
53: ,national_identifier per_people_f.national_identifier%type
54: ,person_has_type_emp varchar2(1)
55: ,assignment_id per_assignments_f.assignment_id%type
56: ,fte_value per_assignment_budget_values.value%type
57: ,total_fte_value per_assignment_budget_values.value%type