DBA Data[Home] [Help]

APPS.AP_XLA_UPGRADE_PKG dependencies on AP_LIABILITY_BALANCE

Line 2051: FROM AP_Liability_Balance APL,

2047: Balance_Amount
2048: FROM (SELECT APL.Code_Combination_ID Code_Combination_ID,
2049: UPG.Start_Date Balance_Date,
2050: SUM(NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0)) Balance_Amount
2051: FROM AP_Liability_Balance APL,
2052: XLA_Upgrade_Dates UPG
2053: WHERE APL.Set_Of_Books_ID = p_ledger_id
2054: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
2055: AND APL.Accounting_Date < UPG.Start_Date

Line 2081: FROM AP_Liability_Balance APL,

2077: FROM (SELECT APL.Set_Of_Books_ID Ledger_ID,
2078: APL.Code_Combination_ID Code_Combination_ID,
2079: UPG.Start_Date Balance_Date,
2080: NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0) Remaining_Amount
2081: FROM AP_Liability_Balance APL,
2082: XLA_Upgrade_Dates UPG
2083: WHERE APL.Set_Of_Books_ID = p_ledger_id
2084: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
2085: AND APL.Accounting_Date < UPG.Start_Date