APPS.CN_PRD_QUOTA_PUB dependencies on CN_PERIOD_STATUSES

Line 229: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;

225: l_api_version CONSTANT NUMBER := 1.0;
226:
227: l_quota_id CN_QUOTAS.quota_id%TYPE;
228:
229: tbl_period_id CN_PERIOD_STATUSES.period_id%TYPE;
230:
231: tbl_period_quota_id CN_PERIOD_QUOTAS.period_quota_id%TYPE;
232:
233: tbl_quarter_num CN_PERIOD_QUOTAS.quarter_num%TYPE;

Line 274: from cn_period_statuses

270: where quota_id = p_quota_id;
271:
272: CURSOR l_period_id_cr(p_period_name VARCHAR2) IS
273: select *
274: from cn_period_statuses
275: where period_name = p_period_name
276: and org_id = l_org_id;
277:
278: CURSOR tbl_period_quota_info_cr(p_period_id NUMBER, p_quota_id NUMBER) IS

Line 286: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;

282: and period_id = p_period_id;
283:
284: f_quota_row_rec CN_QUOTAS%ROWTYPE;
285: f_quota_id_rec CN_QUOTAS%ROWTYPE;
286: f_period_id_rec CN_PERIOD_STATUSES%ROWTYPE;
287: f_period_quota_info_rec CN_PERIOD_QUOTAS%ROWTYPE;
288:
289:
290: BEGIN