APPS.BEN_EXT_FMT dependencies on HR_GENERAL

Line 632: l_rslt_elmt := nvl(hr_general.DECODE_FND_COMM_LOOKUP(l_lookup_type,

628: l_rslt_elmt := ben_ext_person.g_cm_addr_line2;
629: ELSIF p_short_name = 'CMAD3' THEN
630: l_rslt_elmt := ben_ext_person.g_cm_addr_line3;
631: ELSIF p_short_name = 'CMCNTY' THEN -- Fix for Bug 2593220
632: l_rslt_elmt := nvl(hr_general.DECODE_FND_COMM_LOOKUP(l_lookup_type,
633: ben_ext_person.g_cm_county),
634: ben_ext_person.g_cm_county);
635: --l_rslt_elmt := ben_ext_person.g_cm_county; -- End of Fix, Bug 2593220
636: ELSIF p_short_name = 'CMCRY' THEN

Line 2071: l_rslt_elmt := nvl(hr_general.DECODE_FND_COMM_LOOKUP(l_lookup_type,

2067: l_rslt_elmt :=
2068: apply_format_mask(ben_ext_person.g_mail_address_date, p_frmt_mask_cd);
2069: --
2070: ELSIF p_short_name = 'MLCNTY' THEN -- Fix for Bug 2593220
2071: l_rslt_elmt := nvl(hr_general.DECODE_FND_COMM_LOOKUP(l_lookup_type,
2072: ben_ext_person.g_mail_county),
2073: ben_ext_person.g_mail_county);
2074: --l_rslt_elmt := ben_ext_person.g_mail_county; -- End of fix, Bug 2593220
2075: ELSIF p_short_name = 'MLCRY' THEN

Line 3198: l_rslt_elmt := nvl(hr_general.DECODE_FND_COMM_LOOKUP(l_lookup_type,

3194: -- For UK Legislation, the County code is stored in the
3195: -- Region_1 column of per_addresses instead of County name.
3196: -- So we need to get the County name from fnd_common_lookups, for lookup_type 'GB_COUNTY'
3197:
3198: l_rslt_elmt := nvl(hr_general.DECODE_FND_COMM_LOOKUP(l_lookup_type,
3199: ben_ext_person.g_prim_county),
3200: ben_ext_person.g_prim_county);
3201: --l_rslt_elmt := ben_ext_person.g_prim_county; -- End of Fix, Bug 2593220
3202: ELSIF p_short_name = 'PRCRY' THEN

Line 4307: l_frmt_mask_cd := hr_general.decode_lookup('BEN_EXT_FRMT_MASK',

4303: elmt.ttl_fnctn_cd := l_ttl_fnctn_cd_va(i) ;
4304: elmt.defined_balance_id := l_defined_balance_id_va(i) ;
4305:
4306: if elmt.frmt_mask_lookup_cd is not null then
4307: l_frmt_mask_cd := hr_general.decode_lookup('BEN_EXT_FRMT_MASK',
4308: elmt.frmt_mask_lookup_cd ) ;
4309: end if ;
4310:
4311: if elmt.short_name is not null then