APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on OZF_TIME_ENT_PERIOD

Line 9777: from ozf_time_ent_period period

9773: WHERE tt.allocation_for = 'CUST'
9774: AND tt.allocation_for_id = l_account_allocation_id
9775: and EXISTS
9776: (select 'x'
9777: from ozf_time_ent_period period
9778: where period.ent_period_id = tt.time_id
9779: and period.end_date < trunc(sysdate)
9780: and tt.period_type_id = 32
9781: UNION

Line 9810: from ozf_time_ent_period period

9806: and aa.allocation_for_id = p_fund_id
9807: and aa.site_use_id = -9999)
9808: and EXISTS
9809: (select 'x'
9810: from ozf_time_ent_period period
9811: where period.ent_period_id = tta.time_id
9812: and period.end_date >= trunc(sysdate)
9813: and tta.period_type_id = 32
9814: UNION

Line 9836: from ozf_time_ent_period period

9832: and aa.allocation_for_id = p_fund_id
9833: and aa.site_use_id = -9999)
9834: and EXISTS
9835: (select 'x'
9836: from ozf_time_ent_period period
9837: where period.ent_period_id = tta.time_id
9838: and period.start_date >= trunc(sysdate)
9839: and tta.period_type_id = 32
9840: UNION

Line 9995: from ozf_time_ent_period

9991: WHERE tt.allocation_for = 'PROD'
9992: AND tt.allocation_for_id = l_product_allocation_id
9993: and EXISTS
9994: (select 'x'
9995: from ozf_time_ent_period
9996: where ent_period_id = tt.time_id
9997: and end_date < trunc(sysdate)
9998: and tt.period_type_id = 32
9999: UNION

Line 10339: from ozf_time_ent_period period

10335: tta.allocation_for = 'CUST'
10336: AND tta.allocation_for_id = l_unalloc_acct_alloc_id
10337: and EXISTS
10338: (select 'x'
10339: from ozf_time_ent_period period
10340: where period.ent_period_id = tta.time_id
10341: and period.end_date >= trunc(sysdate)
10342: and tta.period_type_id = 32
10343: UNION

Line 10385: from ozf_time_ent_period period

10381: WHERE ttb.allocation_for = 'CUST'
10382: AND ttb.allocation_for_id = l_account_allocation_id
10383: AND EXISTS
10384: (select 'x'
10385: from ozf_time_ent_period period
10386: where period.ent_period_id = ttb.time_id
10387: and period.end_date >= trunc(sysdate)
10388: and ttb.period_type_id = 32
10389: UNION

Line 10437: from ozf_time_ent_period

10433: AND pp.allocation_for_id = l_account_allocation_id
10434: )
10435: and EXISTS
10436: (select 'x'
10437: from ozf_time_ent_period
10438: where ent_period_id = tt.time_id
10439: and end_date >= trunc(sysdate)
10440: and tt.period_type_id = 32
10441: UNION