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_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_GENERAL

Line 465: l_information5 := hr_general.decode_lookup('BEN_PRTN_ELIG_STRT',l_epa_rec.prtn_eff_strt_dt_cd)||' '||

461: open ben_plan_design_program_module.g_table_route('EPA');
462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
463: close ben_plan_design_program_module.g_table_route ;
464: --
465: l_information5 := hr_general.decode_lookup('BEN_PRTN_ELIG_STRT',l_epa_rec.prtn_eff_strt_dt_cd)||' '||
466: hr_general.decode_lookup('BEN_PRTN_ELIG_END',l_epa_rec.prtn_eff_end_dt_cd);
467: --'Intersection';
468: --
469: if p_effective_date between l_epa_rec.effective_start_date and l_epa_rec.effective_end_date then

Line 466: hr_general.decode_lookup('BEN_PRTN_ELIG_END',l_epa_rec.prtn_eff_end_dt_cd);

462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
463: close ben_plan_design_program_module.g_table_route ;
464: --
465: l_information5 := hr_general.decode_lookup('BEN_PRTN_ELIG_STRT',l_epa_rec.prtn_eff_strt_dt_cd)||' '||
466: hr_general.decode_lookup('BEN_PRTN_ELIG_END',l_epa_rec.prtn_eff_end_dt_cd);
467: --'Intersection';
468: --
469: if p_effective_date between l_epa_rec.effective_start_date and l_epa_rec.effective_end_date then
470: --

Line 4165: hr_general.decode_lookup('BEN_TM_UOM', l_cgp_rec.pymt_must_be_rcvd_uom);

4161: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4162: close ben_plan_design_program_module.g_table_route ;
4163: --
4164: l_information5 := l_cgp_rec.pymt_must_be_rcvd_num ||' '||
4165: hr_general.decode_lookup('BEN_TM_UOM', l_cgp_rec.pymt_must_be_rcvd_uom);
4166: --'Intersection';
4167: --
4168: if p_effective_date between l_cgp_rec.effective_start_date
4169: and l_cgp_rec.effective_end_date then

Line 4776: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_ebu_rec.brgng_unit_cd)

4772: open ben_plan_design_program_module.g_table_route('EBU');
4773: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4774: close ben_plan_design_program_module.g_table_route ;
4775: --
4776: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_ebu_rec.brgng_unit_cd)
4777: || ben_plan_design_program_module.get_exclude_message(l_ebu_rec.excld_flag);
4778: --'Intersection';
4779: --
4780: if p_effective_date between l_ebu_rec.effective_start_date

Line 5770: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_eds_rec.dsbld_cd)

5766: open ben_plan_design_program_module.g_table_route('EDS');
5767: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5768: close ben_plan_design_program_module.g_table_route ;
5769: --
5770: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_eds_rec.dsbld_cd)
5771: || ben_plan_design_program_module.get_exclude_message(l_eds_rec.excld_flag);
5772: --'Intersection';
5773: --
5774: if p_effective_date between l_eds_rec.effective_start_date

Line 6562: l_information5 := hr_general.decode_lookup('EMP_CAT',l_efp_rec.fl_tm_pt_tm_cd)

6558: open ben_plan_design_program_module.g_table_route('EFP');
6559: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6560: close ben_plan_design_program_module.g_table_route ;
6561: --
6562: l_information5 := hr_general.decode_lookup('EMP_CAT',l_efp_rec.fl_tm_pt_tm_cd)
6563: || ben_plan_design_program_module.get_exclude_message(l_efp_rec.excld_flag);
6564: --'Intersection';
6565: --
6566: if p_effective_date between l_efp_rec.effective_start_date

Line 6817: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_ehs_rec.hrly_slrd_cd)

6813: open ben_plan_design_program_module.g_table_route('EHS');
6814: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6815: close ben_plan_design_program_module.g_table_route ;
6816: --
6817: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_ehs_rec.hrly_slrd_cd)
6818: || ben_plan_design_program_module.get_exclude_message(l_ehs_rec.excld_flag);
6819: --'Intersection';
6820: --
6821: if p_effective_date between l_ehs_rec.effective_start_date

Line 7900: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_elv_rec.lvg_rsn_cd)

7896: open ben_plan_design_program_module.g_table_route('ELV');
7897: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7898: close ben_plan_design_program_module.g_table_route ;
7899: --
7900: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_elv_rec.lvg_rsn_cd)
7901: || ben_plan_design_program_module.get_exclude_message(l_elv_rec.excld_flag);
7902: --'Intersection';
7903: --
7904: if p_effective_date between l_elv_rec.effective_start_date

Line 8005: l_information5 := hr_general.decode_lookup('YES_NO',l_eno_rec.coord_ben_no_cvg_flag);

8001: open ben_plan_design_program_module.g_table_route('ENO');
8002: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8003: close ben_plan_design_program_module.g_table_route ;
8004: --
8005: l_information5 := hr_general.decode_lookup('YES_NO',l_eno_rec.coord_ben_no_cvg_flag);
8006: --'Intersection';
8007: --
8008: if p_effective_date between l_eno_rec.effective_start_date
8009: and l_eno_rec.effective_end_date then

Line 8105: l_information5 := hr_general.decode_lookup('YES_NO',l_eom_rec.optd_mdcr_flag)

8101: open ben_plan_design_program_module.g_table_route('EOM');
8102: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8103: close ben_plan_design_program_module.g_table_route ;
8104: --
8105: l_information5 := hr_general.decode_lookup('YES_NO',l_eom_rec.optd_mdcr_flag)
8106: || ben_plan_design_program_module.get_exclude_message(l_eom_rec.exlcd_flag);
8107: --'Intersection';
8108: --
8109: if p_effective_date between l_eom_rec.effective_start_date

Line 9341: ||' '||hr_general.decode_lookup('FREQUENCY',l_esh_rec.freq_cd)

9337: -- Bug No: 3451872
9338: --
9339: if (l_esh_rec.schedd_hrs_rl is null) then
9340: l_information5 := l_esh_rec.hrs_num ||' - ' ||l_esh_rec.max_hrs_num
9341: ||' '||hr_general.decode_lookup('FREQUENCY',l_esh_rec.freq_cd)
9342: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);
9343:
9344: else
9345: l_information5 := ben_plan_design_program_module.get_formula_name(l_esh_rec.schedd_hrs_rl, p_effective_date)

Line 10061: hr_general.decode_lookup('QUALIFYING_UNITS',l_epn_rec.probation_unit)

10057: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10058: close ben_plan_design_program_module.g_table_route ;
10059: --
10060: l_information5 := l_epn_rec.probation_period ||' '||
10061: hr_general.decode_lookup('QUALIFYING_UNITS',l_epn_rec.probation_unit)
10062: || ben_plan_design_program_module.get_exclude_message(l_epn_rec.excld_flag);
10063: --'Intersection';
10064: --
10065: if p_effective_date between l_epn_rec.effective_start_date

Line 10171: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_emp_rec.marital_status)

10167: open ben_plan_design_program_module.g_table_route('EMP');
10168: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10169: close ben_plan_design_program_module.g_table_route ;
10170: --
10171: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_emp_rec.marital_status)
10172: || ben_plan_design_program_module.get_exclude_message(l_emp_rec.excld_flag);
10173: --'Intersection';
10174: --
10175: if p_effective_date between l_emp_rec.effective_start_date

Line 10278: l_information5 := hr_general.decode_lookup('SEX',l_egn_rec.sex)

10274: open ben_plan_design_program_module.g_table_route('EGN');
10275: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10276: close ben_plan_design_program_module.g_table_route ;
10277: --
10278: l_information5 := hr_general.decode_lookup('SEX',l_egn_rec.sex)
10279: || ben_plan_design_program_module.get_exclude_message(l_egn_rec.excld_flag);
10280: --'Intersection';
10281: --
10282: if p_effective_date between l_egn_rec.effective_start_date

Line 10385: l_information5 := hr_general.decode_lookup('DISABILITY_REASON',l_edr_rec.reason)

10381: open ben_plan_design_program_module.g_table_route('EDR');
10382: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10383: close ben_plan_design_program_module.g_table_route ;
10384: --
10385: l_information5 := hr_general.decode_lookup('DISABILITY_REASON',l_edr_rec.reason)
10386: || ben_plan_design_program_module.get_exclude_message(l_edr_rec.excld_flag);
10387: --'Intersection';
10388: --
10389: if p_effective_date between l_edr_rec.effective_start_date

Line 10893: l_information5 := hr_general.decode_lookup('DISABILITY_CATEGORY',l_ect_rec.category)

10889: open ben_plan_design_program_module.g_table_route('ECT');
10890: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10891: close ben_plan_design_program_module.g_table_route ;
10892: --
10893: l_information5 := hr_general.decode_lookup('DISABILITY_CATEGORY',l_ect_rec.category)
10894: || ben_plan_design_program_module.get_exclude_message(l_ect_rec.excld_flag);
10895: --'Intersection';
10896: --
10897: if p_effective_date between l_ect_rec.effective_start_date

Line 11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)

10996: open ben_plan_design_program_module.g_table_route('ERG');
10997: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10998: close ben_plan_design_program_module.g_table_route ;
10999: --
11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)
11001: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_erg_rec.perf_rtng_cd)
11002: || ben_plan_design_program_module.get_exclude_message(l_erg_rec.excld_flag);
11003: --'Intersection';
11004: --

Line 11001: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_erg_rec.perf_rtng_cd)

10997: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10998: close ben_plan_design_program_module.g_table_route ;
10999: --
11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)
11001: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_erg_rec.perf_rtng_cd)
11002: || ben_plan_design_program_module.get_exclude_message(l_erg_rec.excld_flag);
11003: --'Intersection';
11004: --
11005: if p_effective_date between l_erg_rec.effective_start_date

Line 11107: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_eqg_rec.quar_in_grade_cd)

11103: open ben_plan_design_program_module.g_table_route('EQG');
11104: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11105: close ben_plan_design_program_module.g_table_route ;
11106: --
11107: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_eqg_rec.quar_in_grade_cd)
11108: || ben_plan_design_program_module.get_exclude_message(l_eqg_rec.excld_flag);
11109: -- 'Intersection';
11110: --
11111: if p_effective_date between l_eqg_rec.effective_start_date

Line 11213: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_etu_rec.uses_tbco_flag)

11209: open ben_plan_design_program_module.g_table_route('ETU');
11210: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11211: close ben_plan_design_program_module.g_table_route ;
11212: --
11213: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_etu_rec.uses_tbco_flag)
11214: || ben_plan_design_program_module.get_exclude_message(l_etu_rec.excld_flag);
11215: --Intersection';
11216: --
11217: if p_effective_date between l_etu_rec.effective_start_date

Line 11559: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edb_rec.dsbld_cd)

11555: open ben_plan_design_program_module.g_table_route('EDB');
11556: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11557: close ben_plan_design_program_module.g_table_route ;
11558: --
11559: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edb_rec.dsbld_cd)
11560: || ben_plan_design_program_module.get_exclude_message(l_edb_rec.excld_flag);
11561: -- 'Intersection';
11562: --
11563: if p_effective_date between l_edb_rec.effective_start_date

Line 12781: l_information5 := hr_general.decode_lookup('CONTACT',l_dcr_rec.per_relshp_typ_cd);

12777: open ben_plan_design_program_module.g_table_route('DCR');
12778: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12779: close ben_plan_design_program_module.g_table_route ;
12780: --
12781: l_information5 := hr_general.decode_lookup('CONTACT',l_dcr_rec.per_relshp_typ_cd);
12782: --'Intersection';
12783: --
12784: if p_effective_date between l_dcr_rec.effective_start_date
12785: and l_dcr_rec.effective_end_date then

Line 13015: l_information5 := hr_general.decode_lookup('YES_NO',l_dec_rec.dsgntr_crntly_enrld_flag);

13011: open ben_plan_design_program_module.g_table_route('DEC');
13012: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13013: close ben_plan_design_program_module.g_table_route ;
13014: --
13015: l_information5 := hr_general.decode_lookup('YES_NO',l_dec_rec.dsgntr_crntly_enrld_flag);
13016: --'Intersection';
13017: --
13018: if p_effective_date between l_dec_rec.effective_start_date
13019: and l_dec_rec.effective_end_date then

Line 13263: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edc_rec.dsbld_cd);

13259: open ben_plan_design_program_module.g_table_route('EDC');
13260: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13261: close ben_plan_design_program_module.g_table_route ;
13262: --
13263: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edc_rec.dsbld_cd);
13264: --'Intersection';
13265: --
13266: if p_effective_date between l_edc_rec.effective_start_date
13267: and l_edc_rec.effective_end_date then

Line 13391: l_information5 := hr_general.decode_lookup('YES_NO',l_emc_rec.mltry_stat_cd);

13387: open ben_plan_design_program_module.g_table_route('EMC');
13388: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13389: close ben_plan_design_program_module.g_table_route ;
13390: --
13391: l_information5 := hr_general.decode_lookup('YES_NO',l_emc_rec.mltry_stat_cd);
13392: --'Intersection';
13393: --
13394: if p_effective_date between l_emc_rec.effective_start_date
13395: and l_emc_rec.effective_end_date then

Line 13521: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_ems_rec.mrtl_stat_cd);

13517: open ben_plan_design_program_module.g_table_route('EMS');
13518: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13519: close ben_plan_design_program_module.g_table_route ;
13520: --
13521: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_ems_rec.mrtl_stat_cd);
13522: --'Intersection';
13523: --
13524: if p_effective_date between l_ems_rec.effective_start_date
13525: and l_ems_rec.effective_end_date then

Line 13767: l_information5 := hr_general.decode_lookup('STUDENT_STATUS',l_esc_rec.stdnt_stat_cd);

13763: open ben_plan_design_program_module.g_table_route('ESC');
13764: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13765: close ben_plan_design_program_module.g_table_route ;
13766: --
13767: l_information5 := hr_general.decode_lookup('STUDENT_STATUS',l_esc_rec.stdnt_stat_cd);
13768: --'Intersection';
13769: --
13770: if p_effective_date between l_esc_rec.effective_start_date
13771: and l_esc_rec.effective_end_date then