APPS.GMD_QC_MIG12 dependencies on FND_PROFILE_OPTION_VALUES

Line 549: FROM fnd_profile_options A, fnd_profile_option_values B

545:
546:
547: CURSOR get_profile IS
548: SELECT profile_option_value
549: FROM fnd_profile_options A, fnd_profile_option_values B
550: WHERE a.profile_option_id = b.profile_option_id
551: AND a.profile_option_name = p_profile_name
552: AND level_id = 10001;
553:

Line 555: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;

551: AND a.profile_option_name = p_profile_name
552: AND level_id = 10001;
553:
554:
555: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;
556:
557: BEGIN
558:
559: OPEN get_profile;

Line 1055: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;

1051: /*=============================
1052: Profile Value Placeholders
1053: =============================*/
1054:
1055: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1056: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1057: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1058: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1059:

Line 1056: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;

1052: Profile Value Placeholders
1053: =============================*/
1054:
1055: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1056: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1057: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1058: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1059:
1060: /*=============================

Line 1057: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;

1053: =============================*/
1054:
1055: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1056: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1057: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1058: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1059:
1060: /*=============================
1061: Exceptions

Line 1058: P_version_control fnd_profile_option_values.profile_option_value%TYPE;

1054:
1055: l_lab_profile fnd_profile_option_values.profile_option_value%TYPE;
1056: P_exact_match fnd_profile_option_values.profile_option_value%TYPE;
1057: P_inc_opt fnd_profile_option_values.profile_option_value%TYPE;
1058: P_version_control fnd_profile_option_values.profile_option_value%TYPE;
1059:
1060: /*=============================
1061: Exceptions
1062: =============================*/