APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_PC_ATTRIBUTES_V

Line 22: FROM OE_PC_ATTRIBUTES_V

18: SELECT ATTRIBUTE_DISPLAY_NAME,
19: ATTRIBUTE_CODE
20: INTO l_display_name,
21: l_attribute_code
22: FROM OE_PC_ATTRIBUTES_V
23: WHERE ATTRIBUTE_ID = p_attribute_id
24: AND APPLICATION_ID=660;
25: EXCEPTION WHEN OTHERS THEN
26: l_display_name:=NULL;

Line 303: FROM OE_PC_ATTRIBUTES_V OEV

299: SELECT OEV.ATTRIBUTE_ID
300: ,OEV.ATTRIBUTE_CODE
301: ,OEV.COLUMN_NAME
302: ,OEV.ATTRIBUTE_DISPLAY_NAME
303: FROM OE_PC_ATTRIBUTES_V OEV
304: WHERE OEV.ENTITY_ID = ent_id
305: AND OEV.APPLICATION_ID = 660
306: AND OEV.CONSTRAINTS_ENABLED_FLAG = 'Y';
307:

Line 314: FROM OE_PC_ATTRIBUTES_V OEV

310: SELECT OEV.ATTRIBUTE_ID
311: ,OEV.ATTRIBUTE_CODE
312: ,OEV.COLUMN_NAME
313: ,OEV.ATTRIBUTE_DISPLAY_NAME
314: FROM OE_PC_ATTRIBUTES_V OEV
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'

Line 1623: FROM OE_PC_ATTRIBUTES_V

1619: BEGIN
1620: BEGIN
1621: SELECT ATTRIBUTE_DISPLAY_NAME,COLUMN_NAME
1622: INTO p_display_name,p_column_name
1623: FROM OE_PC_ATTRIBUTES_V
1624: WHERE ATTRIBUTE_ID = p_attribute_id;
1625: EXCEPTION WHEN OTHERS THEN
1626: p_display_name:=NULL;
1627: END;