APPS.AS_SALES_MEMBER_PUB SQL Statements

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

Line: 44

        Select  force.salesforce_id
               ,force.type
               ,force.start_date_active
               ,force.end_date_active
               ,force.Employee_Person_id
               --,force.Sales_Group_id
               ,force.Partner_address_id
               ,force.Partner_customer_id
               --,force.Partner_contact_id
        from AS_SALESFORCE_V force
        where partner_customer_id = p_partner_customer_id AND
              partner_address_id = p_partner_address_id;

Line: 189

        Select salesforce_id, type, start_date_active, end_date_active, employee_person_id,
              -- sales_group_id,
			partner_customer_id, partner_address_id
               --partner_contact_id
        From   AS_SALESFORCE_V
        Where  salesforce_id = p_salesforce_id;

Line: 197

        Select last_name, first_name, full_name, email_address
        From per_people_f
        Where person_id = p_person_id;