APPS.PER_SECURITY_PROFILES_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 616: from fnd_profile_option_values fpv

612: l_exists varchar2(1);
613: --
614: /*cursor sec_profile is
615: select 'x'
616: from fnd_profile_option_values fpv
617: where fpv.profile_option_value = to_char(p_security_profile_id);
618: */
619:
620: -- Modified the cursor as follows for bug 5006762

Line 624: from fnd_profile_option_values fpv ,

620: -- Modified the cursor as follows for bug 5006762
621: --
622: cursor sec_profile is
623: select 'x'
624: from fnd_profile_option_values fpv ,
625: fnd_profile_options fp
626: where fpv.profile_option_value = to_char(p_security_profile_id)
627: -- added the following
628: and fp.application_id = fpv.application_id