APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_ENT_QTR

Line 9783: from ozf_time_ent_qtr qtr

9779: and period.end_date < trunc(sysdate)
9780: and tt.period_type_id = 32
9781: UNION
9782: select 'x'
9783: from ozf_time_ent_qtr qtr
9784: where qtr.ent_qtr_id = tt.time_id
9785: and qtr.end_date < trunc(sysdate)
9786: and tt.period_type_id = 64
9787: );

Line 9816: from ozf_time_ent_qtr qtr

9812: and period.end_date >= trunc(sysdate)
9813: and tta.period_type_id = 32
9814: UNION
9815: select 'x'
9816: from ozf_time_ent_qtr qtr
9817: where qtr.ent_qtr_id = tta.time_id
9818: and qtr.end_date >= trunc(sysdate)
9819: and tta.period_type_id = 64
9820: );

Line 9842: from ozf_time_ent_qtr qtr

9838: and period.start_date >= trunc(sysdate)
9839: and tta.period_type_id = 32
9840: UNION
9841: select 'x'
9842: from ozf_time_ent_qtr qtr
9843: where qtr.ent_qtr_id = tta.time_id
9844: and qtr.start_date >= trunc(sysdate)
9845: and tta.period_type_id = 64
9846: );

Line 10001: from ozf_time_ent_qtr

9997: and end_date < trunc(sysdate)
9998: and tt.period_type_id = 32
9999: UNION
10000: select 'x'
10001: from ozf_time_ent_qtr
10002: where ent_qtr_id = tt.time_id
10003: and end_date < trunc(sysdate)
10004: and tt.period_type_id = 64
10005: );

Line 10345: from ozf_time_ent_qtr qtr

10341: and period.end_date >= trunc(sysdate)
10342: and tta.period_type_id = 32
10343: UNION
10344: select 'x'
10345: from ozf_time_ent_qtr qtr
10346: where qtr.ent_qtr_id = tta.time_id
10347: and qtr.end_date >= trunc(sysdate)
10348: and tta.period_type_id = 64
10349: );

Line 10391: from ozf_time_ent_qtr qtr

10387: and period.end_date >= trunc(sysdate)
10388: and ttb.period_type_id = 32
10389: UNION
10390: select 'x'
10391: from ozf_time_ent_qtr qtr
10392: where qtr.ent_qtr_id = ttb.time_id
10393: and qtr.end_date >= trunc(sysdate)
10394: and ttb.period_type_id = 64
10395: );

Line 10443: from ozf_time_ent_qtr

10439: and end_date >= trunc(sysdate)
10440: and tt.period_type_id = 32
10441: UNION
10442: select 'x'
10443: from ozf_time_ent_qtr
10444: where ent_qtr_id = tt.time_id
10445: and end_date >= trunc(sysdate)
10446: and tt.period_type_id = 64
10447: );