DBA Data[Home] [Help]

APPS.LNS_LOAN_HEADER_PUB dependencies on AR_CMGT_CREDIT_REQUESTS

Line 822: update ar_cmgt_credit_requests

818: --if the loan description has changed and credit request created
819: --for this loan participants, update the credit request with the
820: --new loan description information to fix bug#4930854
821: 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
822: update ar_cmgt_credit_requests
823: set SOURCE_COLUMN3 = l_loan_header_rec.loan_description
824: where SOURCE_NAME = 'LNS' and
825: SOURCE_COLUMN1 = to_char(l_loan_header_rec.loan_id) and
826: SOURCE_COLUMN3 = l_old_loan_header_rec.loan_description;