APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on FND_FLEX_VALUE_SETS

Line 3891: FROM fnd_flex_value_sets

3887: --
3888: CURSOR c_value_set_name (cv_flex_value_set_id NUMBER)
3889: IS
3890: SELECT flex_value_set_name
3891: FROM fnd_flex_value_sets
3892: WHERE flex_value_set_id = cv_flex_value_set_id;
3893: --
3894: l_out_egl_result_id NUMBER (15);
3895: l_egl_table_route_id NUMBER (15);

Line 3900: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

3896: l_egl_result_type_cd VARCHAR2 (30);
3897:
3898: l_egl_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
3899: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
3900: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3901: --
3902: ---------------------------------------------------------------
3903: ------------------ END OF BEN_ELIGY_CRITERIA ------------------
3904: ---------------------------------------------------------------

Line 13940: FROM fnd_flex_value_sets

13936: --
13937: CURSOR c_value_set_name (cv_flex_value_set_id NUMBER)
13938: IS
13939: SELECT flex_value_set_name
13940: FROM fnd_flex_value_sets
13941: WHERE flex_value_set_id = cv_flex_value_set_id;
13942: --
13943: l_out_egl_result_id NUMBER (15);
13944: l_egl_table_route_id NUMBER (15);

Line 13949: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;

13945: l_egl_result_type_cd VARCHAR2 (30);
13946: l_eligy_criteria_id NUMBER (15);
13947: l_egl_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
13948: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
13949: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
13950: --
13951: cursor c_object_exists(c_pk_id number,
13952: c_table_alias varchar2) is
13953: select null