DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on BEN_PL_TYP_F

Line 1257: (plan_type_name ben_pl_typ_f.name%type

1253:
1254: /* Benefits reocrd types and tables */
1255:
1256: TYPE g_beneficiary_rec_type IS RECORD
1257: (plan_type_name ben_pl_typ_f.name%type
1258: ,plan_name ben_pl_f.name%type
1259: ,option_name ben_opt_f.name%type
1260: ,beneficiary VARCHAR2(400)
1261: ,ben_ssn per_all_people_f.national_identifier%type

Line 1273: type_of_benefit ben_pl_typ_f.name%type,

1269: TYPE g_dependent_rec_type IS RECORD
1270: (
1271: name per_all_people_f.full_name%type,
1272: relationship VARCHAR2(400),
1273: type_of_benefit ben_pl_typ_f.name%type,
1274: coverage VARCHAR2(100)
1275: );
1276:
1277: TYPE g_benefits_rec_type IS RECORD

Line 1279: type_of_benefit ben_pl_typ_f.name%type

1275: );
1276:
1277: TYPE g_benefits_rec_type IS RECORD
1278: (
1279: type_of_benefit ben_pl_typ_f.name%type
1280: ,plan ben_pl_f.name%type
1281: ,coverage_or_participation ben_opt_f.name%type
1282: );
1283: