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_LER_F

Line 277: g_ler_name ben_ler_f.name%TYPE;

273: g_payroll_consolidation_set pay_consolidation_sets.consolidation_set_name%TYPE;
274: g_payroll_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
275: --
276: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
277: g_ler_name ben_ler_f.name%TYPE;
278: g_ler_id ben_ler_f.ler_id%TYPE;
279: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
280: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
281: --

Line 278: g_ler_id ben_ler_f.ler_id%TYPE;

274: g_payroll_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
275: --
276: g_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
277: g_ler_name ben_ler_f.name%TYPE;
278: g_ler_id ben_ler_f.ler_id%TYPE;
279: g_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
280: g_lf_evt_note_dt ben_per_in_ler.ntfn_dt%TYPE;
281: --
282: g_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 461: g_ler_attr_1 ben_ler_f.ler_attribute1%TYPE;

457: g_oipl_attr_7 ben_oipl_f.cop_attribute7%TYPE;
458: g_oipl_attr_8 ben_oipl_f.cop_attribute8%TYPE;
459: g_oipl_attr_9 ben_oipl_f.cop_attribute9%TYPE;
460: g_oipl_attr_10 ben_oipl_f.cop_attribute10%TYPE;
461: g_ler_attr_1 ben_ler_f.ler_attribute1%TYPE;
462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;
463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;

Line 462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;

458: g_oipl_attr_8 ben_oipl_f.cop_attribute8%TYPE;
459: g_oipl_attr_9 ben_oipl_f.cop_attribute9%TYPE;
460: g_oipl_attr_10 ben_oipl_f.cop_attribute10%TYPE;
461: g_ler_attr_1 ben_ler_f.ler_attribute1%TYPE;
462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;
463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%TYPE;

Line 463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;

459: g_oipl_attr_9 ben_oipl_f.cop_attribute9%TYPE;
460: g_oipl_attr_10 ben_oipl_f.cop_attribute10%TYPE;
461: g_ler_attr_1 ben_ler_f.ler_attribute1%TYPE;
462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;
463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%TYPE;
467: g_ler_attr_7 ben_ler_f.ler_attribute7%TYPE;

Line 464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;

460: g_oipl_attr_10 ben_oipl_f.cop_attribute10%TYPE;
461: g_ler_attr_1 ben_ler_f.ler_attribute1%TYPE;
462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;
463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%TYPE;
467: g_ler_attr_7 ben_ler_f.ler_attribute7%TYPE;
468: g_ler_attr_8 ben_ler_f.ler_attribute8%TYPE;

Line 465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;

461: g_ler_attr_1 ben_ler_f.ler_attribute1%TYPE;
462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;
463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%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;

Line 466: g_ler_attr_6 ben_ler_f.ler_attribute6%TYPE;

462: g_ler_attr_2 ben_ler_f.ler_attribute2%TYPE;
463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%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;

Line 467: g_ler_attr_7 ben_ler_f.ler_attribute7%TYPE;

463: g_ler_attr_3 ben_ler_f.ler_attribute3%TYPE;
464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%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;

Line 468: g_ler_attr_8 ben_ler_f.ler_attribute8%TYPE;

464: g_ler_attr_4 ben_ler_f.ler_attribute4%TYPE;
465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%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;

Line 469: g_ler_attr_9 ben_ler_f.ler_attribute9%TYPE;

465: g_ler_attr_5 ben_ler_f.ler_attribute5%TYPE;
466: g_ler_attr_6 ben_ler_f.ler_attribute6%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;

Line 470: g_ler_attr_10 ben_ler_f.ler_attribute10%TYPE;

466: g_ler_attr_6 ben_ler_f.ler_attribute6%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;

Line 481: g_enrt_lfevt_name ben_ler_f.name%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;
485: g_prem_actl_prem_id ben_actl_prem_f.actl_prem_id%type;

Line 700: g_contact_start_life_evt ben_ler_f.name%TYPE;

696: g_contact_personal_flag per_contact_relationships.PERSONAL_FLAG%TYPE;
697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;
702: g_contact_end_life_evt ben_ler_f.name%TYPE;
703: g_contact_end_ler_id ben_ler_f.ler_id%TYPE;
704: g_contact_is_elig_dpnt_flag varchar2(30);

Line 701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;

697: g_contact_pymts_rcpnt_flag per_contact_relationships.THIRD_PARTY_PAY_FLAG%TYPE;
698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;
702: g_contact_end_life_evt ben_ler_f.name%TYPE;
703: g_contact_end_ler_id ben_ler_f.ler_id%TYPE;
704: g_contact_is_elig_dpnt_flag varchar2(30);
705: g_contact_is_cvrd_dpnt_flag varchar2(30);

Line 702: g_contact_end_life_evt ben_ler_f.name%TYPE;

698: g_contact_start_date per_contact_relationships.DATE_START%TYPE;
699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;
702: g_contact_end_life_evt ben_ler_f.name%TYPE;
703: g_contact_end_ler_id ben_ler_f.ler_id%TYPE;
704: g_contact_is_elig_dpnt_flag varchar2(30);
705: g_contact_is_cvrd_dpnt_flag varchar2(30);
706: g_contact_is_bnfcry_flag varchar2(30);

Line 703: g_contact_end_ler_id ben_ler_f.ler_id%TYPE;

699: g_contact_end_date per_contact_relationships.DATE_END%TYPE;
700: g_contact_start_life_evt ben_ler_f.name%TYPE;
701: g_contact_start_ler_id ben_ler_f.ler_id%TYPE;
702: g_contact_end_life_evt ben_ler_f.name%TYPE;
703: g_contact_end_ler_id ben_ler_f.ler_id%TYPE;
704: g_contact_is_elig_dpnt_flag varchar2(30);
705: g_contact_is_cvrd_dpnt_flag varchar2(30);
706: g_contact_is_bnfcry_flag varchar2(30);
707:

Line 717: g_cm_lf_evt ben_ler_f.name%TYPE;

713: g_cm_type_id ben_cm_typ_f.cm_typ_id%type;
714: g_cm_short_name ben_cm_typ_f.shrt_name%type;
715: g_cm_kit ben_cm_typ_f.pc_kit_cd%type;
716: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
717: g_cm_lf_evt ben_ler_f.name%TYPE;
718: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
719: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
720: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;
721: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;

Line 718: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;

714: g_cm_short_name ben_cm_typ_f.shrt_name%type;
715: g_cm_kit ben_cm_typ_f.pc_kit_cd%type;
716: g_cm_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
717: g_cm_lf_evt ben_ler_f.name%TYPE;
718: g_cm_lf_evt_id ben_ler_f.ler_id%TYPE;
719: g_cm_lf_evt_stat ben_per_in_ler.per_in_ler_stat_cd%TYPE;
720: g_cm_lf_evt_ntfn_dt ben_per_in_ler.ntfn_dt%TYPE;
721: g_cm_per_in_ler_id ben_per_cm_f.per_in_ler_id%TYPE;
722: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;

Line 914: g_elig_lfevt_name ben_ler_f.name%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;
918: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;

Line 915: g_elig_ler_id ben_ler_f.ler_id%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;
918: g_elig_lfevt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
919: g_elig_pl_fd_name ben_pl_f.short_name%Type ;

Line 1134: g_cbra_ler_id ben_ler_f.ler_id%TYPE;

1130: g_bng_flex_08 ben_benfts_grp.bng_attribute8%TYPE;
1131: g_bng_flex_09 ben_benfts_grp.bng_attribute9%TYPE;
1132: g_bng_flex_10 ben_benfts_grp.bng_attribute10%TYPE;
1133: --
1134: g_cbra_ler_id ben_ler_f.ler_id%TYPE;
1135: g_cbra_ler_name ben_ler_f.name%TYPE;
1136: g_cbra_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%TYPE;
1137: g_cbra_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;
1138: g_bnft_stat_cd varchar2(1);

Line 1135: g_cbra_ler_name ben_ler_f.name%TYPE;

1131: g_bng_flex_09 ben_benfts_grp.bng_attribute9%TYPE;
1132: g_bng_flex_10 ben_benfts_grp.bng_attribute10%TYPE;
1133: --
1134: g_cbra_ler_id ben_ler_f.ler_id%TYPE;
1135: g_cbra_ler_name ben_ler_f.name%TYPE;
1136: g_cbra_strt_dt ben_cbr_quald_bnf.cbr_elig_perd_strt_dt%TYPE;
1137: g_cbra_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;
1138: g_bnft_stat_cd varchar2(1);
1139: -- current School establishemnt

Line 1151: g_CWB_Life_Event_Name ben_ler_f.name%type ;

1147: g_cwb_per_group_pl_id ben_per_in_ler.group_pl_id%type ;
1148: g_CWB_Person_FULL_NAME ben_cwb_person_info.FULL_NAME%type ;
1149: g_CWB_Person_Custom_Name ben_cwb_person_info.Custom_Name%type ;
1150: g_CWB_Person_Brief_Name ben_cwb_person_info.Brief_Name%type ;
1151: g_CWB_Life_Event_Name ben_ler_f.name%type ;
1152: g_CWB_Life_Event_status ben_ler_f.name%type ;
1153: g_CWB_Life_Event_Occurred_Date ben_per_in_ler.LF_EVT_OCRD_DT%type ;
1154: g_CWB_Person_EMAIL_DDRESS ben_cwb_person_info.EMAIL_ADDRESS%type ;
1155: g_CWB_Person_EMPLOYEE_NUMBER ben_cwb_person_info.EMPLOYEE_NUMBER%Type ;

Line 1152: g_CWB_Life_Event_status ben_ler_f.name%type ;

1148: g_CWB_Person_FULL_NAME ben_cwb_person_info.FULL_NAME%type ;
1149: g_CWB_Person_Custom_Name ben_cwb_person_info.Custom_Name%type ;
1150: g_CWB_Person_Brief_Name ben_cwb_person_info.Brief_Name%type ;
1151: g_CWB_Life_Event_Name ben_ler_f.name%type ;
1152: g_CWB_Life_Event_status ben_ler_f.name%type ;
1153: g_CWB_Life_Event_Occurred_Date ben_per_in_ler.LF_EVT_OCRD_DT%type ;
1154: g_CWB_Person_EMAIL_DDRESS ben_cwb_person_info.EMAIL_ADDRESS%type ;
1155: g_CWB_Person_EMPLOYEE_NUMBER ben_cwb_person_info.EMPLOYEE_NUMBER%Type ;
1156: g_CWB_Person_BASE_SALARY ben_cwb_person_info.BASE_SALARY%type ;