ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF9D3869E053B46B63588994 SELECT AGENCY_IDENTIFIER AID ,ALLOC_XFER_AGENCY ATA ,AVAIL_INDICATOR AV ,BALANCE_INDICATOR BE ,BEGIN_PERIOD_AVAIL BPOA ,END_PERIOD_AVAIL EPOA ,MAIN_ACCOUNT_CODE MAIN ,OBJECT_CLASS_CODE OBJECT ,PROG_REPORTING_CODE ACTCODE ,PROG_REPORTING_DESC ACTDESC ,REIMB_INDICATOR DRC ,SUB_ACCOUNT_CODE SUB ,USSGL_ACCOUNT SGLACCT ,ABS(END_BALANCE) AMOUNT ,CASE WHEN END_BALANCE < 0 THEN 'C' WHEN END_BALANCE < 0 THEN 'D' END DC FROM FV_OPA_BALANCE_TEMP TB WHERE TB.LEDGER_ID = :P_LEDGER_ID AND rollup_flag = 'Y' ORDER BY ALLOC_XFER_AGENCY, AGENCY_IDENTIFIER, BEGIN_PERIOD_AVAIL, END_PERIOD_AVAIL, AVAIL_INDICATOR,MAIN_ACCOUNT_CODE, SUB_ACCOUNT_CODE, USSGL_ACCOUNT, BALANCE_INDICATOR, REIMB_INDICATOR, OBJECT_CLASS_CODE, PROG_REPORTING_CODE Y FV FVOPACT Y US FV Object Class and Program Activity Application: Federal Financials Source: Object Class and Program Activity Report Short Name: FVOPACT DB package: BI Publisher :p_ledger_id