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_PER_IN_LER

Line 331: from ben_per_in_ler pil

327: (c_person_id in number
328: )
329: is
330: select pil.per_in_ler_id
331: from ben_per_in_ler pil
332: where pil.person_id = c_person_id
333: order by pil.per_in_ler_id desc;
334: --
335: l_maxpildets c_maxpildets%rowtype;

Line 532: ben_per_in_ler pil,

528: pil.business_group_id,
529: pil.ler_id,
530: pil.per_in_ler_stat_cd
531: from BEN_ELIG_PER_ELCTBL_CHC epe,
532: ben_per_in_ler pil,
533: per_all_people_f per
534: where pil.per_in_ler_id = epe.per_in_ler_id
535: and epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
536: and per.person_id = pil.person_id

Line 555: ben_per_in_ler pil,

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
558: and pil.per_in_ler_id = epe.per_in_ler_id
559: and enb.enrt_bnft_id = c_enb_id

Line 579: ben_per_in_ler pil

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
582: and enb.enrt_bnft_id = c_enb_id;
583: --

Line 1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

1453: ,ptip_id ben_elig_per_f.ptip_id%type
1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type
1460: ,last_update_date ben_elig_per_f.last_update_date%type
1461: ,object_version_number ben_elig_per_f.object_version_number%type

Line 1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

1454: ,plip_id ben_elig_per_f.plip_id%type
1455: ,pl_id ben_elig_per_f.pl_id%type
1456: ,business_group_id ben_elig_per_f.business_group_id%type
1457: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1458: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1459: ,creation_date ben_elig_per_f.creation_date%type
1460: ,last_update_date ben_elig_per_f.last_update_date%type
1461: ,object_version_number ben_elig_per_f.object_version_number%type
1462: );

Line 1504: l_pil_row ben_per_in_ler%rowtype;

1500: l_df_counts ben_efc_functions.g_attach_df_counts;
1501: l_per_row per_all_people_f%ROWTYPE;
1502: l_empasg_row per_all_assignments_f%ROWTYPE;
1503: l_benasg_row per_all_assignments_f%ROWTYPE;
1504: l_pil_row ben_per_in_ler%rowtype;
1505: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
1506: l_d_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
1507: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
1508: l_d_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 1555: ||' ben_per_in_ler pil, '

1551: --
1552: end if;
1553: --
1554: l_from_str := ' FROM ben_elig_per_f pep, '
1555: ||' ben_per_in_ler pil, '
1556: ||' per_all_people_f per ';
1557: --
1558: l_where_str := ' where pep.per_in_ler_id = pil.per_in_ler_id '
1559: ||' and (pep.comp_ref_amt is not null '

Line 2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

2068: ,pgm_id ben_elig_per_f.pgm_id%type
2069: ,pl_id ben_elig_per_f.pl_id%type
2070: ,opt_id ben_elig_per_opt_f.opt_id%type
2071: ,business_group_id ben_elig_per_opt_f.business_group_id%type
2072: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2073: ,creation_date ben_elig_per_opt_f.creation_date%type
2074: ,last_update_date ben_elig_per_opt_f.last_update_date%type
2075: ,object_version_number ben_elig_per_opt_f.object_version_number%type
2076: ,per_in_ler_id ben_elig_per_opt_f.per_in_ler_id%type

Line 2134: l_pil_row ben_per_in_ler%rowtype;

2130: l_df_counts ben_efc_functions.g_attach_df_counts;
2131: l_per_row per_all_people_f%ROWTYPE;
2132: l_empasg_row per_all_assignments_f%ROWTYPE;
2133: l_benasg_row per_all_assignments_f%ROWTYPE;
2134: l_pil_row ben_per_in_ler%rowtype;
2135: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
2136: l_d_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
2137: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
2138: l_d_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;

Line 2244: ||' ben_per_in_ler pil, '

2240: end if;
2241: --
2242: l_from_str := ' FROM ben_elig_per_opt_f epo, '
2243: ||' ben_elig_per_f pep, '
2244: ||' ben_per_in_ler pil, '
2245: ||' per_all_people_f per ';
2246: --
2247: l_where_str := ' where epo.elig_per_id = pep.elig_per_id '
2248: ||' and epo.effective_start_date '

Line 2800: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

2796: ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%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

Line 2801: ,person_id ben_per_in_ler.person_id%type

2797: ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%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

Line 2802: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

2798: ,epe_ovn ben_elig_per_elctbl_chc.object_version_number%type
2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%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

Line 2803: ,ler_id ben_per_in_ler.ler_id%type

2799: ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%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

Line 3023: ||' ben_per_in_ler pil, '

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: --
3026: l_where_str := ' where enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id '
3027: ||' and epe.per_in_ler_id = pil.per_in_ler_id '

Line 4764: ben_per_in_ler pil,

4760: is
4761: select epr.val,
4762: pil.per_in_ler_stat_cd
4763: from ben_enrt_prem epr,
4764: ben_per_in_ler pil,
4765: ben_elig_per_elctbl_chc epe
4766: where epr.actl_prem_id = c_actl_prem_id
4767: and epr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
4768: and epe.elig_per_elctbl_chc_id = epr.elig_per_elctbl_chc_id