APPS.POA_DBI_UTIL_PKG dependencies on FND_DATE

Line 151: l_table_name := '(select fnd_date.date_to_displaydate(report_date) name, t.report_date start_date, t.report_date end_date from fii_time_day t)';

147: l_table_name := 'fii_time_ent_period';
148: elsif(period_type = 'WTD') then
149: l_table_name := 'fii_time_week';
150: elsif(period_type = 'DAY') then
151: l_table_name := '(select fnd_date.date_to_displaydate(report_date) name, t.report_date start_date, t.report_date end_date from fii_time_day t)';
152: end if;
153:
154: RETURN l_table_name ;
155:

Line 1244: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(bis_collection_utilities.get_last_refresh_period(upper(p_balance_fact))),'dd/mm/yyyy');

1240: end if;
1241: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1242:
1243: l_custom_rec.attribute_name := '&LAST_COLLECTION';
1244: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(bis_collection_utilities.get_last_refresh_period(upper(p_balance_fact))),'dd/mm/yyyy');
1245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1247: p_custom_output.extend;
1248: p_custom_output(p_custom_output.count) := l_custom_rec;