DBA Data[Home] [Help]

APPS.IEU_PVT dependencies on FND_PROFILE_OPTIONS

Line 481: FND_PROFILE_OPTIONS

477: PROFILE_OPTION_ID
478: INTO
479: l_profile_id
480: FROM
481: FND_PROFILE_OPTIONS
482: WHERE
483: PROFILE_OPTION_NAME = L_WORK_Q_ENABLE_PROFILE_OPTION;
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN

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

698: e.work_q_register_type,
699: e.media_type_id
700: FROM
701: IEU_UWQ_SEL_ENUMERATORS e
702: WHERE EXISTS (select 'x' from FND_PROFILE_OPTIONS b
703: where b.PROFILE_OPTION_NAME = upper(e.work_q_enable_profile_option)
704: and (b.end_date_active is null -- Niraj, bug 4738501, Added
705: or trunc(b.end_date_active) > trunc(sysdate))) -- Niraj, Bug 5031721, Added
706: AND ((e.NOT_VALID_FLAG is NULL) OR (e.NOT_VALID_FLAG = 'N')) AND