DBA Data[Home] [Help]

APPS.CN_PERIOD_QUOTAS_PKG dependencies on CN_QUOTAS_V

Line 318: cn_quotas_v where quota_id = x_quota_id;

314: l_login_id := fnd_global.login_id;
315: l_insert_flag := 'Y';
316:
317: select end_date, org_id into l_end_date, l_org_id from
318: cn_quotas_v where quota_id = x_quota_id;
319:
320: select min(start_date) into l_min_date from cn_acc_period_statuses_v
321: where period_status IN ('F', 'O') and org_id = l_org_id;
322:

Line 587: cn_quotas_v where quota_id = x_quota_id;

583: -- get start date, end date for the pe
584: l_delete_all_flag := 'N';
585: select start_date, end_date, org_id
586: into l_start_date, l_end_date, l_org_id from
587: cn_quotas_v where quota_id = x_quota_id;
588: -- max date of open or future entry periods
589: select max(end_date) into l_max_date from cn_acc_period_statuses_v
590: where period_status IN ('F', 'O') and org_id = l_org_id;
591: -- min date of open or future entry periods