DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_PROFILE_OPTIONS

Line 775: from fnd_profile_options

771: server_enabled_flag,
772: SERVERRESP_ENABLED_FLAG,
773: hierarchy_type,
774: user_changeable_flag -- Bug 4257739
775: from fnd_profile_options
776: where profile_option_name = name_z -- Bug 5599946: Removed UPPER call
777: and start_date_active <= sysdate
778: and nvl(end_date_active, sysdate) >= sysdate;
779:

Line 1354: from fnd_profile_options

1350: server_enabled_flag,
1351: serverresp_enabled_flag,
1352: hierarchy_type,
1353: user_changeable_flag -- Bug 4257739
1354: from fnd_profile_options
1355: where profile_option_name = name_z
1356: and start_date_active <= sysdate
1357: and nvl(end_date_active, sysdate) >= sysdate;
1358:

Line 3149: from fnd_profile_options po

3145: X_NAME_UPPER VARCHAR2(80) := upper(X_NAME);
3146:
3147: cursor C1 is
3148: select application_id, profile_option_id
3149: from fnd_profile_options po
3150: where po.profile_option_name = X_NAME_UPPER
3151: /* Bug 5591340: FND_PROFILE.SAVE SHOULD NOT UPDATE VALUES FOR END_DATED
3152: ** PROFILE OPTIONS
3153: ** Added these date-sensitive conditions to prevent processing of