APPS.AP_XLA_UPGRADE_PKG dependencies on AP_LIABILITY_BALANCE

Line 1220: FROM AP_Liability_Balance APL,

1216: Balance_Amount
1217: FROM (SELECT APL.Code_Combination_ID Code_Combination_ID,
1218: UPG.Start_Date Balance_Date,
1219: SUM(NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0)) Balance_Amount
1220: FROM AP_Liability_Balance APL,
1221: XLA_Upgrade_Dates UPG
1222: WHERE APL.Set_Of_Books_ID = p_ledger_id
1223: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
1224: AND APL.Accounting_Date < UPG.Start_Date

Line 1250: FROM AP_Liability_Balance APL,

1246: FROM (SELECT APL.Set_Of_Books_ID Ledger_ID,
1247: APL.Code_Combination_ID Code_Combination_ID,
1248: UPG.Start_Date Balance_Date,
1249: NVL(APL.Accounted_Cr,0) - NVL(APL.Accounted_Dr,0) Remaining_Amount
1250: FROM AP_Liability_Balance APL,
1251: XLA_Upgrade_Dates UPG
1252: WHERE APL.Set_Of_Books_ID = p_ledger_id
1253: AND APL.Set_Of_Books_ID = UPG.Ledger_ID
1254: AND APL.Accounting_Date < UPG.Start_Date

Line 1772: FROM AP_Liability_Balance

1768: Sysdate,
1769: 5,
1770: Sysdate,
1771: 5
1772: FROM AP_Liability_Balance
1773: WHERE Set_Of_Books_ID IN (SELECT Ledger_ID FROM XLA_Upgrade_Dates);
1774:
1775: SELECT xla_upg_batches_s.nextval
1776: INTO l_batch_id