APPS.LNS_MERGE_PKG dependencies on LNS_LOAN_HEADERS_ALL

Line 38: UPDATE LNS_LOAN_HEADERS_ALL

34: If a duplicate exists then do not transfer and return the id of the duplicate record as the Merged To Id.
35: */
36:
37: /* updating PRIMARY_BORROWER_ID column */
38: UPDATE LNS_LOAN_HEADERS_ALL
39: SET PRIMARY_BORROWER_ID = p_To_FK_id,
40: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
41: last_updated_by = HZ_UTILITY_V2PUB.user_id,
42: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 48: UPDATE LNS_LOAN_HEADERS_ALL

44: program_id = HZ_UTILITY_V2PUB.program_id
45: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
46:
47: /* updating CONTACT_PERS_PARTY_ID column */
48: UPDATE LNS_LOAN_HEADERS_ALL
49: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
50: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
51: last_updated_by = HZ_UTILITY_V2PUB.user_id,
52: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 58: UPDATE LNS_LOAN_HEADERS_ALL

54: program_id = HZ_UTILITY_V2PUB.program_id
55: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
56:
57: /* updating CONTACT_REL_PARTY_ID column */
58: UPDATE LNS_LOAN_HEADERS_ALL
59: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
60: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
61: last_updated_by = HZ_UTILITY_V2PUB.user_id,
62: last_update_login = HZ_UTILITY_V2PUB.last_update_login,