DBA Data[Home] [Help]

APPS.PQH_GEN_FORM dependencies on FND_ID_FLEX_SEGMENTS

Line 1047: from fnd_id_flex_segments

1043: select application_column_name, segment_num, seg_no, rownum from (
1044: select application_column_name,
1045: segment_num,
1046: to_number(substr(application_column_name, instr(upper(application_column_name),'SEGMENT')+7)) seg_no
1047: from fnd_id_flex_segments
1048: where id_flex_code = v_id_fc
1049: and id_flex_num = v_id_fn
1050: and application_id = v_appl_id
1051: and enabled_flag = 'Y'

Line 1209: from fnd_id_flex_segments

1205: cursor c_kf_seg (v_id_fc in varchar2, v_id_fn in varchar2, v_appl_id in number)is
1206: select application_column_name,
1207: segment_num,
1208: to_number(substr(application_column_name, instr(upper(application_column_name),'SEGMENT')+7)) seg_no
1209: from fnd_id_flex_segments
1210: where id_flex_code = v_id_fc
1211: and id_flex_num = v_id_fn
1212: and application_id = v_appl_id
1213: and enabled_flag = 'Y'