APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on HR_GENERAL

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

1649: open g_table_route('LCC');
1650: fetch g_table_route into l_table_route_id ;
1651: close g_table_route ;
1652: --
1653: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
1654: --
1655:
1656: if p_effective_date between l_lcc_rec.effective_start_date
1657: and l_lcc_rec.effective_end_date then

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

2241: open g_table_route('PGC');
2242: fetch g_table_route into l_table_route_id ;
2243: close g_table_route ;
2244: --
2245: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pgc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
2246: --
2247:
2248: if p_effective_date between l_pgc_rec.effective_start_date
2249: and l_pgc_rec.effective_end_date then

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

3324: open g_table_route('LCC');
3325: fetch g_table_route into l_table_route_id ;
3326: close g_table_route ;
3327: --
3328: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
3329: --
3330: if p_effective_date between l_lcc_rec.effective_start_date
3331: and l_lcc_rec.effective_end_date then
3332: --

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

3591: open g_table_route('PYD');
3592: fetch g_table_route into l_table_route_id ;
3593: close g_table_route ;
3594: --
3595: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pyd_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
3596: --
3597: if p_effective_date between l_pyd_rec.effective_start_date
3598: and l_pyd_rec.effective_end_date then
3599: --

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

3716: open g_table_route('WPT');
3717: fetch g_table_route into l_table_route_id ;
3718: close g_table_route ;
3719: --
3720: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_RSN',l_wpt_rec.wv_prtn_rsn_cd); --'Intersection';
3721: --
3722: if p_effective_date between l_wpt_rec.effective_start_date
3723: and l_wpt_rec.effective_end_date then
3724: --

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

3809: open g_table_route('WCT');
3810: fetch g_table_route into l_table_route_id ;
3811: close g_table_route ;
3812: --
3813: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_CTFN_TYP',l_wct_rec.wv_prtn_ctfn_typ_cd); --'Intersection';
3814: --
3815: if p_effective_date between l_wct_rec.effective_start_date
3816: and l_wct_rec.effective_end_date then
3817: --

Line 6841: l_lbr_mmbr_name := hr_general.decode_lookup('YES_NO',p_lbr_mmbr_flag);

6837: l_lbr_mmbr_name hr_lookups.meaning%type;
6838:
6839: begin
6840:
6841: l_lbr_mmbr_name := hr_general.decode_lookup('YES_NO',p_lbr_mmbr_flag);
6842:
6843: return l_lbr_mmbr_name;
6844:
6845: end get_lbr_mmbr_name;