[Home] [Help]
3061:
3062: FUNCTION costflex_value (
3063: p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE,
3064: p_segment_name IN fnd_id_flex_segments.application_column_name%TYPE,
3065: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE
3066: DEFAULT g_independant,
3067: p_flex_value_id IN hxc_time_attributes.attribute1%TYPE
3068: )
3069: RETURN fnd_flex_values.flex_value%TYPE
3072:
3073: CURSOR csr_flex_value (
3074: p_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE,
3075: p_segment_name fnd_id_flex_segments.application_column_name%TYPE,
3076: p_validation_type fnd_flex_value_sets.validation_type%TYPE,
3077: p_flex_value_id fnd_flex_values.flex_value_id%TYPE
3078: )
3079: IS
3080: SELECT ffv.flex_value
3078: )
3079: IS
3080: SELECT ffv.flex_value
3081: FROM fnd_id_flex_segments fifs,
3082: fnd_flex_value_sets ffvs,
3083: fnd_flex_values ffv
3084: WHERE fifs.application_id = g_pay_app_id
3085: AND fifs.id_flex_code = g_cost_flex_code
3086: AND fifs.id_flex_num = p_id_flex_num