APPS.FII_PMV_UTIL dependencies on FII_TIME_DAY

Line 816: select week_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

812: IF l_as_of_date is not null then
813: If l_period_type is not null then
814: CASE l_period_type
815: WHEN 'FII_TIME_WEEK' THEN
816: select week_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
817: p_id_column := 'week_id';
818: BEGIN
819: p_period_start := fii_time_api.cwk_start(l_as_of_date);
820: EXCEPTION

Line 825: select ent_period_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

821: When no_data_found then
822: p_period_start := fii_time_api.cwk_start(sysdate);
823: END;
824: WHEN 'FII_TIME_ENT_PERIOD' THEN
825: select ent_period_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
826: p_id_column := 'ent_period_id';
827: BEGIN
828: p_period_start := fii_time_api.ent_cper_start(l_as_of_date);
829: EXCEPTION

Line 834: select ent_qtr_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

830: When no_data_found then
831: p_period_start := fii_time_api.ent_cper_start(sysdate);
832: END;
833: WHEN 'FII_TIME_ENT_QTR' THEN
834: select ent_qtr_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
835: p_id_column := 'ent_qtr_id';
836: BEGIN
837: p_period_start := fii_time_api.ent_cqtr_start(l_as_of_date);
838: EXCEPTION

Line 843: select ent_year_id into p_cur_period from fii_time_day where report_date=l_as_of_date;

839: When no_data_found then
840: p_period_start := fii_time_api.ent_cqtr_start(sysdate);
841: END;
842: WHEN 'FII_TIME_ENT_YEAR' THEN
843: select ent_year_id into p_cur_period from fii_time_day where report_date=l_as_of_date;
844: p_id_column := 'ent_year_id';
845: BEGIN
846: p_period_start := fii_time_api.ent_cyr_start(l_as_of_date);
847: EXCEPTION