APPS.JL_BR_AR_CANCEL_BORDERO dependencies on JL_BR_AR_COLLECTION_DOCS

Line 73: FROM jl_br_ar_collection_docs

69: CURSOR c3 IS
70: SELECT document_status,
71: payment_schedule_id,
72: document_id
73: FROM jl_br_ar_collection_docs
74: WHERE bordero_id = param_bordero_id
75: AND document_status <> 'CANCELED';
76: CURSOR c4 IS
77: SELECT gl_date,

Line 151: UPDATE jl_br_ar_collection_docs SET

147: );
148:
149: END IF;
150:
151: UPDATE jl_br_ar_collection_docs SET
152: previous_doc_status = var_previous_status,
153: document_status = var_document_status,
154: cancellation_date = var_cancel_date
155: WHERE bordero_id = param_bordero_id