DBA Data[Home] [Help]

APPS.JL_BR_AR_CANCEL_BORDERO dependencies on JL_BR_AR_OCCURRENCE_DOCS

Line 85: FROM jl_br_ar_occurrence_docs

81: flag_post_gl,
82: bank_occurrence_type, -- SLA Uptake - Bug#4301543
83: bank_occurrence_code, -- SLA Uptake - Bug#4301543
84: event_id -- bug 10349927
85: FROM jl_br_ar_occurrence_docs
86: WHERE document_id = var_document_id
87: AND bank_occurrence_type = 'REMITTANCE_OCCURRENCE'
88: AND occurrence_status <> 'CANCELED';
89: BEGIN

Line 224: UPDATE jl_br_ar_occurrence_docs SET

220: );
221: END IF; -- bug 10349927
222: -- End SLA Uptake - Bug#4301543
223:
224: UPDATE jl_br_ar_occurrence_docs SET
225: occurrence_status= 'CANCELED',
226: gl_date = var_gl_date,
227: gl_cancel_date = var_gl_date_cancel,
228: flag_post_gl = var_flag_post_gl,