eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_DELETE_UNWANTED_SEC_PROF dependencies on FND_PROFILE_OPTIONS

Line 143: FROM fnd_profile_options

139: FROM fnd_profile_option_values
140: WHERE profile_option_id =
141: (
142: SELECT profile_option_id
143: FROM fnd_profile_options
144: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
145: )
146: AND level_id = '10003'
147: AND profile_option_value = to_char (p_security_profile_id);

Line 155: FROM fnd_profile_options

151: FROM fnd_profile_option_values
152: WHERE profile_option_id =
153: (
154: SELECT profile_option_id
155: FROM fnd_profile_options
156: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
157: )
158: AND level_id = '10004'
159: AND profile_option_value = to_char (p_security_profile_id);

Line 167: FROM fnd_profile_options

163: FROM fnd_profile_option_values
164: WHERE profile_option_id =
165: (
166: SELECT profile_option_id
167: FROM fnd_profile_options
168: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
169: )
170: AND level_id = '10001'
171: AND profile_option_value = to_char (p_security_profile_id);

Line 179: FROM fnd_profile_options

175: FROM fnd_profile_option_values
176: WHERE profile_option_id =
177: (
178: SELECT profile_option_id
179: FROM fnd_profile_options
180: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
181: )
182: AND level_id = '10003'
183: AND profile_option_value = to_char (p_security_profile_id);

Line 191: FROM fnd_profile_options

187: FROM fnd_profile_option_values
188: WHERE profile_option_id =
189: (
190: SELECT profile_option_id
191: FROM fnd_profile_options
192: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
193: )
194: AND level_id = '10001'
195: AND profile_option_value = to_char (p_security_profile_id);

Line 542: FROM fnd_profile_options

538: SET profile_option_value = NULL
539: WHERE profile_option_id =
540: (
541: SELECT profile_option_id
542: FROM fnd_profile_options
543: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
544: )
545: AND profile_option_value = to_char (l_security_profile_id);
546: EXCEPTION

Line 591: FROM fnd_profile_options

587: FROM fnd_profile_option_values
588: WHERE profile_option_id =
589: (
590: SELECT profile_option_id
591: FROM fnd_profile_options
592: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
593: )
594: AND level_id = '10003'
595: AND profile_option_value = to_char (p_security_profile_id);

Line 603: FROM fnd_profile_options

599: FROM fnd_profile_option_values
600: WHERE profile_option_id =
601: (
602: SELECT profile_option_id
603: FROM fnd_profile_options
604: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
605: )
606: AND level_id = '10004'
607: AND profile_option_value = to_char (p_security_profile_id);

Line 615: FROM fnd_profile_options

611: FROM fnd_profile_option_values
612: WHERE profile_option_id =
613: (
614: SELECT profile_option_id
615: FROM fnd_profile_options
616: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
617: )
618: AND level_id = '10001'
619: AND profile_option_value = to_char (p_security_profile_id);

Line 627: FROM fnd_profile_options

623: FROM fnd_profile_option_values
624: WHERE profile_option_id =
625: (
626: SELECT profile_option_id
627: FROM fnd_profile_options
628: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
629: )
630: AND level_id = '10003'
631: AND profile_option_value = to_char (p_security_profile_id);

Line 639: FROM fnd_profile_options

635: FROM fnd_profile_option_values
636: WHERE profile_option_id =
637: (
638: SELECT profile_option_id
639: FROM fnd_profile_options
640: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
641: )
642: AND level_id = '10001'
643: AND profile_option_value = to_char (p_security_profile_id);

Line 819: FROM fnd_profile_options

815: FROM fnd_profile_option_values
816: WHERE profile_option_id =
817: (
818: SELECT profile_option_id
819: FROM fnd_profile_options
820: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
821: )
822: AND level_id = '10003'
823: AND profile_option_value = to_char (p_security_profile_id);

Line 831: FROM fnd_profile_options

827: FROM fnd_profile_option_values
828: WHERE profile_option_id =
829: (
830: SELECT profile_option_id
831: FROM fnd_profile_options
832: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
833: )
834: AND level_id = '10004'
835: AND profile_option_value = to_char (p_security_profile_id);

Line 843: FROM fnd_profile_options

839: FROM fnd_profile_option_values
840: WHERE profile_option_id =
841: (
842: SELECT profile_option_id
843: FROM fnd_profile_options
844: WHERE profile_option_name = 'PER_SECURITY_PROFILE_ID'
845: )
846: AND level_id = '10001'
847: AND profile_option_value = to_char (p_security_profile_id);

Line 855: FROM fnd_profile_options

851: FROM fnd_profile_option_values
852: WHERE profile_option_id =
853: (
854: SELECT profile_option_id
855: FROM fnd_profile_options
856: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
857: )
858: AND level_id = '10003'
859: AND profile_option_value = to_char (p_security_profile_id);

Line 867: FROM fnd_profile_options

863: FROM fnd_profile_option_values
864: WHERE profile_option_id =
865: (
866: SELECT profile_option_id
867: FROM fnd_profile_options
868: WHERE profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'
869: )
870: AND level_id = '10001'
871: AND profile_option_value = to_char (p_security_profile_id);