DBA Data[Home] [Help]

APPS.LNS_LOAN_HEADER_PUB dependencies on AR_CMGT_CREDIT_REQUESTS

Line 832: update ar_cmgt_credit_requests

828: --if the loan description has changed and credit request created
829: --for this loan participants, update the credit request with the
830: --new loan description information to fix bug#4930854
831: IF (l_old_loan_header_rec.credit_review_flag = 'Y' and l_loan_header_rec.loan_description is not null and l_loan_header_rec.loan_description <> FND_API.G_MISS_CHAR and l_loan_header_rec.loan_description <> l_old_loan_header_rec.loan_description) THEN
832: update ar_cmgt_credit_requests
833: set SOURCE_COLUMN3 = l_loan_header_rec.loan_description
834: where SOURCE_NAME = 'LNS' and
835: SOURCE_COLUMN1 = to_char(l_loan_header_rec.loan_id) and
836: SOURCE_COLUMN3 = l_old_loan_header_rec.loan_description;