APPS.EC_APPLICATION_ADVICE_PUB dependencies on ECE_ADVO_HEADERS

Line 100: select ece_advo_headers_s.nextval

96:
97: p_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99:
100: select ece_advo_headers_s.nextval
101: into p_advice_header_id
102: from dual;
103:
104: /*

Line 128: insert into ECE_ADVO_HEADERS (

124: */
125:
126:
127:
128: insert into ECE_ADVO_HEADERS (
129: communication_method,
130: ADVICE_HEADER_ID,
131: DOCUMENT_TYPE,
132: DOCUMENT_CODE,

Line 332: from ece_advo_headers

328:
329: begin -- Bug 2593437
330: select 'Y'
331: into l_document_exists
332: from ece_advo_headers
333: where advice_header_id=p_advice_header_id;
334: exception
335: when others then
336: null;