DBA Data[Home] [Help]

APPS.OZF_FUNDRULES_PVT dependencies on OZF_TIME_ENT_PERIOD

Line 629: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD

625: FROM gl_periods_v
626: WHERE period_set_name = p_fund_calendar AND period_name = p_end_period_name;
627:
628: CURSOR c_start_period_quota IS
629: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
630: WHERE NAME = p_start_period_name
631: UNION ALL
632: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
633: WHERE NAME = p_start_period_name

Line 639: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD

635: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR
636: WHERE NAME = p_start_period_name;
637:
638: CURSOR c_end_period_quota IS
639: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
640: WHERE NAME = p_end_period_name
641: UNION ALL
642: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
643: WHERE NAME = p_end_period_name

Line 653: (SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD

649: /*
650: CURSOR c_start_period_quota IS
651: SELECT NAME, START_DATE, END_DATE
652: FROM
653: (SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
654: UNION ALL
655: SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
656: UNION ALL
657: SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR

Line 664: (SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD

660:
661: CURSOR c_end_period_quota IS
662: SELECT NAME, START_DATE, END_DATE
663: FROM
664: (SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_PERIOD
665: UNION ALL
666: SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
667: UNION ALL
668: SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR