APPS.CN_MARK_EVENTS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

  select 1 from cn_period_statuses_all
   where org_id = p_org_id
     and period_id = p_period_id;

Line: 13

  select 1 from cn_srp_intel_periods_all
   where salesrep_id = p_salesrep_id
     and period_id = p_period_id
	 and org_id = p_org_id;

Line: 19

  select 1 from cn_quotas_all
   where org_id = p_org_id
     and quota_id = p_quota_id;

Line: 24

  select 1 from cn_period_statuses_all
   where period_id = p_period_id
     and org_id = p_org_id
	 and p_date between start_date and end_date;