DBA Data[Home] [Help]

APPS.CN_PERIOD_QUOTAS_GRP dependencies on CN_ACC_PERIOD_STATUSES_V

Line 199: FROM cn_acc_period_statuses_v

195: SELECT start_date,
196: end_date
197: INTO l_period_start_date,
198: l_period_end_date
199: FROM cn_acc_period_statuses_v
200: WHERE period_id = x_period_id AND org_id = l_org_id;
201:
202: IF TRUNC (l_period_start_date) < TRUNC (cn_period_quotas_pkg.previous_period (l_quota_start_date,l_org_id))
203: OR TRUNC (l_period_end_date) > TRUNC (cn_api.next_period (NVL (l_quota_end_date, l_period_end_date), l_org_id))