APPS.HRI_OPL_JOBH dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 73: FROM fnd_id_flex_segments_vl

69: RETURN VARCHAR2 IS
70:
71: CURSOR full_keyflex_csr IS
72: SELECT 'KEY'
73: FROM fnd_id_flex_segments_vl
74: WHERE application_id = 800
75: AND id_flex_code = 'JOB'
76: AND flex_value_set_id = p_value_set_id
77: AND rownum = 1;

Line 194: fnd_id_flex_segments_vl fsg

190: SELECT
191: to_char(fsg.id_flex_num) job_flex_code
192: ,MIN(fsg.application_column_name) flex_column
193: FROM
194: fnd_id_flex_segments_vl fsg
195: WHERE fsg.application_id = 800
196: AND fsg.id_flex_code = 'JOB'
197: AND fsg.flex_value_set_id = v_valueset_id
198: GROUP BY fsg.id_flex_num;