DBA Data[Home] [Help]

APPS.BEN_BATCH_UTILS dependencies on PER_PEOPLE_F

Line 47: (full_name per_people_f.full_name%type

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

Line 48: ,date_of_birth per_people_f.date_of_birth%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

Line 49: ,date_of_death per_people_f.date_of_death%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

Line 51: ,benefit_group_id per_people_f.benefit_group_id%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

Line 53: ,national_identifier per_people_f.national_identifier%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