APPS.AS_SALES_LEADS_PVT dependencies on AS_SF_PTR_V

Line 99: -- But as_sf_ptr_v and as_opportunity_details_v haven't

95: -- 01/13/2001 FFANG For bug 1582747, when calling Get_CurrentUser,
96: -- pass p_identity_salesforce_id into p_salesforce_id
97: -- instead of passing NULL
98: -- 02/02/2001 FFANG Instead of using views, use base tables.
99: -- But as_sf_ptr_v and as_opportunity_details_v haven't
100: -- been replaced yet.
101: -- 02/06/2001 FFANG For bug 1628894, check if opp contact has already
102: -- existed before calling create_opp_contacts
103: -- 12/17/2002 SOLIN Populate column lead_rank_ind:

Line 2087: FROM as_sf_ptr_v

2083: )
2084: IS
2085: CURSOR C_INC_PRTN_PARTY_ID_Exist (c_inc_parn_party_id NUMBER) IS
2086: SELECT 'X'
2087: FROM as_sf_ptr_v
2088: WHERE partner_customer_id = c_inc_parn_party_id;
2089: l_val VARCHAR2(1);
2090:
2091: BEGIN

Line 2152: FROM as_sf_ptr_v

2148: IS
2149:
2150: CURSOR C_RESOURCE_ID_Exists (c_INC_PARTNER_RESOURCE_ID VARCHAR2) IS
2151: SELECT 'X'
2152: FROM as_sf_ptr_v
2153: WHERE SALESFORCE_ID = c_INC_PARTNER_RESOURCE_ID;
2154: --FROM jtf_rs_resource_extns
2155: --WHERE RESOURCE_ID = c_INC_PARTNER_RESOURCE_ID;
2156: l_val VARCHAR2(1);

Line 2171: -- INCUMBENT_PARTNER_RESOURCE_ID should exist in as_sf_ptr_v

2167:
2168: IF (p_INC_PARTNER_RESOURCE_ID is NOT NULL) and
2169: (p_INC_PARTNER_RESOURCE_ID <> FND_API.G_MISS_NUM)
2170: THEN
2171: -- INCUMBENT_PARTNER_RESOURCE_ID should exist in as_sf_ptr_v
2172: OPEN C_RESOURCE_ID_Exists (p_INC_PARTNER_RESOURCE_ID);
2173: FETCH C_RESOURCE_ID_Exists into l_val;
2174:
2175: IF C_RESOURCE_ID_Exists%NOTFOUND THEN