DBA Data[Home] [Help]

APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_PEOPLE_F

Line 28: (full_name per_people_f.full_name%type

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

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

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

Line 32: ,benefit_group_id per_people_f.benefit_group_id%type

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