DBA Data[Home] [Help]

APPS.AME_DYNAMIC_APPROVAL_PKG dependencies on FND_LOOKUPS

Line 215: from fnd_lookups

211: p_order_type IN varchar2
212: )
213: IS
214: select description
215: from fnd_lookups
216: where lookup_type like 'AME_DA_ACTIVE_ORDER_TYPE' and lookup_code = p_order_type;
217:
218:
219: CURSOR c_order_type_name (

Line 224: from fnd_lookups

220: p_order_type IN varchar2
221: )
222: IS
223: select meaning
224: from fnd_lookups
225: where lookup_type like 'AME_APPR_INSERTION_ORDER_TYPE' and lookup_code = p_order_type;
226:
227: CURSOR c_apr_status (
228: p_status IN varchar2

Line 232: from fnd_lookups

228: p_status IN varchar2
229: )
230: IS
231: select meaning
232: from fnd_lookups
233: where lookup_type like 'AME_APPROVAL_STATUS' and lookup_code = p_status;
234:
235: CURSOR c_apr_category (
236: p_category IN varchar2

Line 240: from fnd_lookups

236: p_category IN varchar2
237: )
238: IS
239: select meaning
240: from fnd_lookups
241: where lookup_type like 'AME_APPROVER_CATEGORY' and lookup_code = p_category;
242:
243:
244: l_default_approvers_list ame_approver_record2_table_ss := ame_approver_record2_table_ss();