232: ) AS
233:
234: cursor c_tag is
235: select tag
236: from fnd_lookup_values
237: where lookup_type = 'HZ_PREFERENCE'
238: and lookup_code = p_preference_code;
239:
240: l_party_preference_id NUMBER;
419: ) AS
420:
421: cursor c_tag is
422: select tag
423: from fnd_lookup_values
424: where lookup_type = 'HZ_PREFERENCE'
425: and lookup_code = p_preference_code;
426:
427: l_rowid ROWID;