DBA Data[Home] [Help]

APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_RT

Line 68: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE

64: g_unrest_epe_instance g_unrest_epe_inst_tbl;
65: --
66: type g_unrest_ecr_inst_row is record
67: (enrt_rt_id number
68: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
69: ,ENRT_BNFT_ID BEN_ENRT_RT.ENRT_BNFT_ID%TYPE
70: ,OBJECT_VERSION_NUMBER number
71: ,ACTY_BASE_RT_ID BEN_ENRT_RT.ACTY_BASE_RT_ID%TYPE
72: ,mark_delete varchar2(1)

Line 69: ,ENRT_BNFT_ID BEN_ENRT_RT.ENRT_BNFT_ID%TYPE

65: --
66: type g_unrest_ecr_inst_row is record
67: (enrt_rt_id number
68: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
69: ,ENRT_BNFT_ID BEN_ENRT_RT.ENRT_BNFT_ID%TYPE
70: ,OBJECT_VERSION_NUMBER number
71: ,ACTY_BASE_RT_ID BEN_ENRT_RT.ACTY_BASE_RT_ID%TYPE
72: ,mark_delete varchar2(1)
73: );

Line 71: ,ACTY_BASE_RT_ID BEN_ENRT_RT.ACTY_BASE_RT_ID%TYPE

67: (enrt_rt_id number
68: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
69: ,ENRT_BNFT_ID BEN_ENRT_RT.ENRT_BNFT_ID%TYPE
70: ,OBJECT_VERSION_NUMBER number
71: ,ACTY_BASE_RT_ID BEN_ENRT_RT.ACTY_BASE_RT_ID%TYPE
72: ,mark_delete varchar2(1)
73: );
74: --
75: type g_unrest_ecr_inst_tbl is table of g_unrest_ecr_inst_row

Line 84: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE

80: --
81: --
82: type g_unrest_enb_inst_row is record
83: (enrt_bnft_id number
84: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
85: ,ORDR_NUM BEN_ENRT_BNFT.ORDR_NUM%TYPE
86: ,OBJECT_VERSION_NUMBER number
87: ,mark_delete varchar2(1)
88: );

Line 99: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE

95: --
96: type g_unrest_epr_inst_row is record
97: (enrt_prem_id number
98: ,ACTL_PREM_ID BEN_ENRT_PREM.ACTL_PREM_ID%TYPE
99: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
100: ,ENRT_BNFT_ID number
101: ,OBJECT_VERSION_NUMBER BEN_ENRT_PREM.OBJECT_VERSION_NUMBER%TYPE
102: ,mark_delete varchar2(1)
103: );

Line 114: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE

110: --
111: type g_unrest_ecc_inst_row is record
112: (elctbl_chc_ctfn_id number
113: ,ENRT_CTFN_TYP_CD BEN_ELCTBL_CHC_CTFN.ENRT_CTFN_TYP_CD%TYPE
114: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
115: ,ENRT_BNFT_ID BEN_ELCTBL_CHC_CTFN.ENRT_BNFT_ID%TYPE
116: ,OBJECT_VERSION_NUMBER BEN_ENRT_PREM.OBJECT_VERSION_NUMBER%TYPE
117: ,mark_delete varchar2(1)
118: );

Line 128: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE

124: g_unrest_ecc_instance_row g_unrest_ecc_inst_row;
125: --
126: type g_unrest_egd_inst_row is record
127: (elig_dpnt_id number
128: ,ELIG_PER_ELCTBL_CHC_ID BEN_ENRT_RT.ELIG_PER_ELCTBL_CHC_ID%TYPE
129: ,PER_IN_LER_ID BEN_ELIG_DPNT.PER_IN_LER_ID%TYPE
130: ,ELIG_PER_ID BEN_ELIG_DPNT.ELIG_PER_ID%TYPE
131: ,ELIG_PER_OPT_ID BEN_ELIG_DPNT.ELIG_PER_OPT_ID%TYPE
132: ,ELIG_CVRD_DPNT_ID BEN_ELIG_DPNT.ELIG_CVRD_DPNT_ID%TYPE