DBA Data[Home] [Help]

APPS.OZF_FUNDRULES_PVT dependencies on OZF_TIME_ENT_YEAR

Line 635: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR

631: UNION ALL
632: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
633: WHERE NAME = p_start_period_name
634: UNION ALL
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

Line 645: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR

641: UNION ALL
642: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_QTR
643: WHERE NAME = p_end_period_name
644: UNION ALL
645: SELECT START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR
646: WHERE NAME = p_end_period_name;
647:
648:
649: /*

Line 657: SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR

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
658: )
659: WHERE NAME = p_start_period_name;
660:
661: CURSOR c_end_period_quota IS

Line 668: SELECT NAME, START_DATE, END_DATE FROM OZF_TIME_ENT_YEAR

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
669: )
670: WHERE NAME = p_end_period_name;
671: */
672: