APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_TIME_ENT_YEAR

Line 1138: FROM OZF_TIME_ENT_YEAR ey

1134:
1135: --Fix for Bug 12657908
1136: CURSOR c_get_year_id(p_gl_date IN DATE) IS
1137: SELECT ent_year_id
1138: FROM OZF_TIME_ENT_YEAR ey
1139: WHERE p_gl_date between ey.start_date and ey.end_date;
1140:
1141:
1142: c_purchase_price purchase_price_cursor_type;

Line 4818: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR

4814: -- Fix for Bug 12657908
4815: FORALL t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
4816: UPDATE ozf_funds_utilized_all_b
4817: SET gl_date = l_gl_date,
4818: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR
4819: WHERE l_gl_date between start_date and end_date)
4820: WHERE utilization_id = l_utilIdTbl(t_i);
4821:
4822: FOR t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)

Line 6467: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR

6463: --Fix for Bug 12657908
6464: FORALL t_i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
6465: UPDATE ozf_funds_utilized_all_b
6466: SET gl_date = l_gl_date,
6467: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR
6468: WHERE l_gl_date between start_date and end_date)
6469: WHERE utilization_id = l_utilIdTbl(t_i);
6470: --nirprasa, ER 8399134
6471: IF TRUNC(l_excDateTbl(i)) <> TRUNC(l_gl_date) AND l_utilTypeTbl(i) IN ('UTILIZED') THEN

Line 6643: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR

6639: IF p_gl_date IS NOT NULL THEN
6640: FORALL i IN NVL(l_utilIdTbl.FIRST, 1) .. NVL(l_utilIdTbl.LAST, 0)
6641: UPDATE ozf_funds_utilized_all_b
6642: SET gl_date = p_gl_date,
6643: year_id = (select ent_year_id FROM OZF_TIME_ENT_YEAR
6644: WHERE p_gl_date between start_date and end_date)
6645: WHERE utilization_id = l_utilIdTbl(i);
6646: END IF;
6647: