APPS.IES_META_OBJ_PKG dependencies on IES_META_PROPERTIES

Line 101: IES_META_PROPERTIES D

97: select count(B.PROPVAL_ID)
98: into propValCount
99: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
100: IES_META_PROPERTY_VALUES C,
101: IES_META_PROPERTIES D
102: where A.OBJECT_UID = X_OBJECT_UID
103: and A.OBJECT_ID = B.OBJECT_ID
104: and C.PROPERTY_ID = D.PROPERTY_ID
105: and b.PROPVAL_ID = C.PROPVAL_ID

Line 118: from IES_META_PROPERTIES

114: begin
115: deleteStmt := 'delete from IES_META_PROPERTY_VALUES
116: where propval_id = :1
117: and property_id IN (select property_id
118: from IES_META_PROPERTIES
119: where NAME = :2)';
120: execute immediate deleteStmt using x_propval_id, x_prop_name;
121: end;
122:

Line 134: IES_META_PROPERTIES D

130: OPEN propval FOR
131: 'select B.PROPVAL_ID
132: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
133: IES_META_PROPERTY_VALUES C,
134: IES_META_PROPERTIES D
135: where A.OBJECT_UID = :1
136: and A.OBJECT_ID = B.OBJECT_ID
137: and C.PROPERTY_ID = D.PROPERTY_ID
138: and b.PROPVAL_ID = C.PROPVAL_ID

Line 354: IES_META_PROPERTIES D

350: select B.PROPVAL_ID
351: into propValId
352: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
353: IES_META_PROPERTY_VALUES C,
354: IES_META_PROPERTIES D
355: where A.OBJECT_UID = X_OBJECT_UID
356: and A.OBJECT_ID = B.OBJECT_ID
357: and C.PROPERTY_ID = D.PROPERTY_ID
358: and b.PROPVAL_ID = C.PROPVAL_ID

Line 392: IES_META_PROPERTIES B

388: begin
389: select A.PROPERTY_ID
390: into propid
391: from IES_META_OBJ_TYPE_PROPERTIES A,
392: IES_META_PROPERTIES B
393: where A.PROPERTY_ID = B.PROPERTY_ID
394: and B.NAME = X_PROP_NAME
395: and A.OBJTYPE_ID IN (select TYPE_ID
396: from IES_META_OBJECT_TYPES

Line 534: IES_META_PROPERTIES D

530: CURSOR propvals_curs IS
531: select b.last_updated_by, b.last_update_date
532: from IES_META_OBJECTS A, IES_META_OBJECT_PROPVALS B,
533: IES_META_PROPERTY_VALUES C,
534: IES_META_PROPERTIES D
535: where A.OBJECT_UID = X_OBJECT_UID
536: and A.OBJECT_ID = B.OBJECT_ID
537: and C.PROPERTY_ID = D.PROPERTY_ID
538: and b.PROPVAL_ID = C.PROPVAL_ID