APPS.IBY_PAYMENT_DOC_PUB_PKG dependencies on CE_PAYMENT_DOCUMENTS

Line 123: from ce_payment_documents

119: into l_pmt_instruction_id,
120: l_first_avail_num,
121: l_last_avail_num,
122: l_last_issued_num
123: from ce_payment_documents
124: where payment_document_id = p_payment_document_id;
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN
127:

Line 288: UPDATE ce_payment_documents

284: IF (p_from_doc_num <= p_to_doc_num AND p_to_doc_num>l_last_issued_num) THEN
285:
286: print_debuginfo(l_module_name, 'Last Issued Number is less than Range. Updating last_issued_document_number',G_LEVEL_STATEMENT);
287:
288: UPDATE ce_payment_documents
289: set last_issued_document_number = p_to_doc_num
290: where payment_document_id = p_payment_document_id;
291:
292: END IF;