eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on BEN_OPT_F

Line 351: g_flex_opt_id ben_opt_f.opt_id%TYPE;

347: g_flex_pl_id ben_pl_f.pl_id%TYPE;
348: g_flex_pl_name ben_pl_f.name%TYPE;
349: g_flex_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
350: g_flex_pl_typ_name ben_pl_typ_f.name%TYPE;
351: g_flex_opt_id ben_opt_f.opt_id%TYPE;
352: g_flex_opt_name ben_opt_f.name%TYPE;
353: g_flex_cmbn_plip_id ben_cmbn_plip_f.cmbn_plip_id%TYPE;
354: g_flex_cmbn_plip_name ben_cmbn_plip_f.name%TYPE;
355: g_flex_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;

Line 352: g_flex_opt_name ben_opt_f.name%TYPE;

348: g_flex_pl_name ben_pl_f.name%TYPE;
349: g_flex_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
350: g_flex_pl_typ_name ben_pl_typ_f.name%TYPE;
351: g_flex_opt_id ben_opt_f.opt_id%TYPE;
352: g_flex_opt_name ben_opt_f.name%TYPE;
353: g_flex_cmbn_plip_id ben_cmbn_plip_f.cmbn_plip_id%TYPE;
354: g_flex_cmbn_plip_name ben_cmbn_plip_f.name%TYPE;
355: g_flex_cmbn_ptip_id ben_cmbn_ptip_f.cmbn_ptip_id%TYPE;
356: g_flex_cmbn_ptip_name ben_cmbn_ptip_f.name%TYPE;

Line 370: g_enrt_opt_name ben_opt_f.name%TYPE;

366: /* Start of Changes for WWBUG: 1828349 added */
367: g_enrt_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
368: /* End of Changes for WWBUG: 1828349 added */
369: g_enrt_pl_name ben_pl_f.name%TYPE;
370: g_enrt_opt_name ben_opt_f.name%TYPE;
371: g_enrt_pl_id ben_pl_f.pl_id%TYPE;
372: g_enrt_opt_id ben_opt_f.opt_id%TYPE;
373: g_enrt_pgm_id ben_pgm_f.pgm_id%TYPE;
374: g_enrt_pgm_name ben_pgm_f.name%TYPE;

Line 372: g_enrt_opt_id ben_opt_f.opt_id%TYPE;

368: /* End of Changes for WWBUG: 1828349 added */
369: g_enrt_pl_name ben_pl_f.name%TYPE;
370: g_enrt_opt_name ben_opt_f.name%TYPE;
371: g_enrt_pl_id ben_pl_f.pl_id%TYPE;
372: g_enrt_opt_id ben_opt_f.opt_id%TYPE;
373: g_enrt_pgm_id ben_pgm_f.pgm_id%TYPE;
374: g_enrt_pgm_name ben_pgm_f.name%TYPE;
375: g_enrt_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
376: g_enrt_pl_typ_name ben_pl_typ_f.name%TYPE;

Line 471: g_opt_attr_1 ben_opt_f.opt_attribute1%TYPE;

467: g_ler_attr_7 ben_ler_f.ler_attribute7%TYPE;
468: g_ler_attr_8 ben_ler_f.ler_attribute8%TYPE;
469: g_ler_attr_9 ben_ler_f.ler_attribute9%TYPE;
470: g_ler_attr_10 ben_ler_f.ler_attribute10%TYPE;
471: g_opt_attr_1 ben_opt_f.opt_attribute1%TYPE;
472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;
473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;

Line 472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;

468: g_ler_attr_8 ben_ler_f.ler_attribute8%TYPE;
469: g_ler_attr_9 ben_ler_f.ler_attribute9%TYPE;
470: g_ler_attr_10 ben_ler_f.ler_attribute10%TYPE;
471: g_opt_attr_1 ben_opt_f.opt_attribute1%TYPE;
472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;
473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;

Line 473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;

469: g_ler_attr_9 ben_ler_f.ler_attribute9%TYPE;
470: g_ler_attr_10 ben_ler_f.ler_attribute10%TYPE;
471: g_opt_attr_1 ben_opt_f.opt_attribute1%TYPE;
472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;
473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;

Line 474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;

470: g_ler_attr_10 ben_ler_f.ler_attribute10%TYPE;
471: g_opt_attr_1 ben_opt_f.opt_attribute1%TYPE;
472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;
473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;

Line 475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;

471: g_opt_attr_1 ben_opt_f.opt_attribute1%TYPE;
472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;
473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;

Line 476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;

472: g_opt_attr_2 ben_opt_f.opt_attribute2%TYPE;
473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
480: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;

Line 477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;

473: g_opt_attr_3 ben_opt_f.opt_attribute3%TYPE;
474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
480: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
481: g_enrt_lfevt_name ben_ler_f.name%TYPE;

Line 478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;

474: g_opt_attr_4 ben_opt_f.opt_attribute4%TYPE;
475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
480: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
481: g_enrt_lfevt_name ben_ler_f.name%TYPE;
482: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;

Line 479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;

475: g_opt_attr_5 ben_opt_f.opt_attribute5%TYPE;
476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
480: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
481: g_enrt_lfevt_name ben_ler_f.name%TYPE;
482: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
483: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

Line 480: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;

476: g_opt_attr_6 ben_opt_f.opt_attribute6%TYPE;
477: g_opt_attr_7 ben_opt_f.opt_attribute7%TYPE;
478: g_opt_attr_8 ben_opt_f.opt_attribute8%TYPE;
479: g_opt_attr_9 ben_opt_f.opt_attribute9%TYPE;
480: g_opt_attr_10 ben_opt_f.opt_attribute10%TYPE;
481: g_enrt_lfevt_name ben_ler_f.name%TYPE;
482: g_enrt_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
483: g_enrt_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
484: g_enrt_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

Line 509: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;

505: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;
506: g_enrt_intrcovg_flag varchar2(30);
507: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
508: g_enrt_int_pl_name ben_pl_f.name%TYPE;
509: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
510: g_enrt_int_opt_name ben_opt_f.name%TYPE;
511: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
512: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
513: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;

Line 510: g_enrt_int_opt_name ben_opt_f.name%TYPE;

506: g_enrt_intrcovg_flag varchar2(30);
507: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
508: g_enrt_int_pl_name ben_pl_f.name%TYPE;
509: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
510: g_enrt_int_opt_name ben_opt_f.name%TYPE;
511: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
512: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
513: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;
514: g_enrt_pl_fd_code ben_pl_f.short_code%Type ;

Line 519: g_enrt_opt_fd_name ben_opt_f.short_name%Type ;

515: g_enrt_pgm_fd_name ben_pgm_f.short_name%Type ;
516: g_enrt_pgm_fd_code ben_pgm_f.short_code%Type ;
517: g_enrt_pl_typ_fd_name ben_pl_typ_f.short_name%Type ;
518: g_enrt_pl_typ_fd_code ben_pl_typ_f.short_code%Type ;
519: g_enrt_opt_fd_name ben_opt_f.short_name%Type ;
520: g_enrt_opt_fd_code ben_opt_f.short_code%Type ;
521: g_enrt_opt_pl_fd_name ben_oipl_f.short_name%Type ;
522: g_enrt_opt_pl_fd_code ben_oipl_f.short_code%Type ;
523: g_enrt_pl_pgm_fd_name ben_plip_f.short_name%Type ;

Line 520: g_enrt_opt_fd_code ben_opt_f.short_code%Type ;

516: g_enrt_pgm_fd_code ben_pgm_f.short_code%Type ;
517: g_enrt_pl_typ_fd_name ben_pl_typ_f.short_name%Type ;
518: g_enrt_pl_typ_fd_code ben_pl_typ_f.short_code%Type ;
519: g_enrt_opt_fd_name ben_opt_f.short_name%Type ;
520: g_enrt_opt_fd_code ben_opt_f.short_code%Type ;
521: g_enrt_opt_pl_fd_name ben_oipl_f.short_name%Type ;
522: g_enrt_opt_pl_fd_code ben_oipl_f.short_code%Type ;
523: g_enrt_pl_pgm_fd_name ben_plip_f.short_name%Type ;
524: g_enrt_pl_pgm_fd_code ben_plip_f.short_code%Type ;

Line 797: g_elig_opt_name ben_opt_f.name%TYPE;

793: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
794: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
795: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
796: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;
797: g_elig_opt_name ben_opt_f.name%TYPE;
798: g_elig_cvg_amt ben_enrt_bnft.val%TYPE;
799: g_elig_cvg_min_amt ben_enrt_bnft.MN_VAL%TYPE;
800: g_elig_cvg_max_amt ben_enrt_bnft.MX_VAL%TYPE;
801: g_elig_cvg_inc_amt ben_enrt_bnft.INCRMT_VAL%TYPE;

Line 814: g_elig_opt_id ben_opt_f.opt_id%TYPE;

810: g_elig_opt_ord_no ben_oipl_f.ordr_num%TYPE;
811: g_elig_pl_id ben_pl_f.pl_id%TYPE;
812: g_elig_pl_typ_name ben_pl_typ_f.name%TYPE;
813: g_elig_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
814: g_elig_opt_id ben_opt_f.opt_id%TYPE;
815: g_elig_age_val ben_elig_per_f.age_val%TYPE;
816: g_elig_los_val ben_elig_per_f.los_val%TYPE;
817: g_elig_age_uom ben_elig_per_f.age_uom%TYPE;
818: g_elig_los_uom ben_elig_per_f.los_uom%TYPE;

Line 904: g_elig_opt_flex_01 ben_opt_f.opt_attribute1%TYPE;

900: g_elig_opt_in_pl_flex_07 ben_oipl_f.cop_attribute7%TYPE;
901: g_elig_opt_in_pl_flex_08 ben_oipl_f.cop_attribute8%TYPE;
902: g_elig_opt_in_pl_flex_09 ben_oipl_f.cop_attribute9%TYPE;
903: g_elig_opt_in_pl_flex_10 ben_oipl_f.cop_attribute10%TYPE;
904: g_elig_opt_flex_01 ben_opt_f.opt_attribute1%TYPE;
905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;
906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;

Line 905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;

901: g_elig_opt_in_pl_flex_08 ben_oipl_f.cop_attribute8%TYPE;
902: g_elig_opt_in_pl_flex_09 ben_oipl_f.cop_attribute9%TYPE;
903: g_elig_opt_in_pl_flex_10 ben_oipl_f.cop_attribute10%TYPE;
904: g_elig_opt_flex_01 ben_opt_f.opt_attribute1%TYPE;
905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;
906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;

Line 906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;

902: g_elig_opt_in_pl_flex_09 ben_oipl_f.cop_attribute9%TYPE;
903: g_elig_opt_in_pl_flex_10 ben_oipl_f.cop_attribute10%TYPE;
904: g_elig_opt_flex_01 ben_opt_f.opt_attribute1%TYPE;
905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;
906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;

Line 907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;

903: g_elig_opt_in_pl_flex_10 ben_oipl_f.cop_attribute10%TYPE;
904: g_elig_opt_flex_01 ben_opt_f.opt_attribute1%TYPE;
905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;
906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;

Line 908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;

904: g_elig_opt_flex_01 ben_opt_f.opt_attribute1%TYPE;
905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;
906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;
912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;

Line 909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;

905: g_elig_opt_flex_02 ben_opt_f.opt_attribute2%TYPE;
906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;
912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;
913: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;

Line 910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;

906: g_elig_opt_flex_03 ben_opt_f.opt_attribute3%TYPE;
907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;
912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;
913: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;
914: g_elig_lfevt_name ben_ler_f.name%TYPE;

Line 911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;

907: g_elig_opt_flex_04 ben_opt_f.opt_attribute4%TYPE;
908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;
912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;
913: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;
914: g_elig_lfevt_name ben_ler_f.name%TYPE;
915: g_elig_ler_id ben_ler_f.ler_id%TYPE;

Line 912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;

908: g_elig_opt_flex_05 ben_opt_f.opt_attribute5%TYPE;
909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;
912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;
913: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;
914: g_elig_lfevt_name ben_ler_f.name%TYPE;
915: g_elig_ler_id ben_ler_f.ler_id%TYPE;
916: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;

Line 913: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;

909: g_elig_opt_flex_06 ben_opt_f.opt_attribute6%TYPE;
910: g_elig_opt_flex_07 ben_opt_f.opt_attribute7%TYPE;
911: g_elig_opt_flex_08 ben_opt_f.opt_attribute8%TYPE;
912: g_elig_opt_flex_09 ben_opt_f.opt_attribute9%TYPE;
913: g_elig_opt_flex_10 ben_opt_f.opt_attribute10%TYPE;
914: g_elig_lfevt_name ben_ler_f.name%TYPE;
915: g_elig_ler_id ben_ler_f.ler_id%TYPE;
916: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
917: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;

Line 923: g_elig_opt_fd_name ben_opt_f.short_name%Type ;

919: g_elig_pl_fd_name ben_pl_f.short_name%Type ;
920: g_elig_pl_fd_code ben_pl_f.short_code%Type ;
921: g_elig_pgm_fd_name ben_pgm_f.short_name%Type ;
922: g_elig_pgm_fd_code ben_pgm_f.short_code%Type ;
923: g_elig_opt_fd_name ben_opt_f.short_name%Type ;
924: g_elig_opt_fd_code ben_opt_f.short_code%Type ;
925: g_elig_pl_typ_fd_name ben_pl_typ_f.short_name%Type ;
926: g_elig_pl_typ_fd_code ben_pl_typ_f.short_code%Type ;
927: g_elig_opt_pl_fd_name ben_oipl_f.short_name%Type ;

Line 924: g_elig_opt_fd_code ben_opt_f.short_code%Type ;

920: g_elig_pl_fd_code ben_pl_f.short_code%Type ;
921: g_elig_pgm_fd_name ben_pgm_f.short_name%Type ;
922: g_elig_pgm_fd_code ben_pgm_f.short_code%Type ;
923: g_elig_opt_fd_name ben_opt_f.short_name%Type ;
924: g_elig_opt_fd_code ben_opt_f.short_code%Type ;
925: g_elig_pl_typ_fd_name ben_pl_typ_f.short_name%Type ;
926: g_elig_pl_typ_fd_code ben_pl_typ_f.short_code%Type ;
927: g_elig_opt_pl_fd_name ben_oipl_f.short_name%Type ;
928: g_elig_opt_pl_fd_code ben_oipl_f.short_code%Type ;

Line 1294: g_CWB_Budget_Group_Option_Name ben_opt_f.name%type ;

1290: g_CWB_Budget_Approval ben_cwb_person_groups.APPROVAL_CD%type ;
1291: g_CWB_Budget_Approval_Date ben_cwb_person_groups.APPROVAL_DATE%type ;
1292: g_CWB_Budget_Dist_Budget_Value ben_cwb_person_groups.DIST_BDGT_VAL%type ;
1293: g_CWB_Budget_Due_Date ben_cwb_person_groups.DUE_DT%type ;
1294: g_CWB_Budget_Group_Option_Name ben_opt_f.name%type ;
1295: g_CWB_Budget_Group_Plan_Name ben_pl_f.name%type ;
1296: g_CWB_Budget_Last_Updt_By ben_cwb_person_groups.LAST_UPDATED_BY%type ;
1297: g_CWB_Budget_Last_Updt_dt ben_cwb_person_groups.LAST_UPDATE_DATE%type ;
1298: g_CWB_Budget_Population ben_cwb_person_groups.BDGT_POP_CD%type ;

Line 1326: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;

1322: --- cwb person rates
1323:
1324: g_CWB_Awrd_Elig_Flag ben_Cwb_person_rates.ELIG_FLAG%Type ;
1325: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;
1326: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1327: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1328: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1329: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;

Line 1329: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;

1325: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;
1326: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1327: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1328: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1329: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1331: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1332: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;
1333: g_CWB_Awrd_Other_Comp_Value ben_Cwb_person_rates.OTH_COMP_VAL%Type ;