DBA Data[Home] [Help]

APPS.OPI_DBI_INV_RPT_PKG dependencies on BIS_COMMON_PARAMETERS

Line 579: l_global_start_date := bis_common_parameters.get_global_start_date;

575: sum(sum(' || p_total_col_name(i).column_name || ')) over () ' || p_total_col_name(i).column_alias;
576: END LOOP;
577:
578: l_span := (CASE p_xtd WHEN 'YTD' THEN 365 WHEN 'QTD' THEN 90 WHEN 'MTD' THEN 30 ELSE 7 END);
579: l_global_start_date := bis_common_parameters.get_global_start_date;
580:
581: l_partial_weight := ' (&BIS_CURRENT_ASOF_DATE - &BIS_CURRENT_EFFECTIVE_START_DATE + 1) ';
582:
583: l_prev_partial_weight := ' (&BIS_PREVIOUS_ASOF_DATE - &BIS_PREVIOUS_EFFECTIVE_START_DATE + 1) ';