DBA Data[Home] [Help]

APPS.BEN_PERSON_RECORD dependencies on BEN_PL_TYP_F

Line 5: (plan_type_name ben_pl_typ_f.name%type

1: PACKAGE BEN_PERSON_RECORD AUTHID CURRENT_USER AS
2: /* $Header: benperrec.pkh 120.0.12010000.4 2009/04/10 12:56:22 pvelvano noship $ */
3:
4: TYPE g_beneficiary_rec_type IS RECORD
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

Line 21: type_of_benefit ben_pl_typ_f.name%type,

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: );
24:
25: TYPE g_benefits_rec_type IS RECORD

Line 27: type_of_benefit ben_pl_typ_f.name%type

23: );
24:
25: TYPE g_benefits_rec_type IS RECORD
26: (
27: type_of_benefit ben_pl_typ_f.name%type
28: ,plan ben_pl_f.name%type
29: ,coverage_or_participation ben_opt_f.name%type
30: );
31: