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_EFC_ADJUSTMENTS dependencies on BEN_ENRT_BNFT

Line 553: from ben_enrt_bnft enb,

549: pil.business_group_id,
550: pil.ler_id,
551: pil.per_in_ler_stat_cd,
552: enb.val
553: from ben_enrt_bnft enb,
554: BEN_ELIG_PER_ELCTBL_CHC epe,
555: ben_per_in_ler pil,
556: per_all_people_f per
557: where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id

Line 577: from ben_enrt_bnft enb,

573: pil.business_group_id,
574: pil.ler_id,
575: pil.per_in_ler_stat_cd,
576: enb.val
577: from ben_enrt_bnft enb,
578: BEN_ELIG_PER_ELCTBL_CHC epe,
579: ben_per_in_ler pil
580: where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id
581: and pil.per_in_ler_id = epe.per_in_ler_id

Line 2782: (enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%type

2778: --
2779: TYPE cur_type IS REF CURSOR;
2780: --
2781: type g_efc_row is record
2782: (enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%type
2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type
2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type

Line 2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type

2779: TYPE cur_type IS REF CURSOR;
2780: --
2781: type g_efc_row is record
2782: (enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%type
2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type
2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type

Line 2784: ,business_group_id ben_enrt_bnft.business_group_id%type

2780: --
2781: type g_efc_row is record
2782: (enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%type
2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type
2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type

Line 2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type

2781: type g_efc_row is record
2782: (enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%type
2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type
2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type

Line 2786: ,mn_val ben_enrt_bnft.mn_val%type

2782: (enrt_bnft_id ben_enrt_bnft.enrt_bnft_id%type
2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type
2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type

Line 2787: ,mx_val ben_enrt_bnft.mx_val%type

2783: ,elig_per_elctbl_chc_id ben_enrt_bnft.elig_per_elctbl_chc_id%type
2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type

Line 2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type

2784: ,business_group_id ben_enrt_bnft.business_group_id%type
2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type

Line 2789: ,dflt_val ben_enrt_bnft.dflt_val%type

2785: ,mx_wout_ctfn_val ben_enrt_bnft.mx_wout_ctfn_val%type
2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type

Line 2790: ,val ben_enrt_bnft.val%type

2786: ,mn_val ben_enrt_bnft.mn_val%type
2787: ,mx_val ben_enrt_bnft.mx_val%type
2788: ,incrmt_val ben_enrt_bnft.incrmt_val%type
2789: ,dflt_val ben_enrt_bnft.dflt_val%type
2790: ,val ben_enrt_bnft.val%type
2791: ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
2792: ,pl_id ben_elig_per_elctbl_chc.pl_id%type
2793: ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
2794: ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type

Line 2804: ,last_update_date ben_enrt_bnft.last_update_date%type

2800: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2801: ,person_id ben_per_in_ler.person_id%type
2802: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2803: ,ler_id ben_per_in_ler.ler_id%type
2804: ,last_update_date ben_enrt_bnft.last_update_date%type
2805: ,creation_date ben_enrt_bnft.creation_date%type
2806: ,object_version_number ben_enrt_bnft.object_version_number%type
2807: ,cvg_mlt_cd ben_enrt_bnft.cvg_mlt_cd%type
2808: );

Line 2805: ,creation_date ben_enrt_bnft.creation_date%type

2801: ,person_id ben_per_in_ler.person_id%type
2802: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2803: ,ler_id ben_per_in_ler.ler_id%type
2804: ,last_update_date ben_enrt_bnft.last_update_date%type
2805: ,creation_date ben_enrt_bnft.creation_date%type
2806: ,object_version_number ben_enrt_bnft.object_version_number%type
2807: ,cvg_mlt_cd ben_enrt_bnft.cvg_mlt_cd%type
2808: );
2809: --

Line 2806: ,object_version_number ben_enrt_bnft.object_version_number%type

2802: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2803: ,ler_id ben_per_in_ler.ler_id%type
2804: ,last_update_date ben_enrt_bnft.last_update_date%type
2805: ,creation_date ben_enrt_bnft.creation_date%type
2806: ,object_version_number ben_enrt_bnft.object_version_number%type
2807: ,cvg_mlt_cd ben_enrt_bnft.cvg_mlt_cd%type
2808: );
2809: --
2810: c_efc_rows cur_type;

Line 2807: ,cvg_mlt_cd ben_enrt_bnft.cvg_mlt_cd%type

2803: ,ler_id ben_per_in_ler.ler_id%type
2804: ,last_update_date ben_enrt_bnft.last_update_date%type
2805: ,creation_date ben_enrt_bnft.creation_date%type
2806: ,object_version_number ben_enrt_bnft.object_version_number%type
2807: ,cvg_mlt_cd ben_enrt_bnft.cvg_mlt_cd%type
2808: );
2809: --
2810: c_efc_rows cur_type;
2811: --

Line 3021: l_from_str := ' FROM ben_enrt_bnft enb, '

3017: l_efc_batch := TRUE;
3018: --
3019: end if;
3020: --
3021: l_from_str := ' FROM ben_enrt_bnft enb, '
3022: ||' BEN_ELIG_PER_ELCTBL_CHC epe, '
3023: ||' ben_per_in_ler pil, '
3024: ||' per_all_people_f per ';
3025: --

Line 3054: l_from_str := l_from_str||', ben_enrt_bnft_efc efc ';

3050: -- Build in batch specific restrictions
3051: --
3052: if l_efc_batch then
3053: --
3054: l_from_str := l_from_str||', ben_enrt_bnft_efc efc ';
3055: l_where_str := l_where_str||' and efc.enrt_bnft_id = enb.enrt_bnft_id '
3056: ||' and efc.efc_action_id = :action_id '
3057: ||' and enb.enrt_bnft_id > :pk1 '
3058: ||' and mod(enb.enrt_bnft_id, :total_workers) = :worker_id ';

Line 3767: update ben_enrt_bnft enb

3763: if l_efc_batch
3764: and l_faterr_code is null
3765: then
3766: --
3767: update ben_enrt_bnft enb
3768: set enb.val = l_enb_valrow.val,
3769: enb.mn_val = l_enb_valrow.mn_val,
3770: enb.mx_val = l_enb_valrow.mx_val,
3771: enb.mx_wout_ctfn_val = l_enb_valrow.mx_wout_ctfn_val,

Line 3862: (p_table_name => 'ben_enrt_bnft'

3858: --
3859: -- Check that all rows have been converted or excluded
3860: --
3861: ben_efc_functions.conv_check
3862: (p_table_name => 'ben_enrt_bnft'
3863: ,p_efctable_name => 'ben_enrt_bnft_efc'
3864: ,p_tabwhere_clause => ' (mx_wout_ctfn_val is not null '
3865: ||' or mn_val is not null '
3866: ||' or mx_val is not null '

Line 3863: ,p_efctable_name => 'ben_enrt_bnft_efc'

3859: -- Check that all rows have been converted or excluded
3860: --
3861: ben_efc_functions.conv_check
3862: (p_table_name => 'ben_enrt_bnft'
3863: ,p_efctable_name => 'ben_enrt_bnft_efc'
3864: ,p_tabwhere_clause => ' (mx_wout_ctfn_val is not null '
3865: ||' or mn_val is not null '
3866: ||' or mx_val is not null '
3867: ||' or incrmt_val is not null '

Line 4018: ben_enrt_bnft enb

4014: )
4015: is
4016: select enb.val
4017: from BEN_ELIG_PER_ELCTBL_CHC epe,
4018: ben_enrt_bnft enb
4019: where epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
4020: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id;
4021: --
4022: cursor c_enb_dets

Line 4027: from ben_enrt_bnft enb

4023: (c_enb_id in number
4024: )
4025: is
4026: select enb.val
4027: from ben_enrt_bnft enb
4028: where enb.enrt_bnft_id = c_enb_id;
4029: --
4030: cursor c_mxaprvprlud
4031: (c_apr_id in number

Line 4678: ben_enrt_bnft enb

4674: )
4675: is
4676: select enb.val
4677: from BEN_ELIG_PER_ELCTBL_CHC epe,
4678: ben_enrt_bnft enb
4679: where epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
4680: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id;
4681: --
4682: cursor c_enb_dets

Line 4688: from ben_enrt_bnft enb

4684: )
4685: is
4686: select enb.val,
4687: enb.last_update_date
4688: from ben_enrt_bnft enb
4689: where enb.enrt_bnft_id = c_enb_id;
4690: --
4691: l_enb_dets c_enb_dets%rowtype;
4692: --