APPS.IEU_DIAGNOSTICS_PVT dependencies on FND_PROFILE_OPTIONS

Line 1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b

1214: e.SEL_ENUM_ID enum_id
1215: FROM
1216: IEU_UWQ_SEL_ENUMERATORS e,
1217: fnd_lookup_values l
1218: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1219: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1220: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1221: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
1222: AND l.language = l_language

Line 1710: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b

1706: e.work_q_label_lu_type,
1707: e.work_q_label_lu_code
1708: FROM
1709: IEU_UWQ_SEL_ENUMERATORS e
1710: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
1711: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
1712: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
1713: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
1714: AND (e.work_q_register_type <> 'W' or e.work_q_register_type is null)

Line 2565: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b

2561: e.work_q_label_lu_type,
2562: e.work_q_label_lu_code
2563: FROM
2564: IEU_UWQ_SEL_ENUMERATORS e
2565: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
2566: where upper(b.PROFILE_OPTION_NAME) = upper(e.work_q_enable_profile_option))
2567: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND
2568: (nvl(fnd_profile.value(e.work_q_enable_profile_option),'Y') = 'Y')
2569: order by e.sel_enum_id;