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

Line 1326: l_information5 := hr_general.decode_lookup('BEN_PYMT_SCHED',l_apf_rec.pymt_sched_cd); --'Intersection';

1322: open ben_plan_design_program_module.g_table_route('APF');
1323: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1324: close ben_plan_design_program_module.g_table_route ;
1325: --
1326: l_information5 := hr_general.decode_lookup('BEN_PYMT_SCHED',l_apf_rec.pymt_sched_cd); --'Intersection';
1327: --
1328: if p_effective_date between l_apf_rec.effective_start_date
1329: and l_apf_rec.effective_end_date then
1330: --

Line 1445: l_information5 := hr_general.decode_lookup('BEN_FREQ',l_psq_rec.py_freq_cd); --'Intersection';

1441: open ben_plan_design_program_module.g_table_route('PSQ');
1442: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1443: close ben_plan_design_program_module.g_table_route ;
1444: --
1445: l_information5 := hr_general.decode_lookup('BEN_FREQ',l_psq_rec.py_freq_cd); --'Intersection';
1446: --
1447: l_result_type_cd := 'DISPLAY';
1448: --
1449: l_copy_entity_result_id := null;

Line 2356: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_abc_rec.enrt_ctfn_typ_cd);

2352: open ben_plan_design_program_module.g_table_route('ABC');
2353: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2354: close ben_plan_design_program_module.g_table_route ;
2355: --
2356: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_abc_rec.enrt_ctfn_typ_cd);
2357: --'Intersection';
2358: --
2359: if p_effective_date between l_abc_rec.effective_start_date
2360: and l_abc_rec.effective_end_date then

Line 8711: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_bur_rec.brgng_unit_cd)

8707: open ben_plan_design_program_module.g_table_route('BUR');
8708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8709: close ben_plan_design_program_module.g_table_route ;
8710: --
8711: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_bur_rec.brgng_unit_cd)
8712: || ben_plan_design_program_module.get_exclude_message(l_bur_rec.excld_flag);
8713: --'Intersection';
8714: --
8715: if p_effective_date between l_bur_rec.effective_start_date

Line 9058: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_dbr_rec.dsbld_cd)

9054: open ben_plan_design_program_module.g_table_route('DBR');
9055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9056: close ben_plan_design_program_module.g_table_route ;
9057: --
9058: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_dbr_rec.dsbld_cd)
9059: || ben_plan_design_program_module.get_exclude_message(l_dbr_rec.excld_flag);
9060: --'Intersection';
9061: --
9062: if p_effective_date between l_dbr_rec.effective_start_date

Line 9300: l_information5 := hr_general.decode_lookup('EMP_CAT',l_ftr_rec.fl_tm_pt_tm_cd)

9296: open ben_plan_design_program_module.g_table_route('FTR');
9297: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9298: close ben_plan_design_program_module.g_table_route ;
9299: --
9300: l_information5 := hr_general.decode_lookup('EMP_CAT',l_ftr_rec.fl_tm_pt_tm_cd)
9301: || ben_plan_design_program_module.get_exclude_message(l_ftr_rec.excld_flag); --'Intersection';
9302: --
9303: if p_effective_date between l_ftr_rec.effective_start_date
9304: and l_ftr_rec.effective_end_date then

Line 9402: l_information5 := hr_general.decode_lookup('BEN_GNDR',l_gnr_rec.gndr_cd)

9398: open ben_plan_design_program_module.g_table_route('GNR');
9399: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9400: close ben_plan_design_program_module.g_table_route ;
9401: --
9402: l_information5 := hr_general.decode_lookup('BEN_GNDR',l_gnr_rec.gndr_cd)
9403: || ben_plan_design_program_module.get_exclude_message(l_gnr_rec.excld_flag); --'Intersection';
9404: --
9405: if p_effective_date between l_gnr_rec.effective_start_date
9406: and l_gnr_rec.effective_end_date then

Line 9651: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_hsr_rec.hrly_slrd_cd)

9647: open ben_plan_design_program_module.g_table_route('HSR');
9648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9649: close ben_plan_design_program_module.g_table_route ;
9650: --
9651: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_hsr_rec.hrly_slrd_cd)
9652: || ben_plan_design_program_module.get_exclude_message(l_hsr_rec.excld_flag); --'Intersection';
9653: --
9654: if p_effective_date between l_hsr_rec.effective_start_date
9655: and l_hsr_rec.effective_end_date then

Line 10424: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_lrn_rec.lvg_rsn_cd)

10420: open ben_plan_design_program_module.g_table_route('LRN');
10421: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10422: close ben_plan_design_program_module.g_table_route ;
10423: --
10424: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_lrn_rec.lvg_rsn_cd)
10425: || ben_plan_design_program_module.get_exclude_message(l_lrn_rec.excld_flag);
10426: --
10427: if p_effective_date between l_lrn_rec.effective_start_date
10428: and l_lrn_rec.effective_end_date then

Line 10936: ' ' || hr_general.decode_lookup('BEN_NNMNTRY_UOM',l_prt_rec.poe_nnmntry_uom);

10932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10933: close ben_plan_design_program_module.g_table_route ;
10934: --
10935: l_information5 := l_prt_rec.mn_poe_num ||' - '|| l_prt_rec.mx_poe_num ||
10936: ' ' || hr_general.decode_lookup('BEN_NNMNTRY_UOM',l_prt_rec.poe_nnmntry_uom);
10937: --'Intersection';
10938: --
10939: if p_effective_date between l_prt_rec.effective_start_date
10940: and l_prt_rec.effective_end_date then

Line 11576: hr_general.decode_lookup('FREQUENCY',l_shr_rec.freq_cd)

11572: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11573: close ben_plan_design_program_module.g_table_route ;
11574: --
11575: l_information5 := l_shr_rec.hrs_num ||' - ' || l_shr_rec.max_hrs_num ||' '||
11576: hr_general.decode_lookup('FREQUENCY',l_shr_rec.freq_cd)
11577: || ben_plan_design_program_module.get_exclude_message(l_shr_rec.excld_flag); --'Intersection';
11578: --
11579: if p_effective_date between l_shr_rec.effective_start_date
11580: and l_shr_rec.effective_end_date then

Line 11864: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_tur_rec.uses_tbco_flag)

11860: open ben_plan_design_program_module.g_table_route('TUR');
11861: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11862: close ben_plan_design_program_module.g_table_route ;
11863: --
11864: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_tur_rec.uses_tbco_flag)
11865: || ben_plan_design_program_module.get_exclude_message(l_tur_rec.excld_flag);
11866: --Intersection';
11867: --
11868: if p_effective_date between l_tur_rec.effective_start_date

Line 13337: hr_general.decode_lookup('BEN_TM_UOM', l_cpn_rec.pymt_must_be_rcvd_uom);

13333: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13334: close ben_plan_design_program_module.g_table_route ;
13335: --
13336: l_information5 := l_cpn_rec.pymt_must_be_rcvd_num ||' '||
13337: hr_general.decode_lookup('BEN_TM_UOM', l_cpn_rec.pymt_must_be_rcvd_uom);
13338: --'Intersection';
13339:
13340: if p_effective_date between l_cpn_rec.effective_start_date
13341: and l_cpn_rec.effective_end_date then

Line 14479: l_information5 := hr_general.decode_lookup('YES_NO',l_noc_rec.coord_ben_no_cvg_flag);

14475: open ben_plan_design_program_module.g_table_route('NOC');
14476: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14477: close ben_plan_design_program_module.g_table_route ;
14478: --
14479: l_information5 := hr_general.decode_lookup('YES_NO',l_noc_rec.coord_ben_no_cvg_flag);
14480: --'Intersection';
14481: --
14482: if p_effective_date between l_noc_rec.effective_start_date
14483: and l_noc_rec.effective_end_date then

Line 14578: l_information5 := hr_general.decode_lookup('YES_NO',l_omr_rec.optd_mdcr_flag)

14574: open ben_plan_design_program_module.g_table_route('OMR');
14575: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14576: close ben_plan_design_program_module.g_table_route ;
14577: --
14578: l_information5 := hr_general.decode_lookup('YES_NO',l_omr_rec.optd_mdcr_flag)
14579: || ben_plan_design_program_module.get_exclude_message(l_omr_rec.exlcd_flag);
14580: --
14581: if p_effective_date between l_omr_rec.effective_start_date
14582: and l_omr_rec.effective_end_date then

Line 14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)

14774: open ben_plan_design_program_module.g_table_route('PRR');
14775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14776: close ben_plan_design_program_module.g_table_route ;
14777: --
14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)
14779: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_prr_rec.perf_rtng_cd)
14780: || ben_plan_design_program_module.get_exclude_message(l_prr_rec.excld_flag);
14781: --'Intersection';
14782: --

Line 14779: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_prr_rec.perf_rtng_cd)

14775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14776: close ben_plan_design_program_module.g_table_route ;
14777: --
14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)
14779: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_prr_rec.perf_rtng_cd)
14780: || ben_plan_design_program_module.get_exclude_message(l_prr_rec.excld_flag);
14781: --'Intersection';
14782: --
14783: if p_effective_date between l_prr_rec.effective_start_date

Line 14882: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_qig_rec.quar_in_grade_cd)

14878: open ben_plan_design_program_module.g_table_route('QIG');
14879: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14880: close ben_plan_design_program_module.g_table_route ;
14881: --
14882: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_qig_rec.quar_in_grade_cd)
14883: || ben_plan_design_program_module.get_exclude_message(l_qig_rec.excld_flag);
14884: -- 'Intersection';
14885: --
14886: if p_effective_date between l_qig_rec.effective_start_date