APPS.PER_JP_DEPENDENT_PKG dependencies on HR_GENERAL

Line 35: AND (hr_general.chk_geocodes_installed = 'Y'

31: AND descriptive_flexfield_name = 'Address Structure'
32: AND descriptive_flex_context_code = p_style
33: AND enabled_flag = 'Y'
34: AND descriptive_flex_context_code NOT IN ('Global Data Elements','GENERIC')
35: AND (hr_general.chk_geocodes_installed = 'Y'
36: OR descriptive_flex_context_code NOT IN ('CA','US'));
37: --
38: l_style_meaning VARCHAR2(80);
39: --

Line 81: SUBSTRB(hr_general.decode_lookup('ADDRESS_TYPE',address_type),1,80) address_type_meaning,

77: p_date_to OUT NOCOPY DATE) IS
78: --
79: CURSOR cel_address_detail IS
80: SELECT
81: SUBSTRB(hr_general.decode_lookup('ADDRESS_TYPE',address_type),1,80) address_type_meaning,
82: style,
83: primary_flag,
84: address_line1,
85: address_line2,

Line 315: SUBSTRB(hr_general.decode_lookup('PHONE_TYPE',phone_type),1,80) phone_type_meaning,

311: p_date_to OUT NOCOPY DATE) IS
312: --
313: CURSOR cel_phone_detail IS
314: SELECT
315: SUBSTRB(hr_general.decode_lookup('PHONE_TYPE',phone_type),1,80) phone_type_meaning,
316: phone_number,
317: date_from,
318: date_to
319: FROM per_phones

Line 937: p_deductible_spouse_status := hr_general.decode_lookup('JP_SPOUSE_STATUS', l_deductible_spouse_status);

933: p_cohab_svr_dsbl_dpnts => p_severely_disabled_live_with,
934: p_multiple_spouses_warning => l_multiple_spouses_warning,
935: p_use_cache => FALSE);
936: --
937: p_deductible_spouse_status := hr_general.decode_lookup('JP_SPOUSE_STATUS', l_deductible_spouse_status);
938: p_disabled_spouse_status := hr_general.decode_lookup('JP_DISABLED_SPOUSE_STATUS', l_disabled_spouse_status);
939: --
940: ELSE
941: --

Line 938: p_disabled_spouse_status := hr_general.decode_lookup('JP_DISABLED_SPOUSE_STATUS', l_disabled_spouse_status);

934: p_multiple_spouses_warning => l_multiple_spouses_warning,
935: p_use_cache => FALSE);
936: --
937: p_deductible_spouse_status := hr_general.decode_lookup('JP_SPOUSE_STATUS', l_deductible_spouse_status);
938: p_disabled_spouse_status := hr_general.decode_lookup('JP_DISABLED_SPOUSE_STATUS', l_disabled_spouse_status);
939: --
940: ELSE
941: --
942: p_deductible_spouse_status := NULL;