[Home] [Help]
8: ,pl_id ben_prtn_elig_f.pl_id%type
9: ,oipl_id ben_prtn_elig_f.oipl_id%type
10: ,prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
11: ,mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type
12: ,eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type
13: ,asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type
14: ,elig_enrld_plip_flag varchar2(30)
15: ,elig_cbr_quald_bnf_flag varchar2(30)
16: ,elig_enrld_ptip_flag varchar2(30)
9: ,oipl_id ben_prtn_elig_f.oipl_id%type
10: ,prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
11: ,mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type
12: ,eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type
13: ,asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type
14: ,elig_enrld_plip_flag varchar2(30)
15: ,elig_cbr_quald_bnf_flag varchar2(30)
16: ,elig_enrld_ptip_flag varchar2(30)
17: ,elig_dpnt_cvrd_plip_flag varchar2(30)
159: --
160: -- eligibility profile person type by eligibility profile
161: --
162: type g_cache_elpesa_object_rec is record
163: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
164: pk_id number,
165: short_code varchar2(30),
166: criteria_score ben_elig_svc_area_prte_f.criteria_score%type,
167: criteria_weight ben_elig_svc_area_prte_f.criteria_weight%type,
174: --
175: -- eligibility profile person type by eligibility profile
176: --
177: type g_cache_elpept_object_rec is record
178: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
179: pk_id number,
180: short_code varchar2(30),
181: criteria_score ben_elig_per_typ_prte_f.criteria_score%type,
182: criteria_weight ben_elig_per_typ_prte_f.criteria_weight%type,
190: --
191: -- eligibility profile people group by eligibility profile
192: --
193: type g_cache_elpepg_object_rec is record
194: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
195: pk_id number,
196: short_code varchar2(30),
197: people_group_id ben_elig_ppl_grp_prte_f.people_group_id%type,
198: excld_flag ben_elig_ppl_grp_prte_f.excld_flag%type,
234: --
235: -- eligibility profile assignment status type by eligibility profile
236: --
237: type g_cache_elpees_object_rec is record
238: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
239: pk_id number,
240: short_code varchar2(30),
241: assignment_status_type_id ben_elig_ee_stat_prte_f.
242: assignment_status_type_id%type,
250: --
251: -- eligibility profile length of service by eligibility profile
252: --
253: type g_cache_elpels_object_rec is record
254: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
255: pk_id number,
256: short_code varchar2(30),
257: excld_flag ben_elig_los_prte_f.excld_flag%type,
258: criteria_score ben_elig_los_prte_f.criteria_score%type,
268: --
269: -- eligibility profile age/los combination by eligibility profile
270: --
271: type g_cache_elpecp_object_rec is record
272: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
273: pk_id number,
274: short_code varchar2(30),
275: excld_flag ben_elig_cmbn_age_los_prte_f.excld_flag%type,
276: criteria_score ben_elig_cmbn_age_los_prte_f.criteria_score%type,
286: --
287: -- eligibility profile location by eligibility profile
288: --
289: type g_cache_elpewl_object_rec is record
290: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
291: pk_id number,
292: short_code varchar2(30),
293: location_id ben_elig_wk_loc_prte_f.location_id%type,
294: excld_flag ben_elig_wk_loc_prte_f.excld_flag%type,
300: --
301: -- eligibility profile organization by eligibility profile
302: --
303: type g_cache_elpeou_object_rec is record
304: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
305: pk_id number,
306: short_code varchar2(30),
307: organization_id ben_elig_org_unit_prte_f.organization_id%type,
308: excld_flag ben_elig_org_unit_prte_f.excld_flag%type,
314: --
315: -- eligibility profile pay frequency by eligibility profile
316: --
317: type g_cache_elpehs_object_rec is record
318: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
319: pk_id number,
320: short_code varchar2(30),
321: hrly_slrd_cd ben_elig_hrly_slrd_prte_f.hrly_slrd_cd%type,
322: excld_flag ben_elig_hrly_slrd_prte_f.excld_flag%type,
328: --
329: -- eligibility profile full/part time by eligibility profile
330: --
331: type g_cache_elpefp_object_rec is record
332: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
333: pk_id number,
334: short_code varchar2(30),
335: fl_tm_pt_tm_cd ben_elig_fl_tm_pt_tm_prte_f.fl_tm_pt_tm_cd%type,
336: excld_flag ben_elig_fl_tm_pt_tm_prte_f.excld_flag%type,
342: --
343: -- eligibility profile rules by eligibility profile
344: --
345: type g_cache_elperl_object_rec is record
346: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
347: pk_id number,
348: short_code varchar2(30),
349: formula_id ben_eligy_prfl_rl_f.formula_id%type,
350: criteria_score ben_eligy_prfl_rl_f.criteria_score%type,
355: --
356: -- eligibility profile scheduled hours by eligibility profile
357: --
358: type g_cache_elpesh_object_rec is record
359: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
360: pk_id number,
361: short_code varchar2(30),
362: hrs_num ben_elig_schedd_hrs_prte_f.hrs_num%type,
363: determination_cd ben_elig_schedd_hrs_prte_f.determination_cd%type,
376: --
377: -- eligibility profile compensation level by eligibility profile
378: --
379: type g_cache_elpecl_object_rec is record
380: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
381: pk_id number,
382: short_code varchar2(30),
383: excld_flag ben_elig_comp_lvl_prte_f.excld_flag%type,
384: criteria_score ben_elig_comp_lvl_prte_f.criteria_score%type,
396: --
397: -- eligibility profile hours worked by eligibility profile
398: --
399: type g_cache_elpehw_object_rec is record
400: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
401: pk_id number,
402: short_code varchar2(30),
403: hrs_wkd_in_perd_fctr_id ben_elig_hrs_wkd_prte_f.hrs_wkd_in_perd_fctr_id%type,
404: excld_flag ben_elig_hrs_wkd_prte_f.excld_flag%type,
415: --
416: -- eligibility profile hours worked by eligibility profile
417: --
418: type g_cache_elpean_object_rec is record
419: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
420: pk_id number,
421: short_code varchar2(30),
422: excld_flag ben_elig_hrs_wkd_prte_f.excld_flag%type,
423: criteria_score ben_elig_hrs_wkd_prte_f.criteria_score%type,
429: --
430: -- eligibility profile full time by eligibility profile
431: --
432: type g_cache_elpepf_object_rec is record
433: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
434: pk_id number,
435: short_code varchar2(30),
436: pct_fl_tm_fctr_id ben_elig_pct_fl_tm_prte_f.pct_fl_tm_fctr_id%type,
437: excld_flag ben_elig_pct_fl_tm_prte_f.excld_flag%type,
447: --
448: -- eligibility profile grade by eligibility profile
449: --
450: type g_cache_elpegr_object_rec is record
451: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
452: pk_id number,
453: short_code varchar2(30),
454: grade_id ben_elig_grd_prte_f.grade_id%type,
455: excld_flag ben_elig_grd_prte_f.excld_flag%type,
461: --
462: -- eligibility profile based on person's sex
463: --
464: type g_cache_elpegn_object_rec is record
465: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
466: pk_id number,
467: short_code varchar2(30),
468: sex ben_elig_gndr_prte_f.sex%type,
469: excld_flag ben_elig_gndr_prte_f.excld_flag%type,
475: --
476: -- eligibility profile job by eligibility profile
477: --
478: type g_cache_elpejp_object_rec is record
479: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
480: pk_id number,
481: short_code varchar2(30),
482: job_id ben_elig_job_prte_f.job_id%type,
483: excld_flag ben_elig_job_prte_f.excld_flag%type,
489: --
490: -- eligibility profile pay basis by eligibility profile
491: --
492: type g_cache_elpepb_object_rec is record
493: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
494: pk_id number,
495: short_code varchar2(30),
496: pay_basis_id ben_elig_py_bss_prte_f.pay_basis_id%type,
497: excld_flag ben_elig_py_bss_prte_f.excld_flag%type,
503: --
504: -- eligibility profile payroll by eligibility profile
505: --
506: type g_cache_elpepy_object_rec is record
507: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
508: pk_id number,
509: short_code varchar2(30),
510: payroll_id ben_elig_pyrl_prte_f.payroll_id%type,
511: excld_flag ben_elig_pyrl_prte_f.excld_flag%type,
517: --
518: -- eligibility profile bargaining unit by eligibility profile
519: --
520: type g_cache_elpebu_object_rec is record
521: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
522: pk_id number,
523: short_code varchar2(30),
524: brgng_unit_cd ben_elig_brgng_unit_prte_f.brgng_unit_cd%type,
525: excld_flag ben_elig_brgng_unit_prte_f.excld_flag%type,
531: --
532: -- eligibility profile labour union membership by eligibility profile
533: --
534: type g_cache_elpelu_object_rec is record
535: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
536: pk_id number,
537: short_code varchar2(30),
538: lbr_mmbr_flag ben_elig_lbr_mmbr_prte_f.lbr_mmbr_flag%type,
539: excld_flag ben_elig_lbr_mmbr_prte_f.excld_flag%type,
545: --
546: -- eligibility profile leave of absence reason by eligibility profile
547: --
548: type g_cache_elpelr_object_rec is record
549: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
550: pk_id number,
551: short_code varchar2(30),
552: absence_attendance_type_id ben_elig_loa_rsn_prte_f.absence_attendance_type_id%type,
553: abs_attendance_reason_id ben_elig_loa_rsn_prte_f.abs_attendance_reason_id%type,
560: --
561: -- eligibility profile age details by eligibility profile
562: --
563: type g_cache_elpeap_object_rec is record
564: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
565: pk_id number,
566: short_code varchar2(30),
567: age_fctr_id ben_age_fctr.age_fctr_id%type,
568: excld_flag ben_elig_age_prte_f.excld_flag%type,
578: --
579: -- eligibility profile zip code range by eligibility profile
580: --
581: type g_cache_elpepz_object_rec is record
582: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
583: pk_id number,
584: short_code varchar2(30),
585: excld_flag ben_elig_pstl_cd_r_rng_prte_f.excld_flag%type,
586: criteria_score ben_elig_pstl_cd_r_rng_prte_f.criteria_score%type,
593: --
594: -- eligibility profile benefits group by eligibility profile
595: --
596: type g_cache_elpebn_object_rec is record
597: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
598: pk_id number,
599: short_code varchar2(30),
600: benfts_grp_id ben_elig_benfts_grp_prte_f.benfts_grp_id%type,
601: excld_flag ben_elig_benfts_grp_prte_f.excld_flag%type,
607: --
608: -- eligibility profile legal entity by eligibility profile
609: --
610: type g_cache_elpeln_object_rec is record
611: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
612: pk_id number,
613: short_code varchar2(30),
614: excld_flag ben_elig_los_prte_f.excld_flag%type,
615: criteria_score ben_elig_los_prte_f.criteria_score%type,
621: --
622: -- eligibility profile other plan by eligibility profile
623: --
624: type g_cache_elpepp_object_rec is record
625: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
626: pl_id ben_elig_prtt_anthr_pl_prte_f.pl_id%type,
627: excld_flag ben_elig_prtt_anthr_pl_prte_f.excld_flag%type);
628: --
629: type g_cache_elpepp_instor is table of g_cache_elpepp_object_rec
631: --
632: -- eligibility profile people group by eligibility profile
633: --
634: type g_cache_elpeoy_object_rec is record
635: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
636: ptip_id ben_elig_othr_ptip_prte_f.ptip_id%type,
637: only_pls_subj_cobra_flag ben_elig_othr_ptip_prte_f.
638: only_pls_subj_cobra_flag%type,
639: excld_flag ben_elig_othr_ptip_prte_f.excld_flag%type);
643: --
644: -- eligibility profile plan type in program participate by eligibility profile
645: --
646: type g_cache_elpetd_object_rec is record
647: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
648: ptip_id ben_elig_dpnt_othr_ptip_f.ptip_id%type,
649: excld_flag ben_elig_dpnt_othr_ptip_f.excld_flag%type);
650: --
651: type g_cache_elpetd_instor is table of g_cache_elpetd_object_rec
653: --
654: -- eligibility profile(dpnt) plan type in program participate by eligibility profile
655: --
656: type g_cache_elpeno_object_rec is record
657: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
658: coord_ben_no_cvg_flag ben_elig_no_othr_cvg_prte_f.
659: coord_ben_no_cvg_flag%type);
660: --
661: type g_cache_elpeno_instor is table of g_cache_elpeno_object_rec
663: --
664: -- eligibility profile no other coverage particpation by eligibility profile
665: --
666: type g_cache_elpeep_object_rec is record
667: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
668: excld_flag ben_elig_enrld_anthr_pl_f.excld_flag%type,
669: enrl_det_dt_cd ben_elig_enrld_anthr_pl_f.enrl_det_dt_cd%type,
670: pl_id ben_elig_enrld_anthr_pl_f.pl_id%type);
671: --
674: --
675: -- eligibility profile enrolled another plan by eligibility profile
676: --
677: type g_cache_elpeei_object_rec is record
678: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
679: excld_flag ben_elig_enrld_anthr_oipl_f.excld_flag%type,
680: enrl_det_dt_cd ben_elig_enrld_anthr_oipl_f.enrl_det_dt_cd%type,
681: oipl_id ben_elig_enrld_anthr_oipl_f.oipl_id%type);
682: --
685: --
686: -- eligibility profile enrolled another option in plan by eligibility profile
687: --
688: type g_cache_elpeeg_object_rec is record
689: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
690: excld_flag ben_elig_enrld_anthr_pgm_f.excld_flag%type,
691: enrl_det_dt_cd ben_elig_enrld_anthr_pgm_f.enrl_det_dt_cd%type,
692: pgm_id ben_elig_enrld_anthr_pgm_f.pgm_id%type);
693: --
696: --
697: -- eligibility profile enrolled another program by eligibility profile
698: --
699: type g_cache_elpedp_object_rec is record
700: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
701: excld_flag ben_elig_dpnt_cvrd_othr_pl_f.excld_flag%type,
702: cvg_det_dt_cd ben_elig_dpnt_cvrd_othr_pl_f.cvg_det_dt_cd%type,
703: pl_id ben_elig_dpnt_cvrd_othr_pl_f.pl_id%type);
704: --
707: --
708: -- eligibility profile dependent covered another plan by eligibility profile
709: --
710: type g_cache_elpelv_object_rec is record
711: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
712: pk_id number,
713: short_code varchar2(30),
714: excld_flag ben_elig_lvg_rsn_prte_f.excld_flag%type,
715: criteria_score ben_elig_lvg_rsn_prte_f.criteria_score%type,
721: --
722: -- eligibility profile leaving reason by eligibility profile
723: --
724: type g_cache_elpeom_object_rec is record
725: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
726: excld_flag ben_elig_optd_mdcr_prte_f.exlcd_flag%type,
727: optd_mdcr_flag ben_elig_optd_mdcr_prte_f.optd_mdcr_flag%type);
728: --
729: type g_cache_elpeom_instor is table of g_cache_elpeom_object_rec
732: -- eligibility profile enrolled in another plan in program by
733: -- eligibility profile
734: --
735: type g_cache_elpeai_object_rec is record
736: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
737: excld_flag ben_elig_enrld_anthr_plip_f.excld_flag%type,
738: enrl_det_dt_cd ben_elig_enrld_anthr_plip_f.enrl_det_dt_cd%type,
739: plip_id ben_elig_enrld_anthr_plip_f.plip_id%type);
740: --
744: -- eligibility profile dependent covered in another plan in program by
745: -- eligibility profile
746: --
747: type g_cache_elpedi_object_rec is record
748: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
749: excld_flag ben_elig_dpnt_cvrd_plip_f.excld_flag%type,
750: enrl_det_dt_cd ben_elig_dpnt_cvrd_plip_f.enrl_det_dt_cd%type,
751: plip_id ben_elig_dpnt_cvrd_plip_f.plip_id%type);
752: --
756: -- eligibility profile enrolled in another plan type in program by
757: -- eligibility profile
758: --
759: type g_cache_elpeet_object_rec is record
760: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
761: excld_flag ben_elig_enrld_anthr_ptip_f.excld_flag%type,
762: enrl_det_dt_cd ben_elig_enrld_anthr_ptip_f.enrl_det_dt_cd%type,
763: only_pls_subj_cobra_flag ben_elig_enrld_anthr_ptip_f.
764: only_pls_subj_cobra_flag%type,
770: -- eligibility profile enrolled in another plan type in program by
771: -- eligibility profile
772: --
773: type g_cache_elpedt_object_rec is record
774: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
775: excld_flag ben_elig_dpnt_cvrd_othr_ptip_f.excld_flag%type,
776: enrl_det_dt_cd ben_elig_dpnt_cvrd_othr_ptip_f.enrl_det_dt_cd%type,
777: only_pls_subj_cobra_flag ben_elig_dpnt_cvrd_othr_ptip_f.
778: only_pls_subj_cobra_flag%type,
783: --
784: -- eligibility profile covered in another program by eligibility profile
785: --
786: type g_cache_elpedg_object_rec is record
787: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
788: excld_flag ben_elig_dpnt_cvrd_othr_pgm_f.excld_flag%type,
789: enrl_det_dt_cd ben_elig_dpnt_cvrd_othr_pgm_f.enrl_det_dt_cd%type,
790: pgm_id ben_elig_dpnt_cvrd_othr_pgm_f.pgm_id%type);
791: --
794: --
795: -- eligibility profile cobra qualified beneficiary by eligibility profile
796: --
797: type g_cache_elpecq_object_rec is record
798: (eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type,
799: pk_id number,
800: short_code varchar2(30),
801: quald_bnf_flag ben_elig_cbr_quald_bnf_f.quald_bnf_flag%type,
802: -- lamc added these 2 lines: