APPS.LNS_MERGE_PKG dependencies on LNS_LOAN_HEADERS_ALL

Line 141: UPDATE LNS_LOAN_HEADERS_ALL

137: If a duplicate exists then do not transfer and return the id of the duplicate record as the Merged To Id.
138: */
139:
140: /* updating PRIMARY_BORROWER_ID column */
141: UPDATE LNS_LOAN_HEADERS_ALL
142: SET PRIMARY_BORROWER_ID = p_To_FK_id,
143: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
144: last_updated_by = HZ_UTILITY_V2PUB.user_id,
145: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 151: UPDATE LNS_LOAN_HEADERS_ALL

147: program_id = HZ_UTILITY_V2PUB.program_id
148: WHERE PRIMARY_BORROWER_ID = p_from_fk_id;
149:
150: /* updating CONTACT_PERS_PARTY_ID column */
151: UPDATE LNS_LOAN_HEADERS_ALL
152: SET CONTACT_PERS_PARTY_ID = p_To_FK_id,
153: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
154: last_updated_by = HZ_UTILITY_V2PUB.user_id,
155: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 161: UPDATE LNS_LOAN_HEADERS_ALL

157: program_id = HZ_UTILITY_V2PUB.program_id
158: WHERE CONTACT_PERS_PARTY_ID = p_from_fk_id;
159:
160: /* updating CONTACT_REL_PARTY_ID column */
161: UPDATE LNS_LOAN_HEADERS_ALL
162: SET CONTACT_REL_PARTY_ID = p_To_FK_id,
163: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
164: last_updated_by = HZ_UTILITY_V2PUB.user_id,
165: last_update_login = HZ_UTILITY_V2PUB.last_update_login,