[Home] [Help]
457: ,0) - NVL(SUM(AEL.ENTERED_DR)
458: ,0)
459: INTO L_BALANCE
460: FROM
461: AP_AE_LINES_ALL AEL,
462: AP_AE_HEADERS_ALL AEH
463: WHERE AEL.AE_LINE_TYPE_CODE = 'LIABILITY'
464: AND AEH.SET_OF_BOOKS_ID = L_SOB
465: AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID
472: ,0) - NVL(SUM(AEL.ACCOUNTED_DR)
473: ,0)
474: INTO L_BALANCE
475: FROM
476: AP_AE_LINES_ALL AEL,
477: AP_AE_HEADERS_ALL AEH
478: WHERE AEL.AE_LINE_TYPE_CODE = 'LIABILITY'
479: AND AEH.SET_OF_BOOKS_ID = L_SOB
480: AND AEL.AE_HEADER_ID = AEH.AE_HEADER_ID