[Home] [Help]
819: * get_expenses
820: *
821: * DESCRIPTION
822: * Retrieves the expense accounts from expenses table such as
823: * gl_aloc_exp and populates the interface table with the
824: * expense amount retrieved from oracle financials.
825: *
826: * AUTHOR
827: * sukarna Reddy 09/18/98
848: e.from_account_id as exp_from_account,
849: e.to_account_id as exp_to_account,
850: e.balance_type as exp_balance_type, e.exp_ytd_ptd
851: FROM
852: gl_aloc_exp e,
853: gl_aloc_mst a
854: WHERE
855: e.alloc_id = a.alloc_id
856: and a.legal_entity_id = g_legal_entity_id