APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on IRC_DOCUMENTS

Line 416: from irc_documents doc

412: l_query_str varchar2(3000):=
413: 'select document_id from (
414: select document_id, person_id, rank () over
415: (partition by person_id order by last_update_date desc) rank
416: from irc_documents doc
417: where type in (:p_resume,:p_auto_resume)
418: and (doc.end_Date is null or doc.end_Date > sysdate)
419: and person_id in ('||p_person_ids||'))
420: where rank = :p_rank';

Line 474: from irc_documents

470: p_document_id varchar2(100);
471: cursor csr_doc is select binary_doc,
472: mime_type,
473: file_name
474: from irc_documents
475: where document_id = p_document_id;
476: begin
477: p_document_id := document_id;
478: open csr_doc;