APPS.PJI_PMV_UTIL dependencies on FII_TIME_ENT_PERIOD

Line 368: WHEN 'FII_TIME_ENT_PERIOD' THEN

364: WHEN 'FII_TIME_ENT_YEAR' THEN
365: l_Time_Level:='_'||G_Year_Label;
366: WHEN 'FII_TIME_ENT_QTR' THEN
367: l_Time_Level:='_'||G_Quarter_Label;
368: WHEN 'FII_TIME_ENT_PERIOD' THEN
369: l_Time_Level:='_'||G_Period_Label;
370: WHEN 'FII_TIME_CAL_YEAR' THEN
371: l_Time_Level:='_'||G_Year_Label;
372: WHEN 'FII_TIME_CAL_QTR' THEN

Line 387: WHEN 'FII_TIME_ENT_PERIOD' THEN

383: WHEN 'FII_TIME_ENT_YEAR' THEN
384: l_Time_Level:='_'||G_YTD_Label;
385: WHEN 'FII_TIME_ENT_QTR' THEN
386: l_Time_Level:='_'||G_QTD_Label;
387: WHEN 'FII_TIME_ENT_PERIOD' THEN
388: l_Time_Level:='_'||G_PTD_Label;
389: WHEN 'FII_TIME_CAL_YEAR' THEN
390: l_Time_Level:='_'||G_YTD_Label;
391: WHEN 'FII_TIME_CAL_QTR' THEN

Line 834: ELSIF p_period_type = 'FII_TIME_ENT_PERIOD' THEN

830:
831: l_period_url := '&PJI_REP_DIM_12_FROM=' || l_val_from || '&PJI_REP_DIM_12_TO=' || l_val_to;
832:
833: -- get the FROM and TO values for the Period using the dates passed
834: ELSIF p_period_type = 'FII_TIME_ENT_PERIOD' THEN
835:
836: select name
837: into l_val_from
838: from fii_time_ent_period

Line 838: from fii_time_ent_period

834: ELSIF p_period_type = 'FII_TIME_ENT_PERIOD' THEN
835:
836: select name
837: into l_val_from
838: from fii_time_ent_period
839: where start_date = l_from_date;
840:
841: select name
842: into l_val_to

Line 843: from fii_time_ent_period

839: where start_date = l_from_date;
840:
841: select name
842: into l_val_to
843: from fii_time_ent_period
844: where end_date = l_to_date;
845:
846: l_period_url := '&PJI_REP_DIM_13_FROM=' || l_val_from || '&PJI_REP_DIM_13_TO=' || l_val_to;
847: