APPS.GMD_QC_MIG12 dependencies on FND_PROFILE_OPTION_VALUES

Line 541: FROM fnd_profile_options A, fnd_profile_option_values B

537:
538:
539: CURSOR get_profile IS
540: SELECT profile_option_value
541: FROM fnd_profile_options A, fnd_profile_option_values B
542: WHERE a.profile_option_id = b.profile_option_id
543: AND a.profile_option_name = p_profile_name
544: AND level_id = 10001;
545:

Line 547: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;

543: AND a.profile_option_name = p_profile_name
544: AND level_id = 10001;
545:
546:
547: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;
548:
549: BEGIN
550:
551: OPEN get_profile;

Line 1047: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;

1043: /*=============================
1044: Profile Value Placeholders
1045: =============================*/
1046:
1047: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1048: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1049: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1050: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1051:

Line 1048: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;

1044: Profile Value Placeholders
1045: =============================*/
1046:
1047: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1048: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1049: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1050: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1051:
1052: /*=============================

Line 1049: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;

1045: =============================*/
1046:
1047: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1048: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1049: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1050: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1051:
1052: /*=============================
1053: Exceptions

Line 1050: P_version_control fnd_profile_option_values.profile_option_value%TYPE;

1046:
1047: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1048: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1049: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1050: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1051:
1052: /*=============================
1053: Exceptions
1054: =============================*/