DBA Data[Home] [Help]

APPS.FA_VENDORMERGE_GRP dependencies on FA_LEASE_PAYMENT_ITEMS

Line 200: -- Updating FA_LEASE_PAYMENT_ITEMS: LESSOR_ID, LESSOR_SITE_ID

196: where LESSOR_ID = p_dup_vendor_id
197: and nvl(LESSOR_SITE_ID, 0) = decode(LESSOR_SITE_ID, NULL, 0, p_dup_vendor_site_id);
198:
199: -- **********************************************************
200: -- Updating FA_LEASE_PAYMENT_ITEMS: LESSOR_ID, LESSOR_SITE_ID
201: -- **********************************************************
202: l_location := 'FA_LEASE_PAYMENT_ITEMS';
203: update FA_LEASE_PAYMENT_ITEMS
204: set LESSOR_ID = p_vendor_id

Line 202: l_location := 'FA_LEASE_PAYMENT_ITEMS';

198:
199: -- **********************************************************
200: -- Updating FA_LEASE_PAYMENT_ITEMS: LESSOR_ID, LESSOR_SITE_ID
201: -- **********************************************************
202: l_location := 'FA_LEASE_PAYMENT_ITEMS';
203: update FA_LEASE_PAYMENT_ITEMS
204: set LESSOR_ID = p_vendor_id
205: , LESSOR_SITE_ID = p_vendor_site_id
206: where LESSOR_ID = p_dup_vendor_id

Line 203: update FA_LEASE_PAYMENT_ITEMS

199: -- **********************************************************
200: -- Updating FA_LEASE_PAYMENT_ITEMS: LESSOR_ID, LESSOR_SITE_ID
201: -- **********************************************************
202: l_location := 'FA_LEASE_PAYMENT_ITEMS';
203: update FA_LEASE_PAYMENT_ITEMS
204: set LESSOR_ID = p_vendor_id
205: , LESSOR_SITE_ID = p_vendor_site_id
206: where LESSOR_ID = p_dup_vendor_id
207: and LESSOR_SITE_ID = p_dup_vendor_site_id;