DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on AP_LOOKUP_CODES

Line 1042: FROM ap_lookup_codes lkp

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
1045: FROM ap_invoice_payments pay, ap_checks chk
1046: WHERE pay.check_id = chk.check_id