DBA Data[Home] [Help]

APPS.AS_SALES_MEMBER_PUB dependencies on AS_SALESFORCE_V

Line 53: from AS_SALESFORCE_V force

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';

Line 193: From AS_SALESFORCE_V

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