APPS.LNS_LOAN_HEADER_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 103: FROM LNS_LOAN_HEADERS_ALL

99: THEN
100: BEGIN
101: SELECT 'Y'
102: INTO l_dummy
103: FROM LNS_LOAN_HEADERS_ALL
104: WHERE loan_id = l_loan_id;
105:
106: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
107: FND_MESSAGE.SET_TOKEN('COLUMN', 'loan_id');

Line 138: FROM LNS_LOAN_HEADERS_ALL

134:
135: BEGIN
136: SELECT 'Y'
137: INTO l_dummy
138: FROM LNS_LOAN_HEADERS_ALL
139: WHERE LOAN_NUMBER = l_loan_number;
140:
141: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
142: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOAN_NUMBER');

Line 408: FROM LNS_LOAN_HEADERS_ALL

404: SELECT OBJECT_VERSION_NUMBER,
405: ROWID
406: INTO l_object_version_number,
407: l_rowid
408: FROM LNS_LOAN_HEADERS_ALL
409: WHERE LOAN_ID = p_loan_header_rec.loan_id
410: FOR UPDATE OF LOAN_ID NOWAIT;
411:
412: IF NOT