APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on FND_PROFILE

Line 241: IF NVL (fnd_profile.VALUE ('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'

237: IF NVL (l_valid_contact, 'N') <> 'Y'
238: THEN
239: RETURN 'Y';
240: ELSE
241: IF NVL (fnd_profile.VALUE ('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'
242: THEN
243: l_valid_contact := NULL;
244:
245: OPEN cur_val_contact;

Line 933: IF p_template_rec.org_id <> fnd_profile.VALUE ('OKC_GLOBAL_ORG_ID')

929:
930: -- Global flag can be applicable only for global org
931: IF p_template_rec.global_flag = 'Y'
932: THEN
933: IF p_template_rec.org_id <> fnd_profile.VALUE ('OKC_GLOBAL_ORG_ID')
934: THEN
935: okc_api.set_message (p_app_name => g_app_name,
936: p_msg_name => 'OKC_I_INVALID_VALUE',
937: p_token1 => 'FIELD',