APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on OZF_TIME_RPT_STRUCT

Line 335: FROM ozf_time_rpt_struct a,

331: CURSOR c_get_year_to_date_sales( p_as_of_date IN DATE ,
332: p_cust_account_id IN NUMBER)
333: IS
334: SELECT NVL(SUM(b.sales_amt),0) tot_sales
335: FROM ozf_time_rpt_struct a,
336: ozf_order_sales_sumry_mv b
337: WHERE a.report_date = p_as_of_date
338: AND BITAND(a.record_type_id, 119) = a.record_type_id
339: AND a.time_id = b.time_id