[Home] [Help]
74: P_CAT_WHERE Varchar2(2000) := '';
75:
76: cursor c1(flex_code in VARCHAR2, flex_structure_code in VARCHAR2) is
77: SELECT fifst.id_flex_num
78: FROM fnd_id_flex_structures fifst
79: WHERE fifst.application_id = 401
80: AND fifst.id_flex_code = flex_code
81: AND fifst.id_flex_structure_code = flex_structure_code
82: AND fifst.enabled_flag = 'Y'