APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_ENT_QTR

Line 9818: from ozf_time_ent_qtr qtr

9814: and period.end_date < trunc(sysdate)
9815: and tt.period_type_id = 32
9816: UNION
9817: select 'x'
9818: from ozf_time_ent_qtr qtr
9819: where qtr.ent_qtr_id = tt.time_id
9820: and qtr.end_date < trunc(sysdate)
9821: and tt.period_type_id = 64
9822: );

Line 9851: from ozf_time_ent_qtr qtr

9847: and period.end_date >= trunc(sysdate)
9848: and tta.period_type_id = 32
9849: UNION
9850: select 'x'
9851: from ozf_time_ent_qtr qtr
9852: where qtr.ent_qtr_id = tta.time_id
9853: and qtr.end_date >= trunc(sysdate)
9854: and tta.period_type_id = 64
9855: );

Line 9877: from ozf_time_ent_qtr qtr

9873: and period.start_date >= trunc(sysdate)
9874: and tta.period_type_id = 32
9875: UNION
9876: select 'x'
9877: from ozf_time_ent_qtr qtr
9878: where qtr.ent_qtr_id = tta.time_id
9879: and qtr.start_date >= trunc(sysdate)
9880: and tta.period_type_id = 64
9881: );

Line 10036: from ozf_time_ent_qtr

10032: and end_date < trunc(sysdate)
10033: and tt.period_type_id = 32
10034: UNION
10035: select 'x'
10036: from ozf_time_ent_qtr
10037: where ent_qtr_id = tt.time_id
10038: and end_date < trunc(sysdate)
10039: and tt.period_type_id = 64
10040: );

Line 10380: from ozf_time_ent_qtr qtr

10376: and period.end_date >= trunc(sysdate)
10377: and tta.period_type_id = 32
10378: UNION
10379: select 'x'
10380: from ozf_time_ent_qtr qtr
10381: where qtr.ent_qtr_id = tta.time_id
10382: and qtr.end_date >= trunc(sysdate)
10383: and tta.period_type_id = 64
10384: );

Line 10426: from ozf_time_ent_qtr qtr

10422: and period.end_date >= trunc(sysdate)
10423: and ttb.period_type_id = 32
10424: UNION
10425: select 'x'
10426: from ozf_time_ent_qtr qtr
10427: where qtr.ent_qtr_id = ttb.time_id
10428: and qtr.end_date >= trunc(sysdate)
10429: and ttb.period_type_id = 64
10430: );

Line 10478: from ozf_time_ent_qtr

10474: and end_date >= trunc(sysdate)
10475: and tt.period_type_id = 32
10476: UNION
10477: select 'x'
10478: from ozf_time_ent_qtr
10479: where ent_qtr_id = tt.time_id
10480: and end_date >= trunc(sysdate)
10481: and tt.period_type_id = 64
10482: );