APPS.PV_ENTY_ATTR_VALUE_PUB dependencies on PV_ENTITY_ATTRS

Line 109: FROM PV_ENTITY_ATTRS

105: ;
106:
107: CURSOR c_get_attr_enty_details (pc_attribute_id IN NUMBER, pc_entity IN VARCHAR2) IS
108: SELECT external_update_text, attr_data_type, require_validation_flag, lov_string
109: FROM PV_ENTITY_ATTRS
110: WHERE attribute_id = pc_attribute_id AND
111: entity= pc_entity
112: ;
113:

Line 1379: FROM PV_ATTRIBUTES_VL ATTR, PV_ENTITY_ATTRS ENTY, PV_ENTY_ATTR_VALUES VAL

1375: lc_ext_cursor cur_type;
1376:
1377: CURSOR c_attr_data_type(cv_attribute_id NUMBER, cv_entity_id NUMBER) IS
1378: SELECT distinct enty.attr_data_type, ENTY.SQL_TEXT -- VAL.version,
1379: FROM PV_ATTRIBUTES_VL ATTR, PV_ENTITY_ATTRS ENTY, PV_ENTY_ATTR_VALUES VAL
1380: WHERE ATTR.attribute_id = cv_attribute_id AND
1381: ENTY.ATTRIBUTE_ID = ATTR.attribute_id AND
1382: ENTY.ENTITY = 'PARTNER' AND
1383: VAL.ATTRIBUTE_ID (+) = ENTY.ATTRIBUTE_ID AND