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: 115.9 27-Dec-11 velvanop Bug 12558830: Creating Ineligible Flag for Compensation Object. ALL_INELIG column needs to

Line 258: (pl_id ben_pl_f.pl_id%type

254: ,p_inst_row in out NOCOPY g_plip_inst_row
255: );
256: --
257: type g_pl_inst_row is record
258: (pl_id ben_pl_f.pl_id%type
259: ,effective_start_date ben_pl_f.effective_start_date%type
260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type

Line 259: ,effective_start_date ben_pl_f.effective_start_date%type

255: );
256: --
257: type g_pl_inst_row is record
258: (pl_id ben_pl_f.pl_id%type
259: ,effective_start_date ben_pl_f.effective_start_date%type
260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type

Line 260: ,effective_end_date ben_pl_f.effective_end_date%type

256: --
257: type g_pl_inst_row is record
258: (pl_id ben_pl_f.pl_id%type
259: ,effective_start_date ben_pl_f.effective_start_date%type
260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type

Line 261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type

257: type g_pl_inst_row is record
258: (pl_id ben_pl_f.pl_id%type
259: ,effective_start_date ben_pl_f.effective_start_date%type
260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type

Line 262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type

258: (pl_id ben_pl_f.pl_id%type
259: ,effective_start_date ben_pl_f.effective_start_date%type
260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type

Line 263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type

259: ,effective_start_date ben_pl_f.effective_start_date%type
260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type

Line 264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type

260: ,effective_end_date ben_pl_f.effective_end_date%type
261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type

Line 265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type

261: ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type

Line 266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type

262: ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type

Line 267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type

263: ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type

Line 268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type

264: ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type

Line 269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type

265: ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type

Line 270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type

266: ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type

Line 271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type

267: ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type

Line 272: ,pl_typ_id ben_pl_f.pl_typ_id%type

268: ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type

Line 273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type

269: ,elig_apls_flag ben_pl_f.elig_apls_flag%type
270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type

Line 274: ,ordr_num ben_pl_f.ordr_num%type

270: ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type

Line 275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type

271: ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type

Line 276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type

272: ,pl_typ_id ben_pl_f.pl_typ_id%type
273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type

Line 277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type

273: ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type

Line 278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type

274: ,ordr_num ben_pl_f.ordr_num%type
275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type

Line 279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type

275: ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type

Line 280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type

276: ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type

Line 281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type

277: ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type

Line 282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type

278: ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type

Line 283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type

279: ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type

Line 284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type

280: ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type

Line 285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type

281: ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type

Line 286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type

282: ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type

Line 287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type

283: ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type

Line 288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type

284: ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type

Line 289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type

285: ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type

Line 290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type

286: ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type

Line 291: ,name ben_pl_f.name%type

287: ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type

Line 292: ,actl_prem_id ben_pl_f.actl_prem_id%type

288: ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type

Line 293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type

289: ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type

Line 294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type

290: ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type

Line 295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type

291: ,name ben_pl_f.name%type
292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type

Line 296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type

292: ,actl_prem_id ben_pl_f.actl_prem_id%type
293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type

Line 297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type

293: ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type

Line 298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type

294: ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type

Line 299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type

295: ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type

Line 300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type

296: ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type

Line 301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type

297: ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type

Line 302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type

298: ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
306: ,all_inelig ben_pl_f.all_inelig%type

Line 303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type

299: ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
306: ,all_inelig ben_pl_f.all_inelig%type
307: );

Line 304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type

300: ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
306: ,all_inelig ben_pl_f.all_inelig%type
307: );
308: --

Line 305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type

301: ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
306: ,all_inelig ben_pl_f.all_inelig%type
307: );
308: --
309: type g_pl_inst_tbl is table of g_pl_inst_row

Line 306: ,all_inelig ben_pl_f.all_inelig%type

302: ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
303: ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
304: ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
305: ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
306: ,all_inelig ben_pl_f.all_inelig%type
307: );
308: --
309: type g_pl_inst_tbl is table of g_pl_inst_row
310: index by binary_integer;