DBA Data[Home] [Help]

APPS.FII_MSG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 147

        select name into stmt
        from fii_time_ent_year
        where l_asof_date between start_date and end_date;
Line: 151

        select name into stmt
        from fii_time_ent_qtr
        where l_asof_date between start_date and end_date;
Line: 155

        select name into stmt
        from fii_time_ent_period
        where l_asof_date between start_date and end_date;
Line: 159

        select to_char(sequence) into l_week
        from fii_time_week
        where l_asof_date between start_date and end_date;
Line: 163

	select substr(week_id,3,2) into l_year
	from fii_time_week
	where l_asof_date between start_date and end_date;
Line: 181

select id into stmt from fii_currencies_v where id = 'FII_GLOBAL1';