APPS.OE_AUDIT_HISTORY_PVT dependencies on OE_PC_ATTRIBUTES_V

Line 89: FROM OE_PC_ATTRIBUTES_V

85: SELECT ATTRIBUTE_DISPLAY_NAME,
86: ATTRIBUTE_CODE
87: INTO l_display_name,
88: l_attribute_code
89: FROM OE_PC_ATTRIBUTES_V
90: WHERE ATTRIBUTE_ID = p_attribute_id
91: AND APPLICATION_ID=660;
92: EXCEPTION WHEN OTHERS THEN
93: l_display_name:=NULL;

Line 402: FROM OE_PC_ATTRIBUTES_V OEV

398: SELECT OEV.ATTRIBUTE_ID
399: ,OEV.ATTRIBUTE_CODE
400: ,OEV.COLUMN_NAME
401: ,OEV.ATTRIBUTE_DISPLAY_NAME
402: FROM OE_PC_ATTRIBUTES_V OEV
403: WHERE OEV.ENTITY_ID = ent_id
404: AND OEV.APPLICATION_ID = 660
405: AND OEV.CONSTRAINTS_ENABLED_FLAG = 'Y';
406:

Line 413: FROM OE_PC_ATTRIBUTES_V OEV

409: SELECT OEV.ATTRIBUTE_ID
410: ,OEV.ATTRIBUTE_CODE
411: ,OEV.COLUMN_NAME
412: ,OEV.ATTRIBUTE_DISPLAY_NAME
413: FROM OE_PC_ATTRIBUTES_V OEV
414: WHERE OEV.ENTITY_ID = ent_id
415: AND OEV.APPLICATION_ID = 660
416: AND OEV.CONSTRAINTS_ENABLED_FLAG = 'Y'
417: AND EXISTS ( SELECT 'CONSTRAINT EXISTS FOR THIS COLUMN'

Line 1994: FROM OE_PC_ATTRIBUTES_V

1990: BEGIN
1991: BEGIN
1992: SELECT ATTRIBUTE_DISPLAY_NAME,COLUMN_NAME
1993: INTO p_display_name,p_column_name
1994: FROM OE_PC_ATTRIBUTES_V
1995: WHERE ATTRIBUTE_ID = p_attribute_id;
1996: EXCEPTION WHEN OTHERS THEN
1997: p_display_name:=NULL;
1998: END;