DBA Data[Home] [Help]

APPS.BEN_PERSON_RECORD dependencies on PER_ALL_PEOPLE_F

Line 9: ,ben_ssn per_all_people_f.national_identifier%type

5: (plan_type_name ben_pl_typ_f.name%type
6: ,plan_name ben_pl_f.name%type
7: ,option_name ben_opt_f.name%type
8: ,beneficiary VARCHAR2(400)
9: ,ben_ssn per_all_people_f.national_identifier%type
10: ,ben_relation VARCHAR2(400)
11: ,primary_bnf NUMBER
12: ,contingent_bnf NUMBER
13: ,le_name ben_ler_f.name%type

Line 14: ,ben_full_name per_all_people_f.full_name%type

10: ,ben_relation VARCHAR2(400)
11: ,primary_bnf NUMBER
12: ,contingent_bnf NUMBER
13: ,le_name ben_ler_f.name%type
14: ,ben_full_name per_all_people_f.full_name%type
15: );
16:
17: TYPE g_dependent_rec_type IS RECORD
18: (

Line 19: name per_all_people_f.full_name%type,

15: );
16:
17: TYPE g_dependent_rec_type IS RECORD
18: (
19: name per_all_people_f.full_name%type,
20: relationship VARCHAR2(400),
21: type_of_benefit ben_pl_typ_f.name%type,
22: coverage VARCHAR2(100)
23: );