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

Line 1419: l_pl_usage := hr_general.decode_lookup('BEN_PL',l_pln_rec.pl_cd);

1415: --
1416: l_information5 := l_pln_rec.name; --'Intersection';
1417: --
1418: l_pl_typ_name := ben_plan_design_program_module.get_pl_typ_name(l_pln_rec.pl_typ_id,p_effective_date);
1419: l_pl_usage := hr_general.decode_lookup('BEN_PL',l_pln_rec.pl_cd);
1420: --
1421: if p_effective_date between l_pln_rec.effective_start_date
1422: and l_pln_rec.effective_end_date then
1423: --

Line 3019: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);

3015: open ben_plan_design_program_module.g_table_route('PRP');
3016: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3017: close ben_plan_design_program_module.g_table_route ;
3018: --
3019: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);
3020: --
3021: if p_effective_date between l_prp_rec.effective_start_date
3022: and l_prp_rec.effective_end_date then
3023: --

Line 3338: l_information5 := hr_general.decode_lookup('BEN_REIMBMT_CTFN_TYP',l_pct_rec.rmbmt_ctfn_typ_cd); --'Intersection

3334: open ben_plan_design_program_module.g_table_route('PCT');
3335: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3336: close ben_plan_design_program_module.g_table_route ;
3337: --
3338: l_information5 := hr_general.decode_lookup('BEN_REIMBMT_CTFN_TYP',l_pct_rec.rmbmt_ctfn_typ_cd); --'Intersection
3339: --
3340: l_pl_gd_r_svc_ctfn_id := l_pct_rec.pl_gd_r_svc_ctfn_id ;
3341: if p_effective_date between l_pct_rec.effective_start_date
3342: and l_pct_rec.effective_end_date then

Line 3467: l_information5 := hr_general.decode_lookup('CONTACT',l_vrp_rec.rlshp_typ_cd); --'Intersection

3463: open ben_plan_design_program_module.g_table_route('VRP');
3464: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3465: close ben_plan_design_program_module.g_table_route ;
3466: --
3467: l_information5 := hr_general.decode_lookup('CONTACT',l_vrp_rec.rlshp_typ_cd); --'Intersection
3468: --
3469: if p_effective_date between l_vrp_rec.effective_start_date
3470: and l_vrp_rec.effective_end_date then
3471: --

Line 3564: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_RSN',l_wpn_rec.wv_prtn_rsn_cd); --'Intersection';

3560: open ben_plan_design_program_module.g_table_route('WPN');
3561: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3562: close ben_plan_design_program_module.g_table_route ;
3563: --
3564: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_RSN',l_wpn_rec.wv_prtn_rsn_cd); --'Intersection';
3565: --
3566: l_wv_prtn_rsn_pl_id := l_wpn_rec.wv_prtn_rsn_pl_id ;
3567: --
3568: if p_effective_date between l_wpn_rec.effective_start_date

Line 3658: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_CTFN_TYP',l_wcn_rec.wv_prtn_ctfn_typ_cd); --'Intersection';

3654: open ben_plan_design_program_module.g_table_route('WCN');
3655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3656: close ben_plan_design_program_module.g_table_route ;
3657: --
3658: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_CTFN_TYP',l_wcn_rec.wv_prtn_ctfn_typ_cd); --'Intersection';
3659: --
3660: l_wv_prtn_rsn_ctfn_pl_id := l_wcn_rec.wv_prtn_rsn_ctfn_pl_id ;
3661: if p_effective_date between l_wcn_rec.effective_start_date
3662: and l_wcn_rec.effective_end_date then

Line 3778: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_brc_rec.enrt_ctfn_typ_cd); --'Intersection';

3774: open ben_plan_design_program_module.g_table_route('BRC');
3775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3776: close ben_plan_design_program_module.g_table_route ;
3777: --
3778: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_brc_rec.enrt_ctfn_typ_cd); --'Intersection';
3779: --
3780: if p_effective_date between l_brc_rec.effective_start_date
3781: and l_brc_rec.effective_end_date then
3782: --

Line 4055: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lbc_rec.enrt_ctfn_typ_cd); --'Intersection';

4051: open ben_plan_design_program_module.g_table_route('LBC');
4052: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4053: close ben_plan_design_program_module.g_table_route ;
4054: --
4055: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lbc_rec.enrt_ctfn_typ_cd); --'Intersection';
4056: --
4057: l_ler_bnft_rstrn_ctfn_id := l_lbc_rec.ler_bnft_rstrn_ctfn_id ;
4058: if p_effective_date between l_lbc_rec.effective_start_date
4059: and l_lbc_rec.effective_end_date then

Line 4174: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection';

4170: open ben_plan_design_program_module.g_table_route('ECF');
4171: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4172: close ben_plan_design_program_module.g_table_route ;
4173: --
4174: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection';
4175: --
4176: if p_effective_date between l_ecf_rec.effective_start_date
4177: and l_ecf_rec.effective_end_date then
4178: --

Line 4441: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';

4437: open ben_plan_design_program_module.g_table_route('LCC');
4438: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4439: close ben_plan_design_program_module.g_table_route ;
4440: --
4441: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
4442: --
4443: l_ler_chg_dpnt_cvg_ctfn_id := l_lcc_rec.ler_chg_dpnt_cvg_ctfn_id ;
4444: if p_effective_date between l_lcc_rec.effective_start_date
4445: and l_lcc_rec.effective_end_date then

Line 4839: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection';

4835: open ben_plan_design_program_module.g_table_route('LNC');
4836: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4837: close ben_plan_design_program_module.g_table_route ;
4838: --
4839: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection';
4840: --
4841: l_ler_enrt_ctfn_id := l_lnc_rec.ler_enrt_ctfn_id ;
4842: if p_effective_date between l_lnc_rec.effective_start_date
4843: and l_lnc_rec.effective_end_date then

Line 4956: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dsgn_cd) ||' - '||

4952: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4953: close ben_plan_design_program_module.g_table_route ;
4954: --
4955: l_information5 := fnd_message.get_string('BEN','BEN_93292_PDC_PCP_DSGN_CD') ||' - '||
4956: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dsgn_cd) ||' - '||
4957: fnd_message.get_string('BEN','BEN_93293_PDC_PCP_DPNT_DSGN_CD') ||' - '||
4958: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dpnt_dsgn_cd); --'Intersection
4959: --
4960: l_result_type_cd := 'DISPLAY';

Line 4958: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dpnt_dsgn_cd); --'Intersection

4954: --
4955: l_information5 := fnd_message.get_string('BEN','BEN_93292_PDC_PCP_DSGN_CD') ||' - '||
4956: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dsgn_cd) ||' - '||
4957: fnd_message.get_string('BEN','BEN_93293_PDC_PCP_DPNT_DSGN_CD') ||' - '||
4958: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dpnt_dsgn_cd); --'Intersection
4959: --
4960: l_result_type_cd := 'DISPLAY';
4961: --
4962: l_copy_entity_result_id := null;

Line 5058: l_information5 := hr_general.decode_lookup('BEN_PCP_SPCLTY',l_pty_rec.pcp_typ_cd); --'Intersection

5054: open ben_plan_design_program_module.g_table_route('PTY');
5055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5056: close ben_plan_design_program_module.g_table_route ;
5057: --
5058: l_information5 := hr_general.decode_lookup('BEN_PCP_SPCLTY',l_pty_rec.pcp_typ_cd); --'Intersection
5059: --
5060: l_result_type_cd := 'DISPLAY';
5061: --
5062: l_copy_entity_result_id := null;

Line 5152: l_information5 := hr_general.decode_lookup('BEN_BNF_CTFN_TYP',l_pcx_rec.bnf_ctfn_typ_cd); --'Intersection

5148: open ben_plan_design_program_module.g_table_route('PCX');
5149: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5150: close ben_plan_design_program_module.g_table_route ;
5151: --
5152: l_information5 := hr_general.decode_lookup('BEN_BNF_CTFN_TYP',l_pcx_rec.bnf_ctfn_typ_cd); --'Intersection
5153: --
5154: if p_effective_date between l_pcx_rec.effective_start_date
5155: and l_pcx_rec.effective_end_date then
5156: --

Line 5267: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pnd_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection

5263: open ben_plan_design_program_module.g_table_route('PND');
5264: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5265: close ben_plan_design_program_module.g_table_route ;
5266: --
5267: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pnd_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection
5268: --
5269: if p_effective_date between l_pnd_rec.effective_start_date
5270: and l_pnd_rec.effective_end_date then
5271: --

Line 5602: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';

5598: open ben_plan_design_program_module.g_table_route('DDR');
5599: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5600: close ben_plan_design_program_module.g_table_route ;
5601: --
5602: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
5603: --
5604: if p_effective_date between l_ddr_rec.effective_start_date
5605: and l_ddr_rec.effective_end_date then
5606: --

Line 5709: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';

5705: open ben_plan_design_program_module.g_table_route('DRR');
5706: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5707: close ben_plan_design_program_module.g_table_route ;
5708: --
5709: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
5710: --
5711: l_result_type_cd := 'DISPLAY';
5712: --
5713: l_copy_entity_result_id := null;

Line 6934: l_information5 := hr_general.decode_lookup('BEN_ENRT_TYP_CYCL',l_pet_rec.enrt_typ_cycl_cd); --'Intersection';

6930: open ben_plan_design_program_module.g_table_route('PET');
6931: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6932: close ben_plan_design_program_module.g_table_route ;
6933: --
6934: l_information5 := hr_general.decode_lookup('BEN_ENRT_TYP_CYCL',l_pet_rec.enrt_typ_cycl_cd); --'Intersection';
6935: if p_effective_date between l_pet_rec.effective_start_date
6936: and l_pet_rec.effective_end_date then
6937: --
6938: l_result_type_cd := 'DISPLAY';

Line 8886: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);

8882: open ben_plan_design_program_module.g_table_route('PRP');
8883: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8884: close ben_plan_design_program_module.g_table_route ;
8885: --
8886: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);
8887: --
8888: if p_effective_date between l_prp_rec.effective_start_date
8889: and l_prp_rec.effective_end_date then
8890: --

Line 10711: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';

10707: open ben_plan_design_program_module.g_table_route('DDR');
10708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10709: close ben_plan_design_program_module.g_table_route ;
10710: --
10711: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
10712: --
10713: if p_effective_date between l_ddr_rec.effective_start_date
10714: and l_ddr_rec.effective_end_date then
10715: --

Line 10818: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';

10814: open ben_plan_design_program_module.g_table_route('DRR');
10815: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10816: close ben_plan_design_program_module.g_table_route ;
10817: --
10818: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
10819: --
10820: l_result_type_cd := 'DISPLAY';
10821: --
10822: l_copy_entity_result_id := null;

Line 11221: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection'

11217: open ben_plan_design_program_module.g_table_route('ECF');
11218: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11219: close ben_plan_design_program_module.g_table_route ;
11220: --
11221: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection'
11222: --
11223: if p_effective_date between l_ecf_rec.effective_start_date
11224: and l_ecf_rec.effective_end_date then
11225: --

Line 11432: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection'

11428: open ben_plan_design_program_module.g_table_route('LNC');
11429: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11430: close ben_plan_design_program_module.g_table_route ;
11431: --
11432: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection'
11433: --
11434: if p_effective_date between l_lnc_rec.effective_start_date
11435: and l_lnc_rec.effective_end_date then
11436: --

Line 11983: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';

11979: open ben_plan_design_program_module.g_table_route('DDR');
11980: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11981: close ben_plan_design_program_module.g_table_route ;
11982: --
11983: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
11984: --
11985: if p_effective_date between l_ddr_rec.effective_start_date
11986: and l_ddr_rec.effective_end_date then
11987: --

Line 12090: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';

12086: open ben_plan_design_program_module.g_table_route('DRR');
12087: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12088: close ben_plan_design_program_module.g_table_route ;
12089: --
12090: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
12091: --
12092: l_result_type_cd := 'DISPLAY';
12093: --
12094: l_copy_entity_result_id := null;

Line 12186: l_information5 := hr_general.decode_lookup('BEN_OPT_TYP',l_pon_rec.pl_typ_opt_typ_cd); --'Intersection';

12182: open ben_plan_design_program_module.g_table_route('PON');
12183: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12184: close ben_plan_design_program_module.g_table_route ;
12185: --
12186: l_information5 := hr_general.decode_lookup('BEN_OPT_TYP',l_pon_rec.pl_typ_opt_typ_cd); --'Intersection';
12187: --
12188: if p_effective_date between l_pon_rec.effective_start_date
12189: and l_pon_rec.effective_end_date then
12190: --