[Home] [Help]
574: BEGIN
575: SELECT nvl(doc.document_amount,0)
576: INTO X_document_amount
577: FROM jl_br_ar_bank_occurrences ban,
578: jl_br_ar_occurrence_docs_all doc,
579: jl_br_ar_collection_docs cob
580: WHERE ban.std_occurrence_code = 'REMITTANCE'
581: AND ban.bank_occurrence_type = 'REMITTANCE_OCCURRENCE'
582: --AND ban.bank_number = X_bank_number