APPS.LNS_LOAN_COLLATERAL_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

  SELECT ASSET_ASSIGNMENT_ID,
         END_DATE_ACTIVE,
      	 LAST_UPDATED_BY,
     	 LAST_UPDATE_LOGIN ,
    	 LAST_UPDATE_DATE ,
     	 OBJECT_VERSION_NUMBER
  FROM  LNS_ASSET_ASSIGNMENTS
  WHERE LOAN_ID = p_loan_id
  FOR UPDATE ;

Line: 32

       UPDATE LNS_ASSET_ASSIGNMENTS
       SET
       END_DATE_ACTIVE = SYSDATE ,
	   LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
	   LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
	   OBJECT_VERSION_NUMBER = fee_assignment_rec.OBJECT_VERSION_NUMBER + 1
       WHERE current of fee_assignment_cur ;

Line: 48

    /*-- update collaterals
	UPDATE LNS_ASSET_ASSIGNMENTS
	SET END_DATE_ACTIVE = SYSDATE,
	LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
	LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
	OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
	WHERE LOAN_ID = p_loan_id; */

Line: 60

	UPDATE LNS_ASSETS
	SET END_DATE_ACTIVE = SYSDATE,
	LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
	LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
	OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
	WHERE ACQUIRED_ASSET_LOAN_ID = p_loan_id; */

Line: 86

  SELECT 'X'
  FROM LNS_ASSET_ASSIGNMENTS
  WHERE ASSET_ID = X_ASSET_ID
  AND (END_DATE_ACTIVE IS NULL
  OR TRUNC(END_DATE_ACTIVE) > TRUNC(SYSDATE));