110: END IF;
111:
112: -- Get the parameters
113:
114: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,
115: l_as_of_date,
116: l_period_type,
117: l_record_type_id,
118: l_comp_type,
132: IF l_classification IS NOT NULL THEN
133: l_where_clause := l_where_clause || ' AND email_classification_id IN (:l_classification) ';
134: END IF;
135:
136: l_period_start_Date := BIX_PMV_DBI_UTL_PKG.period_start_date(l_as_of_date,l_period_type);
137:
138: /* Get the MAX date for which data is collected in Email Summary table */
139:
140: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_EMAIL_DETAILS_F',