APPS.JL_BR_AR_CANCEL_BORDERO dependencies on JL_BR_AR_COLLECTION_DOCS

Line 74: FROM jl_br_ar_collection_docs

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

Line 153: UPDATE jl_br_ar_collection_docs SET

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