APPS.PER_DELETE_UNWANTED_SEC_PROF dependencies on FND_PROFILE_OPTION_VALUES

Line 139: FROM fnd_profile_option_values

135: ,hr_general.end_of_time);
136: CURSOR c_sec_profile
137: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
138: SELECT level_value
139: FROM fnd_profile_option_values
140: WHERE profile_option_id =
141: (
142: SELECT profile_option_id
143: FROM fnd_profile_options

Line 151: FROM fnd_profile_option_values

147: AND profile_option_value = to_char (p_security_profile_id);
148: CURSOR c_sec_usr_profile
149: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
150: SELECT level_value
151: FROM fnd_profile_option_values
152: WHERE profile_option_id =
153: (
154: SELECT profile_option_id
155: FROM fnd_profile_options

Line 163: FROM fnd_profile_option_values

159: AND profile_option_value = to_char (p_security_profile_id);
160: CURSOR c_sec_profile_site
161: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
162: SELECT 'Y'
163: FROM fnd_profile_option_values
164: WHERE profile_option_id =
165: (
166: SELECT profile_option_id
167: FROM fnd_profile_options

Line 175: FROM fnd_profile_option_values

171: AND profile_option_value = to_char (p_security_profile_id);
172: CURSOR c_mo_profile
173: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
174: SELECT level_value
175: FROM fnd_profile_option_values
176: WHERE profile_option_id =
177: (
178: SELECT profile_option_id
179: FROM fnd_profile_options

Line 187: FROM fnd_profile_option_values

183: AND profile_option_value = to_char (p_security_profile_id);
184: CURSOR c_mo_profile_site
185: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
186: SELECT 'Y'
187: FROM fnd_profile_option_values
188: WHERE profile_option_id =
189: (
190: SELECT profile_option_id
191: FROM fnd_profile_options

Line 537: UPDATE fnd_profile_option_values

533: hr_utility.set_location (l_proc
534: ,110);
535:
536: BEGIN
537: UPDATE fnd_profile_option_values
538: SET profile_option_value = NULL
539: WHERE profile_option_id =
540: (
541: SELECT profile_option_id

Line 587: FROM fnd_profile_option_values

583: ,hr_general.end_of_time);
584: CURSOR c_sec_profile
585: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
586: SELECT level_value
587: FROM fnd_profile_option_values
588: WHERE profile_option_id =
589: (
590: SELECT profile_option_id
591: FROM fnd_profile_options

Line 599: FROM fnd_profile_option_values

595: AND profile_option_value = to_char (p_security_profile_id);
596: CURSOR c_sec_usr_profile
597: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
598: SELECT level_value
599: FROM fnd_profile_option_values
600: WHERE profile_option_id =
601: (
602: SELECT profile_option_id
603: FROM fnd_profile_options

Line 611: FROM fnd_profile_option_values

607: AND profile_option_value = to_char (p_security_profile_id);
608: CURSOR c_sec_profile_site
609: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
610: SELECT 'Y'
611: FROM fnd_profile_option_values
612: WHERE profile_option_id =
613: (
614: SELECT profile_option_id
615: FROM fnd_profile_options

Line 623: FROM fnd_profile_option_values

619: AND profile_option_value = to_char (p_security_profile_id);
620: CURSOR c_mo_profile
621: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
622: SELECT level_value
623: FROM fnd_profile_option_values
624: WHERE profile_option_id =
625: (
626: SELECT profile_option_id
627: FROM fnd_profile_options

Line 635: FROM fnd_profile_option_values

631: AND profile_option_value = to_char (p_security_profile_id);
632: CURSOR c_mo_profile_site
633: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
634: SELECT 'Y'
635: FROM fnd_profile_option_values
636: WHERE profile_option_id =
637: (
638: SELECT profile_option_id
639: FROM fnd_profile_options

Line 815: FROM fnd_profile_option_values

811: ,hr_general.end_of_time);
812: CURSOR c_sec_profile
813: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
814: SELECT level_value
815: FROM fnd_profile_option_values
816: WHERE profile_option_id =
817: (
818: SELECT profile_option_id
819: FROM fnd_profile_options

Line 827: FROM fnd_profile_option_values

823: AND profile_option_value = to_char (p_security_profile_id);
824: CURSOR c_sec_usr_profile
825: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
826: SELECT level_value
827: FROM fnd_profile_option_values
828: WHERE profile_option_id =
829: (
830: SELECT profile_option_id
831: FROM fnd_profile_options

Line 839: FROM fnd_profile_option_values

835: AND profile_option_value = to_char (p_security_profile_id);
836: CURSOR c_sec_profile_site
837: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
838: SELECT 'Y'
839: FROM fnd_profile_option_values
840: WHERE profile_option_id =
841: (
842: SELECT profile_option_id
843: FROM fnd_profile_options

Line 851: FROM fnd_profile_option_values

847: AND profile_option_value = to_char (p_security_profile_id);
848: CURSOR c_mo_profile
849: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
850: SELECT level_value
851: FROM fnd_profile_option_values
852: WHERE profile_option_id =
853: (
854: SELECT profile_option_id
855: FROM fnd_profile_options

Line 863: FROM fnd_profile_option_values

859: AND profile_option_value = to_char (p_security_profile_id);
860: CURSOR c_mo_profile_site
861: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
862: SELECT 'Y'
863: FROM fnd_profile_option_values
864: WHERE profile_option_id =
865: (
866: SELECT profile_option_id
867: FROM fnd_profile_options