APPS.GMD_NPD_MIGRATE dependencies on FND_PROFILE

Line 32: FROM Fnd_Profile_Options a, Fnd_Profile_Option_Values b

28: /* ------------------ CURSORS ---------------------- */
29: -- Get Site level profile values
30: CURSOR Cur_get_profile_value IS
31: SELECT PROFILE_OPTION_VALUE
32: FROM Fnd_Profile_Options a, Fnd_Profile_Option_Values b
33: WHERE a.Profile_Option_Id = b.Profile_Option_Id
34: AND a.Profile_Option_Name = P_Profile_Name
35: AND level_id = 10001;
36:

Line 1214: l_profile_value := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');

1210: p_app_short_name => 'GMD');
1211:
1212: --Now update the lab_organization_id wih the organization_id value fetched
1213: --from the gemms_default_lab_type profile.
1214: l_profile_value := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');
1215: IF l_profile_value IS NOT NULL THEN
1216: OPEN Cur_get_orgn(l_profile_value);
1217: FETCH Cur_get_orgn INTO l_organization_id;
1218: CLOSE Cur_get_orgn;