APPS.CN_CALC_SUBMISSION_PVT SQL Statements

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

Line: 53

     SELECT MAX(ps2.period_id)
       INTO l_end_period_id
       FROM cn_period_statuses_all ps1,
            cn_period_statuses_all ps2
      WHERE ps1.period_id = p_period_id
        AND ps1.org_id = p_org_id
        AND ps2.period_set_id = ps1.period_set_id
        AND ps2.org_id = p_org_id
        AND ps2.period_type_id = ps1.period_type_id
        AND ps2.period_year = ps1.period_year
        AND ( ( p_interval_type_id = -1001 AND ps2.quarter_num = ps1.quarter_num ) -- quarter interval
	     OR p_interval_type_id = -1002 ) ; -- year interval

Line: 97

            SELECT 1
	      FROM cn_srp_plan_assigns_all spa,
	           cn_comp_plans_all plan
	     WHERE spa.salesrep_id = p_salesrep_id
               AND spa.org_id = p_org_id
	       AND ((spa.end_date IS NOT NULL
		     AND p_end_date BETWEEN spa.start_date AND spa.end_date)
		     OR (p_end_date >= spa.start_date AND spa.end_date IS NULL ) )
	       AND spa.comp_plan_id = plan.comp_plan_id
	       AND plan.status_code = 'COMPLETE';

Line: 135

	SELECT 1
	  FROM cn_calc_submission_batches_all
	  WHERE name = p_batch_name
          AND org_id = p_sub_batch_rec.org_id
	  AND (p_sub_batch_rec.calc_sub_batch_id IS NULL OR calc_sub_batch_id <> p_sub_batch_rec.calc_sub_batch_id);

Line: 142

	SELECT 1
	  FROM cn_period_statuses_all
	  WHERE (period_set_id, period_type_id) = (SELECT period_set_id, period_type_id FROM cn_repositories_all
                                                    WHERE org_id = p_sub_batch_rec.org_id)
	  AND period_status = 'O'
          AND org_id = p_sub_batch_rec.org_id
	  AND trunc(p_start_date) BETWEEN trunc(start_date) AND trunc(end_date);

Line: 151

	SELECT name
	  FROM cn_quotas_all
	  WHERE quota_id = p_quota_id
          AND org_id = p_sub_batch_rec.org_id
	  AND incentive_type_code = 'BONUS'
	  AND (interval_type_id = p_sub_batch_rec.interval_type_id OR
	       (p_sub_batch_rec.interval_type_id = -1003 AND interval_type_id IN (-1000, -1001, -1002)));

Line: 723

	SELECT name,
               org_id,
	       calc_sub_batch_id,
	       calc_type,
	       start_date,
	       end_date,
	       salesrep_option,
	       hierarchy_flag,
	       concurrent_flag,
               intelligent_flag,
	       status,
	       interval_type_id,
	       process_audit_id,
	       object_version_number,
	       null
	  FROM cn_calc_submission_batches
	  WHERE calc_sub_batch_id = p_calc_sub_batch_id;

Line: 742

	SELECT b.name, b.employee_number, a.salesrep_id, a.calc_sub_entry_id
	  FROM cn_calc_submission_entries a,
	       cn_salesreps b
	  WHERE a.calc_sub_batch_id = p_calc_sub_batch_id
	  AND a.salesrep_id = b.salesrep_id;

Line: 749

	SELECT b.name, a.quota_id, a.calc_sub_quota_id
	  FROM cn_calc_sub_quotas a,
	       cn_quotas b
	 WHERE a.calc_sub_batch_id = p_calc_sub_batch_id
	  AND a.quota_id = b.quota_id;

Line: 756

	SELECT name
	  FROM cn_interval_types
	  WHERE interval_type_id IN (-1000, -1001, -1002, -1003)
	  ORDER BY interval_type_id desc;

Line: 763

	SELECT concurrent_request_id
	  FROM cn_process_audits
	 WHERE process_audit_id = a_process_audit_id;

Line: 809

  update cn_calc_submission_batches_all sb
     set status = 'FAILED'
   where status = 'PROCESSING'
     and concurrent_flag = 'Y'
     and exists (select 1
                   from fnd_concurrent_requests
                  where request_id = (select concurrent_request_id
                                        from cn_process_audits_all
                                       where process_audit_id = sb.process_audit_id)
                    and status_code in ('E', 'X'));

Line: 1021

   select concurrent_flag
     into l_concurrent_flag
     from cn_calc_submission_batches_all
    where calc_sub_batch_id = p_calc_sub_batch_id;

Line: 1105

        select * from cn_calc_submission_batches where calc_sub_batch_id = p_calc_sub_batch_id;

Line: 1108

        select * from cn_calc_submission_entries where calc_sub_batch_id = p_calc_sub_batch_id;

Line: 1111

        select * from cn_calc_sub_quotas where calc_sub_batch_id = p_calc_sub_batch_id;

Line: 1114

        select * from cn_calc_submission_batches where name = p_batch_name_to_check and rownum = 1;

Line: 1146

    	select CN_CALC_SUBMISSION_BATCHES_S1.nextval into seq_batchid from dual;

Line: 1194

    	insert into
    	cn_calc_submission_batches
    	(ORG_ID,CALC_SUB_BATCH_ID,NAME,CALC_FROM_PERIOD_ID,CALC_TO_PERIOD_ID,INTELLIGENT_FLAG,HIERARCHY_FLAG,
    	SALESREP_OPTION,CONCURRENT_FLAG,LOG_NAME,STATUS,LOGICAL_BATCH_ID,FORECAST_FLAG,ATTRIBUTE_CATEGORY,
    	ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,
    	ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,START_DATE,END_DATE,CALC_TYPE,
    	INTERVAL_TYPE_ID,LEDGER_JE_BATCH_ID,PROCESS_AUDIT_ID,CREATED_BY,CREATION_DATE,OBJECT_VERSION_NUMBER,
    	SECURITY_GROUP_ID)
    	values(
    	BATCH_RECORD.ORG_ID,BATCH_RECORD.CALC_SUB_BATCH_ID,BATCH_RECORD.NAME,BATCH_RECORD.CALC_FROM_PERIOD_ID,
    	BATCH_RECORD.CALC_TO_PERIOD_ID,BATCH_RECORD.INTELLIGENT_FLAG,BATCH_RECORD.HIERARCHY_FLAG,
    	BATCH_RECORD.SALESREP_OPTION,BATCH_RECORD.CONCURRENT_FLAG,BATCH_RECORD.LOG_NAME,BATCH_RECORD.STATUS,
    	BATCH_RECORD.LOGICAL_BATCH_ID,BATCH_RECORD.FORECAST_FLAG,BATCH_RECORD.ATTRIBUTE_CATEGORY,BATCH_RECORD.ATTRIBUTE1,
    	BATCH_RECORD.ATTRIBUTE2,BATCH_RECORD.ATTRIBUTE3,BATCH_RECORD.ATTRIBUTE4,BATCH_RECORD.ATTRIBUTE5,
    	BATCH_RECORD.ATTRIBUTE6,BATCH_RECORD.ATTRIBUTE7,BATCH_RECORD.ATTRIBUTE8,BATCH_RECORD.ATTRIBUTE9,
    	BATCH_RECORD.ATTRIBUTE10,BATCH_RECORD.ATTRIBUTE11,BATCH_RECORD.ATTRIBUTE12,BATCH_RECORD.ATTRIBUTE13,
    	BATCH_RECORD.ATTRIBUTE14,BATCH_RECORD.ATTRIBUTE15,BATCH_RECORD.START_DATE,BATCH_RECORD.END_DATE,
    	BATCH_RECORD.CALC_TYPE,BATCH_RECORD.INTERVAL_TYPE_ID,BATCH_RECORD.LEDGER_JE_BATCH_ID,
    	BATCH_RECORD.PROCESS_AUDIT_ID,fnd_global.user_id,sysdate,
    	BATCH_RECORD.OBJECT_VERSION_NUMBER,BATCH_RECORD.SECURITY_GROUP_ID);

Line: 1223

            		insert into cn_calc_submission_entries(ORG_ID,CALC_SUB_ENTRY_ID,CALC_SUB_BATCH_ID,SALESREP_ID,ATTRIBUTE_CATEGORY,
            		ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,
            		ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,
            		CREATION_DATE,SECURITY_GROUP_ID,HIERARCHY_FLAG)
            		values
            		(calc_entries.ORG_ID,CN_CALC_SUBMISSION_ENTRIES_S1.nextval,seq_batchid,calc_entries.SALESREP_ID,
            		calc_entries.ATTRIBUTE_CATEGORY,calc_entries.ATTRIBUTE1,calc_entries.ATTRIBUTE2,calc_entries.ATTRIBUTE3,
            		calc_entries.ATTRIBUTE4,calc_entries.ATTRIBUTE5,calc_entries.ATTRIBUTE6,calc_entries.ATTRIBUTE7,
            		calc_entries.ATTRIBUTE8,calc_entries.ATTRIBUTE9,calc_entries.ATTRIBUTE10,calc_entries.ATTRIBUTE11,
            		calc_entries.ATTRIBUTE12,calc_entries.ATTRIBUTE13,calc_entries.ATTRIBUTE14,calc_entries.ATTRIBUTE15,
           		fnd_global.user_id,sysdate,calc_entries.SECURITY_GROUP_ID,calc_entries.HIERARCHY_FLAG);

Line: 1245

            		insert into cn_calc_sub_quotas
            		(ORG_ID,CALC_SUB_QUOTA_ID,CALC_SUB_BATCH_ID,QUOTA_ID,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,
            		ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,
            		ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,CREATION_DATE,SECURITY_GROUP_ID)
            		values
            		(bonus_entries.ORG_ID,CN_CALC_SUB_QUOTAS_S.nextval,seq_batchid,bonus_entries.QUOTA_ID,
            		bonus_entries.ATTRIBUTE_CATEGORY,bonus_entries.ATTRIBUTE1,bonus_entries.ATTRIBUTE2,
            		bonus_entries.ATTRIBUTE3,bonus_entries.ATTRIBUTE4,bonus_entries.ATTRIBUTE5,bonus_entries.ATTRIBUTE6,
            		bonus_entries.ATTRIBUTE7,bonus_entries.ATTRIBUTE8,bonus_entries.ATTRIBUTE9,bonus_entries.ATTRIBUTE10,
            		bonus_entries.ATTRIBUTE11,bonus_entries.ATTRIBUTE12,bonus_entries.ATTRIBUTE13,bonus_entries.ATTRIBUTE14,
            		bonus_entries.ATTRIBUTE15,fnd_global.user_id,sysdate,bonus_entries.SECURITY_GROUP_ID);