APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_ENT_PERIOD

Line 9812: from ozf_time_ent_period period

9808: WHERE tt.allocation_for = 'CUST'
9809: AND tt.allocation_for_id = l_account_allocation_id
9810: and EXISTS
9811: (select 'x'
9812: from ozf_time_ent_period period
9813: where period.ent_period_id = tt.time_id
9814: and period.end_date < trunc(sysdate)
9815: and tt.period_type_id = 32
9816: UNION

Line 9845: from ozf_time_ent_period period

9841: and aa.allocation_for_id = p_fund_id
9842: and aa.site_use_id = -9999)
9843: and EXISTS
9844: (select 'x'
9845: from ozf_time_ent_period period
9846: where period.ent_period_id = tta.time_id
9847: and period.end_date >= trunc(sysdate)
9848: and tta.period_type_id = 32
9849: UNION

Line 9871: from ozf_time_ent_period period

9867: and aa.allocation_for_id = p_fund_id
9868: and aa.site_use_id = -9999)
9869: and EXISTS
9870: (select 'x'
9871: from ozf_time_ent_period period
9872: where period.ent_period_id = tta.time_id
9873: and period.start_date >= trunc(sysdate)
9874: and tta.period_type_id = 32
9875: UNION

Line 10030: from ozf_time_ent_period

10026: WHERE tt.allocation_for = 'PROD'
10027: AND tt.allocation_for_id = l_product_allocation_id
10028: and EXISTS
10029: (select 'x'
10030: from ozf_time_ent_period
10031: where ent_period_id = tt.time_id
10032: and end_date < trunc(sysdate)
10033: and tt.period_type_id = 32
10034: UNION

Line 10374: from ozf_time_ent_period period

10370: tta.allocation_for = 'CUST'
10371: AND tta.allocation_for_id = l_unalloc_acct_alloc_id
10372: and EXISTS
10373: (select 'x'
10374: from ozf_time_ent_period period
10375: where period.ent_period_id = tta.time_id
10376: and period.end_date >= trunc(sysdate)
10377: and tta.period_type_id = 32
10378: UNION

Line 10420: from ozf_time_ent_period period

10416: WHERE ttb.allocation_for = 'CUST'
10417: AND ttb.allocation_for_id = l_account_allocation_id
10418: AND EXISTS
10419: (select 'x'
10420: from ozf_time_ent_period period
10421: where period.ent_period_id = ttb.time_id
10422: and period.end_date >= trunc(sysdate)
10423: and ttb.period_type_id = 32
10424: UNION

Line 10472: from ozf_time_ent_period

10468: AND pp.allocation_for_id = l_account_allocation_id
10469: )
10470: and EXISTS
10471: (select 'x'
10472: from ozf_time_ent_period
10473: where ent_period_id = tt.time_id
10474: and end_date >= trunc(sysdate)
10475: and tt.period_type_id = 32
10476: UNION