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_PL_F

Line 350: g_flex_pl_id ben_pl_f.pl_id%TYPE;

346: g_flex_credit_used ben_bnft_prvdd_ldgr_f.used_val%TYPE;
347: g_flex_credit_excess ben_bnft_prvdd_ldgr_f.used_val%TYPE;
348: g_flex_pgm_id ben_pgm_f.pgm_id%TYPE;
349: g_flex_pgm_name ben_pgm_f.name%TYPE;
350: g_flex_pl_id ben_pl_f.pl_id%TYPE;
351: g_flex_pl_name ben_pl_f.name%TYPE;
352: g_flex_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
353: g_flex_pl_typ_name ben_pl_typ_f.name%TYPE;
354: g_flex_opt_id ben_opt_f.opt_id%TYPE;

Line 351: g_flex_pl_name ben_pl_f.name%TYPE;

347: g_flex_credit_excess ben_bnft_prvdd_ldgr_f.used_val%TYPE;
348: g_flex_pgm_id ben_pgm_f.pgm_id%TYPE;
349: g_flex_pgm_name ben_pgm_f.name%TYPE;
350: g_flex_pl_id ben_pl_f.pl_id%TYPE;
351: g_flex_pl_name ben_pl_f.name%TYPE;
352: g_flex_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
353: g_flex_pl_typ_name ben_pl_typ_f.name%TYPE;
354: g_flex_opt_id ben_opt_f.opt_id%TYPE;
355: g_flex_opt_name ben_opt_f.name%TYPE;

Line 372: g_enrt_pl_name ben_pl_f.name%TYPE;

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

Line 374: g_enrt_pl_id ben_pl_f.pl_id%TYPE;

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

Line 414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;

410: g_enrt_attr_10 ben_prtt_enrt_rslt_f.pen_attribute10%TYPE;
411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;

Line 415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;

411: g_enrt_plcy_r_grp ben_popl_org_f.plcy_r_grp%TYPE;
412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;

Line 416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;

412: g_enrt_ler_id ben_prtt_enrt_rslt_f.ler_id%TYPE;
413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;

Line 417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;

413: g_enrt_assignment_id ben_prtt_enrt_rslt_f.assignment_id%TYPE;
414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;

Line 418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;

414: g_pl_attr_1 ben_pl_f.pln_attribute1%TYPE;
415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;
422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;

Line 419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;

415: g_pl_attr_2 ben_pl_f.pln_attribute2%TYPE;
416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;
422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;
423: g_pl_attr_10 ben_pl_f.pln_attribute10%TYPE;

Line 420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;

416: g_pl_attr_3 ben_pl_f.pln_attribute3%TYPE;
417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;
422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;
423: g_pl_attr_10 ben_pl_f.pln_attribute10%TYPE;
424: g_pgm_attr_1 ben_pgm_f.pgm_attribute1%TYPE;

Line 421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;

417: g_pl_attr_4 ben_pl_f.pln_attribute4%TYPE;
418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;
422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;
423: g_pl_attr_10 ben_pl_f.pln_attribute10%TYPE;
424: g_pgm_attr_1 ben_pgm_f.pgm_attribute1%TYPE;
425: g_pgm_attr_2 ben_pgm_f.pgm_attribute2%TYPE;

Line 422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;

418: g_pl_attr_5 ben_pl_f.pln_attribute5%TYPE;
419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;
422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;
423: g_pl_attr_10 ben_pl_f.pln_attribute10%TYPE;
424: g_pgm_attr_1 ben_pgm_f.pgm_attribute1%TYPE;
425: g_pgm_attr_2 ben_pgm_f.pgm_attribute2%TYPE;
426: g_pgm_attr_3 ben_pgm_f.pgm_attribute3%TYPE;

Line 423: g_pl_attr_10 ben_pl_f.pln_attribute10%TYPE;

419: g_pl_attr_6 ben_pl_f.pln_attribute6%TYPE;
420: g_pl_attr_7 ben_pl_f.pln_attribute7%TYPE;
421: g_pl_attr_8 ben_pl_f.pln_attribute8%TYPE;
422: g_pl_attr_9 ben_pl_f.pln_attribute9%TYPE;
423: g_pl_attr_10 ben_pl_f.pln_attribute10%TYPE;
424: g_pgm_attr_1 ben_pgm_f.pgm_attribute1%TYPE;
425: g_pgm_attr_2 ben_pgm_f.pgm_attribute2%TYPE;
426: g_pgm_attr_3 ben_pgm_f.pgm_attribute3%TYPE;
427: g_pgm_attr_4 ben_pgm_f.pgm_attribute4%TYPE;

Line 511: g_enrt_int_pl_name ben_pl_f.name%TYPE;

507: g_enrt_prt_orgcovg_strdt ben_prtt_enrt_rslt_f.orgnl_enrt_dt%TYPE;
508: g_enrt_status_cd ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%TYPE;
509: g_enrt_intrcovg_flag varchar2(30);
510: g_enrt_int_pl_id ben_prtt_enrt_rslt_f.pl_id%TYPE;
511: g_enrt_int_pl_name ben_pl_f.name%TYPE;
512: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
513: g_enrt_int_opt_name ben_opt_f.name%TYPE;
514: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
515: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;

Line 516: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;

512: g_enrt_int_opt_id ben_opt_f.opt_id%TYPE;
513: g_enrt_int_opt_name ben_opt_f.name%TYPE;
514: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
515: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
516: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;
517: g_enrt_pl_fd_code ben_pl_f.short_code%Type ;
518: g_enrt_pgm_fd_name ben_pgm_f.short_name%Type ;
519: g_enrt_pgm_fd_code ben_pgm_f.short_code%Type ;
520: g_enrt_pl_typ_fd_name ben_pl_typ_f.short_name%Type ;

Line 517: g_enrt_pl_fd_code ben_pl_f.short_code%Type ;

513: g_enrt_int_opt_name ben_opt_f.name%TYPE;
514: g_enrt_int_cvg_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
515: g_enrt_elec_made_dt ben_pil_elctbl_chc_popl.elcns_made_dt%TYPE;
516: g_enrt_pl_fd_name ben_pl_f.short_name%Type ;
517: g_enrt_pl_fd_code ben_pl_f.short_code%Type ;
518: g_enrt_pgm_fd_name ben_pgm_f.short_name%Type ;
519: g_enrt_pgm_fd_code ben_pgm_f.short_code%Type ;
520: g_enrt_pl_typ_fd_name ben_pl_typ_f.short_name%Type ;
521: g_enrt_pl_typ_fd_code ben_pl_typ_f.short_code%Type ;

Line 795: g_elig_pl_name ben_pl_f.name%TYPE;

791: g_elig_enrt_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%TYPE;
792: g_elig_enrt_end_dt ben_pil_elctbl_chc_popl.enrt_perd_end_dt%TYPE;
793: g_elig_dflt_enrt_dt ben_pil_elctbl_chc_popl.dflt_enrt_dt%TYPE;
794: g_elig_uom ben_pil_elctbl_chc_popl.uom%TYPE;
795: g_elig_pl_name ben_pl_f.name%TYPE;
796: g_elig_pl_seq_num ben_prtt_enrt_rslt_f.pl_ordr_num%TYPE;
797: g_elig_pip_seq_num ben_prtt_enrt_rslt_f.plip_ordr_num%TYPE;
798: g_elig_ptp_seq_num ben_prtt_enrt_rslt_f.ptip_ordr_num%TYPE;
799: g_elig_oip_seq_num ben_prtt_enrt_rslt_f.oipl_ordr_num%TYPE;

Line 814: g_elig_pl_id ben_pl_f.pl_id%TYPE;

810: g_elig_cvg_bnft_typ ben_enrt_bnft.BNFT_TYP_CD%TYPE;
811: g_elig_cvg_bnft_uom ben_enrt_bnft.NNMNTRY_UOM%TYPE;
812: g_elig_pl_ord_no ben_plip_f.ordr_num%TYPE;
813: g_elig_opt_ord_no ben_oipl_f.ordr_num%TYPE;
814: g_elig_pl_id ben_pl_f.pl_id%TYPE;
815: g_elig_pl_typ_name ben_pl_typ_f.name%TYPE;
816: g_elig_pl_typ_id ben_pl_typ_f.pl_typ_id%TYPE;
817: g_elig_opt_id ben_opt_f.opt_id%TYPE;
818: g_elig_age_val ben_elig_per_f.age_val%TYPE;

Line 857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;

853: g_elig_flex_07 ben_elig_per_elctbl_chc.epe_attribute7%TYPE;
854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;

Line 858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;

854: g_elig_flex_08 ben_elig_per_elctbl_chc.epe_attribute8%TYPE;
855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;

Line 859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;

855: g_elig_flex_09 ben_elig_per_elctbl_chc.epe_attribute9%TYPE;
856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;

Line 860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;

856: g_elig_flex_10 ben_elig_per_elctbl_chc.epe_attribute10%TYPE;
857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;

Line 861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;

857: g_elig_plan_flex_01 ben_pl_f.pln_attribute1%TYPE;
858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;
865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;

Line 862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;

858: g_elig_plan_flex_02 ben_pl_f.pln_attribute2%TYPE;
859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;
865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;
866: g_elig_plan_flex_10 ben_pl_f.pln_attribute10%TYPE;

Line 863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;

859: g_elig_plan_flex_03 ben_pl_f.pln_attribute3%TYPE;
860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;
865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;
866: g_elig_plan_flex_10 ben_pl_f.pln_attribute10%TYPE;
867: g_elig_pgm_flex_01 ben_pgm_f.pgm_attribute1%TYPE;

Line 864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;

860: g_elig_plan_flex_04 ben_pl_f.pln_attribute4%TYPE;
861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;
865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;
866: g_elig_plan_flex_10 ben_pl_f.pln_attribute10%TYPE;
867: g_elig_pgm_flex_01 ben_pgm_f.pgm_attribute1%TYPE;
868: g_elig_pgm_flex_02 ben_pgm_f.pgm_attribute2%TYPE;

Line 865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;

861: g_elig_plan_flex_05 ben_pl_f.pln_attribute5%TYPE;
862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;
865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;
866: g_elig_plan_flex_10 ben_pl_f.pln_attribute10%TYPE;
867: g_elig_pgm_flex_01 ben_pgm_f.pgm_attribute1%TYPE;
868: g_elig_pgm_flex_02 ben_pgm_f.pgm_attribute2%TYPE;
869: g_elig_pgm_flex_03 ben_pgm_f.pgm_attribute3%TYPE;

Line 866: g_elig_plan_flex_10 ben_pl_f.pln_attribute10%TYPE;

862: g_elig_plan_flex_06 ben_pl_f.pln_attribute6%TYPE;
863: g_elig_plan_flex_07 ben_pl_f.pln_attribute7%TYPE;
864: g_elig_plan_flex_08 ben_pl_f.pln_attribute8%TYPE;
865: g_elig_plan_flex_09 ben_pl_f.pln_attribute9%TYPE;
866: g_elig_plan_flex_10 ben_pl_f.pln_attribute10%TYPE;
867: g_elig_pgm_flex_01 ben_pgm_f.pgm_attribute1%TYPE;
868: g_elig_pgm_flex_02 ben_pgm_f.pgm_attribute2%TYPE;
869: g_elig_pgm_flex_03 ben_pgm_f.pgm_attribute3%TYPE;
870: g_elig_pgm_flex_04 ben_pgm_f.pgm_attribute4%TYPE;

Line 922: g_elig_pl_fd_name ben_pl_f.short_name%Type ;

918: g_elig_ler_id ben_ler_f.ler_id%TYPE;
919: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
920: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
921: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
922: g_elig_pl_fd_name ben_pl_f.short_name%Type ;
923: g_elig_pl_fd_code ben_pl_f.short_code%Type ;
924: g_elig_pgm_fd_name ben_pgm_f.short_name%Type ;
925: g_elig_pgm_fd_code ben_pgm_f.short_code%Type ;
926: g_elig_opt_fd_name ben_opt_f.short_name%Type ;

Line 923: g_elig_pl_fd_code ben_pl_f.short_code%Type ;

919: g_elig_lfevt_status ben_per_in_ler.per_in_ler_stat_cd%TYPE;
920: g_elig_lfevt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
921: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
922: g_elig_pl_fd_name ben_pl_f.short_name%Type ;
923: g_elig_pl_fd_code ben_pl_f.short_code%Type ;
924: g_elig_pgm_fd_name ben_pgm_f.short_name%Type ;
925: g_elig_pgm_fd_code ben_pgm_f.short_code%Type ;
926: g_elig_opt_fd_name ben_opt_f.short_name%Type ;
927: g_elig_opt_fd_code ben_opt_f.short_code%Type ;

Line 953: g_elig_cobra_payment_dys ben_pl_f.COBRA_PYMT_DUE_DY_NUM%type ;

949: g_elig_ee_cwb_worksheet_bdgt ben_prtt_rt_val.rt_val%TYPE;
950: g_elig_ee_cwb_worksheet_amt ben_prtt_rt_val.rt_val%TYPE;
951:
952: -- Cobra letter requirment
953: g_elig_cobra_payment_dys ben_pl_f.COBRA_PYMT_DUE_DY_NUM%type ;
954: g_elig_cobra_admin_name ben_popl_org_role_f.name%type ;
955: g_elig_cobra_admin_org_name hr_all_organization_units.name%type ;
956: g_elig_cobra_admin_addr1 hr_locations.address_line_1%type ;
957: g_elig_cobra_admin_addr2 hr_locations.address_line_2%type ;

Line 1148: g_cwb_group_plan_name ben_pl_f.name%type ;

1144: --
1145: g_detail_extracted boolean:=false;
1146: --cwb variables
1147: --- intialize cwb globals
1148: g_cwb_group_plan_name ben_pl_f.name%type ;
1149: g_cwb_per_group_per_in_ler_id ben_cwb_person_info.group_per_in_ler_id%type ;
1150: g_cwb_per_group_pl_id ben_per_in_ler.group_pl_id%type ;
1151: g_CWB_Person_FULL_NAME ben_cwb_person_info.FULL_NAME%type ;
1152: g_CWB_Person_Custom_Name ben_cwb_person_info.Custom_Name%type ;

Line 1298: g_CWB_Budget_Group_Plan_Name ben_pl_f.name%type ;

1294: g_CWB_Budget_Approval_Date ben_cwb_person_groups.APPROVAL_DATE%type ;
1295: g_CWB_Budget_Dist_Budget_Value ben_cwb_person_groups.DIST_BDGT_VAL%type ;
1296: g_CWB_Budget_Due_Date ben_cwb_person_groups.DUE_DT%type ;
1297: g_CWB_Budget_Group_Option_Name ben_opt_f.name%type ;
1298: g_CWB_Budget_Group_Plan_Name ben_pl_f.name%type ;
1299: g_CWB_Budget_Last_Updt_By ben_cwb_person_groups.LAST_UPDATED_BY%type ;
1300: g_CWB_Budget_Last_Updt_dt ben_cwb_person_groups.LAST_UPDATE_DATE%type ;
1301: g_CWB_Budget_Population ben_cwb_person_groups.BDGT_POP_CD%type ;
1302: g_CWB_Budget_Resv_Max_Value ben_cwb_person_groups.RSRV_MX_VAL%type ;

Line 1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;

1326:
1327: g_CWB_Awrd_Elig_Flag ben_Cwb_person_rates.ELIG_FLAG%Type ;
1328: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;
1329: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;

Line 1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;

1327: g_CWB_Awrd_Elig_Flag ben_Cwb_person_rates.ELIG_FLAG%Type ;
1328: g_CWB_Awrd_Elig_Salary_Value ben_Cwb_person_rates.ELIG_SAL_VAL%Type ;
1329: g_CWB_Awrd_Group_Option_Name ben_opt_f.name%Type ;
1330: g_CWB_Awrd_Group_Plan_Name ben_pl_f.name%Type ;
1331: g_CWB_Awrd_Plan_Name ben_pl_f.name%Type ;
1332: g_CWB_Awrd_Option_Name ben_opt_f.name%Type ;
1333: g_CWB_Awrd_Misc_Value1 ben_Cwb_person_rates.MISC1_VAL%Type ;
1334: g_CWB_Awrd_Misc_Value2 ben_Cwb_person_rates.MISC2_VAL%Type ;
1335: g_CWB_Awrd_Misc_Value3 ben_Cwb_person_rates.MISC3_VAL%Type ;