APPS.DELETE_FROM_IREP dependencies on FND_LOOKUP_ASSIGNMENTS

Line 57: Delete from FND_LOOKUP_ASSIGNMENTS

53: (select class_name
54: from fnd_irep_classes
55: where class_id = key_id);
56:
57: Delete from FND_LOOKUP_ASSIGNMENTS
58: where obj_name = 'FND_IREP_CLASSES'
59: and INSTANCE_PK1_VALUE = to_char(key_id);
60:
61: Delete from FND_CHILD_ANNOTATIONS

Line 76: Delete from FND_LOOKUP_ASSIGNMENTS

72: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'DeleteFromIrep', 'Class Sub-Entities Removed');
73: end if;
74:
75: -- remove method subentities
76: Delete from FND_LOOKUP_ASSIGNMENTS
77: where obj_name = 'FND_IREP_FUNCTION_FLAVORS'
78: and INSTANCE_PK1_VALUE in
79: (select function_id
80: from FND_FORM_FUNCTIONS

Line 201: Delete from FND_LOOKUP_ASSIGNMENTS

197: -- remove object subentities
198: Delete from FND_OBJECT_KEY_SETS
199: where object_id = key_id;
200:
201: Delete from FND_LOOKUP_ASSIGNMENTS
202: where obj_name = 'FND_OBJECTS'
203: and INSTANCE_PK1_VALUE = to_char(key_id);
204:
205: Delete from FND_CHILD_ANNOTATIONS