APPS.OE_BIS dependencies on OE_BIS_BBB_INFO

Line 268: delete from oe_bis_bbb_info;

264: P_ORG_ID NUMBER ) IS
265:
266: begin
267:
268: delete from oe_bis_bbb_info;
269:
270: insert into oe_bis_bbb_info ( period_year,
271: period_num,
272: period_name,

Line 270: insert into oe_bis_bbb_info ( period_year,

266: begin
267:
268: delete from oe_bis_bbb_info;
269:
270: insert into oe_bis_bbb_info ( period_year,
271: period_num,
272: period_name,
273: period_start,
274: period_end,

Line 292: update oe_bis_bbb_info bbb

288: and ((p_period_start <= gp.start_date
289: and p_period_end >= gp.end_date)
290: or (p_period_end between gp.start_date and gp.end_date));
291:
292: update oe_bis_bbb_info bbb
293: set bookings =
294: (select sum(
295: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,
296: trunc(sysdate),'Corporate'),

Line 305: update oe_bis_bbb_info bbb set

301: from oe_bis_bookings_v
302: where booking_date between bbb.period_start and bbb.period_end
303: and nvl(p_org_id,ou_id) = ou_id);
304:
305: update oe_bis_bbb_info bbb set
306: billings =
307: (select sum(
308: decode(gl_currency_api.rate_exists(line_currency,bbb.currency_code,
309: trunc(sysdate),'Corporate'),

Line 318: update oe_bis_bbb_info bbb set

314: from oe_bis_billings_v
315: where invoicing_date between bbb.period_start and bbb.period_end
316: and nvl(p_org_id,ou_id) = ou_id);
317:
318: update oe_bis_bbb_info bbb set
319: adjustments =
320: (select sum(
321: decode(gl_currency_api.rate_exists(currency_code,bbb.currency_code,
322: trunc(sysdate),'Corporate'),

Line 332: update oe_bis_bbb_info bbb set

328: where cancel_date between bbb.period_start and bbb.period_end
329: and nvl(p_org_id,ou_id) = ou_id);
330:
331:
332: update oe_bis_bbb_info bbb set
333: closing_backlog =
334: (select sum(
335: decode(gl_currency_api.rate_exists(line_currency, bbb.currency_code,
336: trunc(sysdate),'Corporate'),