APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_ENTITY_HIERARCHIES

Line 114: INSERT INTO AMW_ENTITY_HIERARCHIES(

110: END IF;
111:
112: /* Insert data into entity hierarchies table */
113:
114: INSERT INTO AMW_ENTITY_HIERARCHIES(
115: ENTITY_HIERARCHY_ID,
116: ENTITY_TYPE,
117: ENTITY_ID,
118: CREATED_BY,

Line 128: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,

124: OBJECT_ID,
125: PARENT_OBJECT_TYPE,
126: PARENT_OBJECT_ID,
127: LEVEL_ID)
128: SELECT AMW_ENTITY_HIERARCHIES_S.nextval,
129: ENTITY_TYPE,
130: p_target_entity_id,
131: FND_GLOBAL.USER_ID,
132: SYSDATE,

Line 141: FROM AMW_ENTITY_HIERARCHIES

137: OBJECT_ID,
138: PARENT_OBJECT_TYPE,
139: PARENT_OBJECT_ID,
140: LEVEL_ID
141: FROM AMW_ENTITY_HIERARCHIES
142: WHERE ENTITY_TYPE = 'PROJECT'
143: AND ENTITY_ID = p_source_entity_id;
144:
145: