APPS.OZF_CUST_FACTS_PVT dependencies on OZF_TIME_ENT_PERIOD

Line 569: ozf_time_ent_period b

565:
566: CURSOR last_day_csr IS
567: SELECT b.end_date
568: FROM ozf_time_day a,
569: ozf_time_ent_period b
570: WHERE a.report_date = p_report_date
571: AND a.ent_period_id = b.ent_period_id;
572:
573:

Line 1029: FROM ozf_time_ent_period

1025: l_current_temp_year_target NUMBER;
1026:
1027: CURSOR period_id_csr(p_qtr_id NUMBER) IS
1028: SELECT ent_period_id
1029: FROM ozf_time_ent_period
1030: WHERE ent_qtr_id = p_qtr_id;
1031:
1032: CURSOR qtr_id_csr(p_year_id NUMBER) IS
1033: SELECT ent_qtr_id

Line 1039: FROM ozf_time_ent_period

1035: WHERE ent_year_id = p_year_id;
1036:
1037: CURSOR period_id_yr_csr(p_year_id NUMBER) IS
1038: SELECT ent_period_id
1039: FROM ozf_time_ent_period
1040: WHERE ent_year_id = p_year_id;
1041:
1042: BEGIN
1043:

Line 1549: FROM ozf_time_ent_period

1545:
1546: -- Periods in a Quarter
1547: CURSOR period_id_csr(p_qtr_id NUMBER) IS
1548: SELECT ent_period_id
1549: FROM ozf_time_ent_period
1550: WHERE ent_qtr_id = p_qtr_id;
1551:
1552: -- Quarters in a Year
1553: CURSOR qtr_id_csr(p_year_id NUMBER) IS

Line 1561: FROM ozf_time_ent_period

1557:
1558: -- Periods in a Year
1559: CURSOR period_id_yr_csr(p_year_id NUMBER) IS
1560: SELECT ent_period_id
1561: FROM ozf_time_ent_period
1562: WHERE ent_year_id = p_year_id;
1563:
1564: l_current_period_time_id NUMBER;
1565: l_current_qtr_time_id NUMBER;

Line 3757: FROM ozf_time_ent_period

3753: --
3754: x_record_type_id := 23;
3755:
3756: SELECT start_date, end_date INTO x_start_date, x_end_date
3757: FROM ozf_time_ent_period
3758: WHERE ent_period_id = p_time_id;
3759: --
3760: ELSIF p_period_type_id = 16
3761: THEN