APPS.BEN_COBJ_CACHE dependencies on BEN_PL_F

Line 21: 115.4 26-Jul-01 ikasire Bug1895874 added nip_dflt_flag to ben_pl_f

17: records.
18: 115.3 22-May-01 mhoyes - Upgraded comp object caches to be context
19: sensitive. Hence when the refresh routine is
20: not called then the cache will use SQL.
21: 115.4 26-Jul-01 ikasire Bug1895874 added nip_dflt_flag to ben_pl_f
22: table needs to be cached for bendenrr
23: 115.7 29-Nov-05 abparekh Bug 4766118 - Added ALWS_QDRO_FLAG to G_PL_INST_ROW
24: 115.8 13-Mar-06 kmahendr bug#5082245 - added svgs_pl_flag to g_pl_inst_ro
25: -----------------------------------------------------------------------------

Line 252: (pl_id ben_pl_f.pl_id%type

248: ,p_inst_row in out NOCOPY g_plip_inst_row
249: );
250: --
251: type g_pl_inst_row is record
252: (pl_id ben_pl_f.pl_id%type
253: ,effective_start_date ben_pl_f.effective_start_date%type
254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type

Line 253: ,effective_start_date ben_pl_f.effective_start_date%type

249: );
250: --
251: type g_pl_inst_row is record
252: (pl_id ben_pl_f.pl_id%type
253: ,effective_start_date ben_pl_f.effective_start_date%type
254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type

Line 254: ,effective_end_date ben_pl_f.effective_end_date%type

250: --
251: type g_pl_inst_row is record
252: (pl_id ben_pl_f.pl_id%type
253: ,effective_start_date ben_pl_f.effective_start_date%type
254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type

Line 255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type

251: type g_pl_inst_row is record
252: (pl_id ben_pl_f.pl_id%type
253: ,effective_start_date ben_pl_f.effective_start_date%type
254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type

Line 256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type

252: (pl_id ben_pl_f.pl_id%type
253: ,effective_start_date ben_pl_f.effective_start_date%type
254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type

Line 257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type

253: ,effective_start_date ben_pl_f.effective_start_date%type
254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type

Line 258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type

254: ,effective_end_date ben_pl_f.effective_end_date%type
255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type

Line 259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type

255: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type

Line 260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type

256: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type

Line 261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type

257: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type

Line 262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type

258: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type

Line 263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type

259: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type

Line 264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type

260: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type

Line 265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type

261: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type

Line 266: ,pl_typ_id ben_pl_f.pl_typ_id%type

262: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type

Line 267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type

263: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type

Line 268: ,ordr_num ben_pl_f.ordr_num%type

264: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type

Line 269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type

265: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type

Line 270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type

266: ,pl_typ_id ben_pl_f.pl_typ_id%type
267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type

Line 271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type

267: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type

Line 272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type

268: ,ordr_num ben_pl_f.ordr_num%type
269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type

Line 273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type

269: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type

Line 274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type

270: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type

Line 275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type

271: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type

Line 276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type

272: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type

Line 277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type

273: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type

Line 278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type

274: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type

Line 279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type

275: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type

Line 280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type

276: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type

Line 281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type

277: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type

Line 282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type

278: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type

Line 283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type

279: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type

Line 284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type

280: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type

Line 285: ,name ben_pl_f.name%type

281: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type

Line 286: ,actl_prem_id ben_pl_f.actl_prem_id%type

282: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type

Line 287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type

283: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type

Line 288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type

284: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type

Line 289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type

285: ,name ben_pl_f.name%type
286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type

Line 290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type

286: ,actl_prem_id ben_pl_f.actl_prem_id%type
287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type

Line 291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type

287: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type

Line 292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type

288: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type

Line 293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type

289: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type

Line 294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type

290: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type

Line 295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type

291: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
299: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type

Line 296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type

292: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
299: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
300: );

Line 297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type

293: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
299: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
300: );
301: --

Line 298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type

294: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
299: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
300: );
301: --
302: type g_pl_inst_tbl is table of g_pl_inst_row

Line 299: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type

295: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
299: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
300: );
301: --
302: type g_pl_inst_tbl is table of g_pl_inst_row
303: index by binary_integer;