DBA Data[Home] [Help]

APPS.PER_SECURITY_PROFILES_PKG dependencies on FND_PROFILE_OPTIONS

Line 581: fnd_profile_options fp

577: --
578: cursor sec_profile is
579: select 'x'
580: from fnd_profile_option_values fpv ,
581: fnd_profile_options fp
582: where fpv.profile_option_value = to_char(p_security_profile_id)
583: -- added the following
584: and fp.application_id = fpv.application_id
585: and fp.profile_option_id = fpv.profile_option_id