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_ADJUSTMENTS1 dependencies on BEN_PER_IN_LER

Line 53: (person_id ben_per_in_ler.person_id%type

49: --
50: TYPE cur_type IS REF CURSOR;
51: --
52: type g_efc_row is record
53: (person_id ben_per_in_ler.person_id%type
54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type

Line 54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

50: TYPE cur_type IS REF CURSOR;
51: --
52: type g_efc_row is record
53: (person_id ben_per_in_ler.person_id%type
54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type

Line 55: ,business_group_id ben_per_in_ler.business_group_id%type

51: --
52: type g_efc_row is record
53: (person_id ben_per_in_ler.person_id%type
54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type
59: ,object_version_number ben_per_in_ler.object_version_number%type

Line 56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

52: type g_efc_row is record
53: (person_id ben_per_in_ler.person_id%type
54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type
59: ,object_version_number ben_per_in_ler.object_version_number%type
60: /*

Line 57: ,creation_date ben_per_in_ler.creation_date%type

53: (person_id ben_per_in_ler.person_id%type
54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type
59: ,object_version_number ben_per_in_ler.object_version_number%type
60: /*
61: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type

Line 58: ,last_update_date ben_per_in_ler.last_update_date%type

54: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type
59: ,object_version_number ben_per_in_ler.object_version_number%type
60: /*
61: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type
62: */

Line 59: ,object_version_number ben_per_in_ler.object_version_number%type

55: ,business_group_id ben_per_in_ler.business_group_id%type
56: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
57: ,creation_date ben_per_in_ler.creation_date%type
58: ,last_update_date ben_per_in_ler.last_update_date%type
59: ,object_version_number ben_per_in_ler.object_version_number%type
60: /*
61: ,enrt_mthd_cd ben_prtt_enrt_rslt_f.enrt_mthd_cd%type
62: */
63: );

Line 148: ben_per_in_ler pil

144: pil.person_id,
145: pil.per_in_ler_id
146: from ben_prtt_rt_val prv,
147: ben_prtt_enrt_rslt_f pen,
148: ben_per_in_ler pil
149: where prv.prtt_rt_val_id = c_prv_id
150: and pil.lf_evt_ocrd_dt
151: between pen.effective_start_date and pen.effective_end_date
152: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 188: ben_per_in_ler pil

184: prv.mlt_cd,
185: pil.person_id,
186: prv.RT_END_DT
187: from ben_prtt_rt_val prv,
188: ben_per_in_ler pil
189: where prv.per_in_ler_id = c_pil_id
190: and prv.per_in_ler_id = pil.per_in_ler_id
191: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
192: --

Line 336: ben_per_in_ler pil,

332: epe.spcl_rt_pl_id,
333: epe.spcl_rt_oipl_id,
334: pel.acty_ref_perd_cd
335: from ben_elig_per_elctbl_chc epe,
336: ben_per_in_ler pil,
337: ben_pil_elctbl_chc_popl pel,
338: ben_prtt_enrt_rslt_f pen
339: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
340: and pil.per_in_ler_id = epe.per_in_ler_id

Line 921: ||' ben_per_in_ler pil, '

917: --
918: end if;
919: --
920: l_from_str := ' FROM ben_prtt_rt_val prv, '
921: ||' ben_per_in_ler pil, '
922: ||' per_all_people_f per ';
923: --
924: l_where_str := ' where prv.per_in_ler_id = pil.per_in_ler_id '
925: ||' and pil.person_id = per.person_id '

Line 1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

1897: ,rt_val ben_prtt_rt_val.rt_val%type
1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type
1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type
1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1902: ,person_id ben_per_in_ler.person_id%type
1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1904: ,ELEMENT_ENTRY_ID pay_element_entry_values_f.ELEMENT_ENTRY_ID%type
1905: );

Line 1902: ,person_id ben_per_in_ler.person_id%type

1898: ,prv_ovn ben_prtt_rt_val.object_version_number%type
1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type
1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type
1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1902: ,person_id ben_per_in_ler.person_id%type
1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1904: ,ELEMENT_ENTRY_ID pay_element_entry_values_f.ELEMENT_ENTRY_ID%type
1905: );
1906: --

Line 1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

1899: ,input_value_id ben_acty_base_rt_f.input_value_id%type
1900: ,element_type_id ben_acty_base_rt_f.element_type_id%type
1901: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
1902: ,person_id ben_per_in_ler.person_id%type
1903: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
1904: ,ELEMENT_ENTRY_ID pay_element_entry_values_f.ELEMENT_ENTRY_ID%type
1905: );
1906: --
1907: c_efc_rows cur_type;

Line 2089: ||' ben_per_in_ler pil, '

2085: l_from_str := ' FROM pay_element_entry_values_f eev, '
2086: ||' ben_prtt_rt_val prv, '
2087: ||' ben_prtt_enrt_rslt_f pen, '
2088: ||' ben_acty_base_rt_f abr, '
2089: ||' ben_per_in_ler pil, '
2090: ||' per_all_people_f per ';
2091: --
2092: l_where_str := ' where prv.element_entry_value_id = eev.element_entry_value_id '
2093: ||' and prv.prtt_rt_val_id = '

Line 2911: ,person_id ben_per_in_ler.person_id%type

2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type
2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2913: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2914: );
2915: --

Line 2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type
2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2913: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2914: );
2915: --
2916: c_efc_rows cur_type;

Line 2913: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type
2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2913: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2914: );
2915: --
2916: c_efc_rows cur_type;
2917: --

Line 3132: ||' ben_per_in_ler pil, '

3128: --
3129: end if;
3130: --
3131: l_from_str := ' FROM ben_bnft_prvdd_ldgr_f bpl, '
3132: ||' ben_per_in_ler pil, '
3133: ||' per_all_people_f per ';
3134: --
3135: l_where_str := ' where bpl.per_in_ler_id = pil.per_in_ler_id '
3136: ||' and pil.person_id = per.person_id '