APPS.CS_CF_UPG_UTL_PKG dependencies on FND_PROFILE_OPTIONS

Line 10: FROM fnd_profile_options a, fnd_profile_option_values b

6: b.level_id,
7: b.level_value,
8: b.level_value_application_id,
9: b.profile_option_value
10: FROM fnd_profile_options a, fnd_profile_option_values b
11: where a.profile_option_name = p_profile_option_name
12: and a.profile_option_id = b.profile_option_id
13: and a.application_id = b.application_id
14: order by b.level_id;

Line 19: FROM fnd_profile_options a

15:
16:
17: CURSOR get_profile_option_count (p_profile_option_name VARCHAR2)
18: IS SELECT count(*)
19: FROM fnd_profile_options a
20: WHERE a.profile_option_name in (p_profile_option_name);
21:
22:
23:

Line 2383: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

2379: p_mandatoryIncidentAddr IN OUT NOCOPY VARCHAR2)
2380: IS
2381: l_count NUMBER := p_ProfileTable.COUNT;
2382: l_index NUMBER := 0;
2383: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
2384:
2385: l_examineBillToAddress BOOLEAN := TRUE;
2386: l_examineBillToContact BOOLEAN := TRUE;
2387: l_examineShipToAddress BOOLEAN := TRUE;

Line 2442: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;

2438: p_mandatoryProblemCode IN OUT NOCOPY VARCHAR2)
2439: IS
2440: l_count NUMBER := p_ProfileTable.COUNT;
2441: l_index NUMBER := 0;
2442: l_profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE;
2443:
2444: l_examineAttachment BOOLEAN := TRUE;
2445: l_examineProbCode BOOLEAN := TRUE;
2446:

Line 2623: FROM fnd_profile_options a, fnd_profile_option_values b

2619: FUNCTION configProfileCustomized RETURN BOOLEAN IS
2620:
2621: CURSOR l_cur IS
2622: SELECT b.last_updated_by
2623: FROM fnd_profile_options a, fnd_profile_option_values b
2624: WHERE a.profile_option_id = b.profile_option_id
2625: AND a.profile_option_name = 'IBU_REGION_FIELD_CONFIG_OPTION'
2626: AND B.LEVEL_ID = 10001
2627: AND A.APPLICATION_ID = 672