153:
154: BEGIN
155: SELECT application_column_name
156: INTO l_agreement_num_col
157: FROM fnd_descr_flex_col_usage_vl
158: WHERE application_id = l_app_id
159: AND form_left_prompt = 'Agreement Number'
160: AND descriptive_flexfield_name = l_dff;
161: EXCEPTION
170:
171: BEGIN
172: SELECT application_column_name
173: INTO l_start_date_col
174: FROM fnd_descr_flex_col_usage_vl
175: WHERE application_id = l_app_id
176: AND form_left_prompt = 'Start Date'
177: AND descriptive_flexfield_name = l_dff;
178: EXCEPTION
187: BEGIN
188:
189: SELECT application_column_name
190: INTO l_end_date_col
191: FROM fnd_descr_flex_col_usage_vl
192: WHERE application_id = l_app_id
193: AND form_left_prompt = 'End Date'
194: AND descriptive_flexfield_name = l_dff;
195: EXCEPTION