APPS.LNS_LOAN_COLLATERAL_PUB dependencies on LNS_ASSET_ASSIGNMENTS

Line 14: FROM LNS_ASSET_ASSIGNMENTS

10: LAST_UPDATED_BY,
11: LAST_UPDATE_LOGIN ,
12: LAST_UPDATE_DATE ,
13: OBJECT_VERSION_NUMBER
14: FROM LNS_ASSET_ASSIGNMENTS
15: WHERE LOAN_ID = p_loan_id
16: FOR UPDATE ;
17:
18: fee_assignment_rec fee_assignment_cur%ROWTYPE ;

Line 31: 'LNS_ASSET_ASSIGNMENTS');

27: LOOP
28:
29: LNS_LOAN_HISTORY_PUB.log_record_pre(fee_assignment_rec.ASSET_ASSIGNMENT_ID,
30: 'ASSET_ASSIGNMENT_ID',
31: 'LNS_ASSET_ASSIGNMENTS');
32: UPDATE LNS_ASSET_ASSIGNMENTS
33: SET
34: END_DATE_ACTIVE = SYSDATE ,
35: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,

Line 32: UPDATE LNS_ASSET_ASSIGNMENTS

28:
29: LNS_LOAN_HISTORY_PUB.log_record_pre(fee_assignment_rec.ASSET_ASSIGNMENT_ID,
30: 'ASSET_ASSIGNMENT_ID',
31: 'LNS_ASSET_ASSIGNMENTS');
32: UPDATE LNS_ASSET_ASSIGNMENTS
33: SET
34: END_DATE_ACTIVE = SYSDATE ,
35: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
36: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,

Line 44: 'LNS_ASSET_ASSIGNMENTS',p_loan_id);

40:
41:
42: LNS_LOAN_HISTORY_PUB.log_record_post(fee_assignment_rec.ASSET_ASSIGNMENT_ID,
43: 'ASSET_ASSIGNMENT_ID',
44: 'LNS_ASSET_ASSIGNMENTS',p_loan_id);
45:
46: END LOOP ;
47:
48: /*-- update collaterals

Line 49: UPDATE LNS_ASSET_ASSIGNMENTS

45:
46: END LOOP ;
47:
48: /*-- update collaterals
49: UPDATE LNS_ASSET_ASSIGNMENTS
50: SET END_DATE_ACTIVE = SYSDATE,
51: LAST_UPDATED_BY = LNS_UTILITY_PUB.LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN,
53: LAST_UPDATE_DATE = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

Line 87: FROM LNS_ASSET_ASSIGNMENTS

83: ) RETURN VARCHAR2 IS
84:
85: CURSOR C_Is_Exist_Assignment (X_Asset_Id NUMBER) IS
86: SELECT 'X'
87: FROM LNS_ASSET_ASSIGNMENTS
88: WHERE ASSET_ID = X_ASSET_ID
89: AND (END_DATE_ACTIVE IS NULL
90: OR TRUNC(END_DATE_ACTIVE) > TRUNC(SYSDATE));
91: