568: l_exists varchar2(1);
569: --
570: /*cursor sec_profile is
571: select 'x'
572: from fnd_profile_option_values fpv
573: where fpv.profile_option_value = to_char(p_security_profile_id);
574: */
575:
576: -- Modified the cursor as follows for bug 5006762
576: -- Modified the cursor as follows for bug 5006762
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