APPS.PJI_PMV_UTIL dependencies on FII_TIME_WEEK_V

Line 509: FROM fii_time_week_v

505: l_value VARCHAR2(100);
506:
507: CURSOR get_week(l_is_date IN DATE) IS
508: SELECT value, start_date
509: FROM fii_time_week_v
510: WHERE l_is_date between start_date and end_date;
511:
512: BEGIN
513:

Line 603: from fii_time_week_v

599: THEN
600:
601: select start_date
602: into l_start_date
603: from fii_time_week_v
604: where value = p_week;
605:
606: -- constructing the URL string
607: --Bug 5603228, 5603194 Add nls_date_language parameter to to_date function call

Line 650: FROM fii_time_week_v

646: -- modified to fix bug2505055 (due to fii bug)
647: -- get value from date between start date and end date
648: CURSOR get_week(l_is_date IN DATE) IS
649: SELECT value, start_date
650: FROM fii_time_week_v
651: WHERE l_is_date between start_date and end_date;
652:
653: BEGIN
654:

Line 755: from fii_time_week_v

751:
752: BEGIN
753: select start_date
754: into l_start_date
755: from fii_time_week_v
756: where value = p_week;
757:
758: -- constructing the URL string
759: l_Url := '&PJI_REP_DIM_18_FROM=' || p_week || '&PJI_REP_DIM_18_TO=' || p_week ||