DBA Data[Home] [Help]

APPS.FA_LPITEMS_EXPT_PKG dependencies on FA_LEASE_PAYMENT_ITEMS

Line 321: FROM FA_LEASE_PAYMENT_ITEMS flpi,

317: pv.Vendor_Name Lessor_Name,
318: pvsa.Vendor_Site_Code Lessor_Site_Name,
319: pvsa.Org_ID Org_ID,
320: hao.Name Org_Name
321: FROM FA_LEASE_PAYMENT_ITEMS flpi,
322: FA_LEASES fl, FA_AMORT_SCHEDULES fas,
323: PO_VENDORS pv, PO_VENDOR_SITES_ALL pvsa,
324: HR_ALL_ORGANIZATION_UNITS hao
325: WHERE flpi.Export_Status = 'POST'

Line 447: /*update the FA_Lease_Payment_Items table with new information.*/

443: X_Accounting_Date => V_Payment_Date,
444: X_Org_ID => V_Org_ID
445: ,p_log_level_rec => p_log_level_rec);
446:
447: /*update the FA_Lease_Payment_Items table with new information.*/
448: UPDATE FA_Lease_Payment_Items
449: SET Invoice_ID = V_Invoice_ID,
450: Invoice_Line_ID = V_Invoice_Line_ID,
451: Request_ID = V_Request_ID,

Line 448: UPDATE FA_Lease_Payment_Items

444: X_Org_ID => V_Org_ID
445: ,p_log_level_rec => p_log_level_rec);
446:
447: /*update the FA_Lease_Payment_Items table with new information.*/
448: UPDATE FA_Lease_Payment_Items
449: SET Invoice_ID = V_Invoice_ID,
450: Invoice_Line_ID = V_Invoice_Line_ID,
451: Request_ID = V_Request_ID,
452: Export_Status = 'POSTED'