APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_SETTLEMENT_DOCS_ALL_S

Line 1040: UPDATE ozf_settlement_docs_all stlmnt_docs

1036: -- This is because a check can be created and cancelled
1037: -- before canceling the invoice document.
1038: -- Fix for bug 4897546
1039: IF l_claim_rec.payment_method in ( 'CHECK','EFT','WIRE','AP_DEFAULT') THEN
1040: UPDATE ozf_settlement_docs_all stlmnt_docs
1041: SET payment_status = (SELECT SUBSTRB(lkp.displayed_field,1,30)
1042: FROM ap_lookup_codes lkp
1043: where lkp.lookup_type = 'CHECK STATE'
1044: and lkp.lookup_code IN (select status_lookup_code

Line 4890: SELECT ozf_settlement_docs_all_s.NEXTVAL

4886: l_settlement_doc_rec settlement_doc_rec_type := p_settlement_doc_rec;
4887: l_id_count NUMBER;
4888:
4889: CURSOR c_settlement_doc_seq IS
4890: SELECT ozf_settlement_docs_all_s.NEXTVAL
4891: FROM DUAL;
4892:
4893: CURSOR c_id_exists(cv_id IN NUMBER) IS
4894: SELECT COUNT(settlement_doc_id)

Line 5350: UPDATE ozf_settlement_docs_all SET

5346: END;
5347:
5348:
5349: /*
5350: UPDATE ozf_settlement_docs_all SET
5351: object_version_number = l_object_version_number,
5352: last_update_date = SYSDATE,
5353: last_updated_by = l_last_updated_by,
5354: last_update_login = l_last_update_login,