APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_PC_CONSTRAINTS

Line 319: FROM OE_PC_CONSTRAINTS OEP

315: WHERE OEV.ENTITY_ID = ent_id
316: AND OEV.APPLICATION_ID = 660
317: AND OEV.CONSTRAINTS_ENABLED_FLAG = 'Y'
318: AND EXISTS ( SELECT 'CONSTRAINT EXISTS FOR THIS COLUMN'
319: FROM OE_PC_CONSTRAINTS OEP
320: WHERE OEP.COLUMN_NAME = OEV.COLUMN_NAME
321: AND OEP.ON_OPERATION_ACTION IN (1,2)
322: AND OEP.ENTITY_ID = OEV.ENTITY_ID)
323: ORDER BY OEV.ATTRIBUTE_ID;

Line 329: FROM OE_PC_CONSTRAINTS

325:
326: /* Check Whether the entity is constrained for update */
327: CURSOR IS_ENTITY_CONSTRAINED (v_ent_id NUMBER) IS
328: SELECT 'Y' -- There is an entity level constraint'
329: FROM OE_PC_CONSTRAINTS
330: WHERE ENTITY_ID = v_ent_id
331: AND COLUMN_NAME IS NULL
332: AND ON_OPERATION_ACTION IN (1,2)
333: AND CONSTRAINED_OPERATION <> 'X';