APPS.CN_GENERAL_UTILS dependencies on CN_ACC_PERIOD_STATUSES_V

Line 278: FROM cn_acc_period_statuses_v

274:
275: FUNCTION get_acc_fromperiod_id(p_date DATE, p_org_id NUMBER) RETURN NUMBER IS
276: CURSOR l_date_period_csr IS
277: SELECT period_id
278: FROM cn_acc_period_statuses_v
279: WHERE p_date BETWEEN start_date AND end_date
280: AND org_id = p_org_id;
281:
282: CURSOR l_null_date_period_csr IS

Line 284: FROM cn_acc_period_statuses_v

280: AND org_id = p_org_id;
281:
282: CURSOR l_null_date_period_csr IS
283: SELECT MIN(period_id)
284: FROM cn_acc_period_statuses_v
285: WHERE period_status = 'O'
286: AND org_id = p_org_id;
287:
288: l_period_id NUMBER(15);