APPS.PER_CEI_BUS dependencies on FND_FLEX_VALUE_SETS

Line 2209: -- FND_FLEX_VALUE_SETS_F for records that have a

2205: --
2206: -- Desciption :
2207: --
2208: -- Validate that that the flex_value_set_id exists in the
2209: -- FND_FLEX_VALUE_SETS_F for records that have a
2210: -- flex_value_set_name that begins with 'CAGR_%' and have a
2211: -- validation_type type of 'F'
2212: --
2213: --

Line 2241: FROM fnd_flex_value_sets F

2237: ,p_flex_value_set_id IN per_cagr_entitlement_items.flex_value_set_id%TYPE) IS
2238: --
2239: CURSOR c_chk_id IS
2240: SELECT flex_value_set_id
2241: FROM fnd_flex_value_sets F
2242: WHERE f.flex_value_set_id = p_flex_value_set_id
2243: AND ((f.flex_value_set_name LIKE 'CAGR%') AND
2244: ((f.flex_value_set_name NOT LIKE 'CAGR_BR_%') AND
2245: (f.flex_value_set_name <> 'CAGR_EMPLOYMENT_CATEGORY')))

Line 2301: -- FND_FLEX_VALUE_SETS_F for records that have a

2297: --
2298: -- Desciption :
2299: --
2300: -- Validate that that the beneficial_rule_value_set_id exists in the
2301: -- FND_FLEX_VALUE_SETS_F for records that have a
2302: -- flex_value_set_name that begins with 'CAGR_%' and have a
2303: -- validation_type type of 'F'
2304: --
2305: --

Line 2333: FROM fnd_flex_value_sets F

2329: ,p_ben_rule_value_set_id IN NUMBER) IS
2330: --
2331: CURSOR c_chk_id IS
2332: SELECT flex_value_set_id
2333: FROM fnd_flex_value_sets F
2334: WHERE f.flex_value_set_id = p_ben_rule_value_set_id
2335: AND f.flex_value_set_name like 'CAGR_BR_%'
2336: AND f.validation_type = 'F';
2337: --