DBA Data[Home] [Help]

APPS.GL_BIS_ALERTS_PKG dependencies on GL_OASIS_SUMMARY_DATA

Line 284: FROM gl_oasis_summary_data

280:
281: BEGIN
282: SELECT -1*period_to_date
283: INTO ret_amount
284: FROM gl_oasis_summary_data
285: WHERE set_of_books_id = to_number(p_organization_id)
286: AND fin_item_id = 'REVENUE'
287: AND drilldown_segnum1 = p_dim1_segnum
288: AND drilldown_segnum2 = p_dim2_segnum