[Home] [Help]
2422: CURSOR c_group_name_check (p_group_name VARCHAR2)
2423: IS
2424: SELECT 1
2425: FROM fnd_id_flex_structures b ,
2426: fnd_id_flex_structures_tl t
2427: WHERE b.id_flex_num = t.id_flex_num
2428: AND b.id_flex_code = 'GRP'
2429: AND t.language = 'US'
2430: AND t.id_flex_structure_name = p_group_name;
2432: IS
2433: SELECT application_column_name,
2434: b.id_flex_num
2435: FROM fnd_id_flex_structures b ,
2436: fnd_id_flex_structures_tl t ,
2437: fnd_id_flex_segments c
2438: WHERE b.id_flex_code = 'GRP'
2439: AND t.language = 'US'
2440: AND t.id_flex_num = b.id_flex_num