APPS.AST_ASN_INTEROP SQL Statements

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

Line: 23

       SELECT salesforce_id,salesgroup_id,lead_line_id,person_id,credit_percent
         FROM as_sales_credits
	WHERE lead_id = p_lead_id;

Line: 41

        SELECT PERSON_ID,SALESFORCE_ID,SALES_GROUP_ID
          INTO l_person_id,l_salesforce_id,l_sales_group_id
	  FROM AS_ACCESSES_ALL
	 WHERE LEAD_ID    = p_lead_id
	   AND OWNER_FLAG = 'Y';

Line: 59

		UPDATE  AS_SALES_CREDITS
		   SET	SALESFORCE_ID    =  l_salesforce_id,
			SALESGROUP_ID    =  l_sales_group_id,
			PERSON_ID        =  l_person_id,
			LAST_UPDATE_DATE = SYSDATE
		WHERE   LEAD_ID          =  P_LEAD_ID
		  AND   (SALESFORCE_ID   <>  l_salesforce_id
		  or   nvl(SALESGROUP_ID,0)   <>  nvl(l_sales_group_id,0))
		  AND  NVL(DEFAULTED_FROM_OWNER_FLAG,'N') = 'Y';

Line: 69

		UPDATE	AS_ACCESSES_ALL acc
		SET	object_version_number =  nvl(object_version_number,0) + 1,
			acc.team_leader_flag = 'Y'
		WHERE	acc.LEAD_ID = p_lead_id
		and	team_leader_flag = 'N'
		and	exists
		(
			select 	'x'
			from 	as_sales_credits
			where 	lead_id=acc.lead_id
			and   	salesforce_id=acc.salesforce_id
			and 	salesgroup_id =acc.sales_group_id
		);

Line: 133

  select SALES_METHODOLOGY_ID, SALES_STAGE_ID
  from as_sales_leads
  where sales_lead_id = p_sales_lead_id;

Line: 138

   select applicability
     from as_sales_stages_all_vl
    where sales_stage_id = p_sales_stage_id;

Line: 143

    SELECT  stage.sales_stage_id
      FROM  as_sales_stages_all_vl stage, as_sales_meth_stage_map map1
     WHERE  stage.sales_stage_id = map1.sales_stage_id
       AND  nvl(stage.applicability,'BOTH') in ('OPPORTUNITY', 'BOTH')
       AND  nvl(stage.ENABLED_FLAG,'Y') = 'Y'
       AND  trunc(sysdate) between trunc(nvl(START_DATE_ACTIVE,sysdate))
       AND  trunc(nvl(END_DATE_ACTIVE,sysdate))
       AND  map1.sales_methodology_id  =  p_sales_method_id
  ORDER BY  STAGE_SEQUENCE;

Line: 158

  l_last_update_date date;

Line: 247

  select last_update_date
  from as_leads_all
  where lead_id = p_lead_id;

Line: 255

  l_last_update_date date;

Line: 263

	FETCH c_opp into l_last_update_date;

Line: 272

	header_rec.last_update_date     := l_last_update_date;

Line: 275

                              'Before calling Update opp Header Lead id : ' || p_lead_id ||' Sales Force id :'|| P_Identity_Salesforce_Id ||
			      ' Sales Group Id :' || P_identity_salesgroup_id  ||
			      ' Sales Methodology id :'||p_sales_methodology_id );

Line: 279

		AS_OPPORTUNITY_PUB.Update_Opp_header
		(
		    p_api_version_number        => p_api_version_number,
		    p_init_msg_list             => p_init_msg_list,
		    p_commit                    => p_commit,
		    p_validation_level          => p_validation_level,
		    p_header_rec                => header_rec,
		    p_check_access_flag         => 'Y',
		    p_admin_flag                => p_admin_flag,
		    p_admin_group_id            => P_Admin_Group_Id,
		    p_identity_salesforce_id    => P_Identity_Salesforce_Id,
		    p_profile_tbl               => P_profile_tbl,
		    x_return_status             => x_return_status,
                    p_partner_cont_party_id     => NULL,
		    x_msg_count                 => x_msg_count,
		    x_msg_data                  => x_msg_data,
		    x_lead_id                   => l_lead_id
		);