49: --,force.Sales_Group_id
50: ,force.Partner_address_id
51: ,force.Partner_customer_id
52: --,force.Partner_contact_id
53: from AS_SALESFORCE_V force
54: where partner_customer_id = p_partner_customer_id AND
55: partner_address_id = p_partner_address_id;
56:
57: l_api_name CONSTANT VARCHAR2(30) := 'Convert_Partner_to_ID';
189: Select salesforce_id, type, start_date_active, end_date_active, employee_person_id,
190: -- sales_group_id,
191: partner_customer_id, partner_address_id
192: --partner_contact_id
193: From AS_SALESFORCE_V
194: Where salesforce_id = p_salesforce_id;
195:
196: Cursor C_GetPersonInfo(p_person_id Number) IS
197: Select last_name, first_name, full_name, email_address