APPS.AS_OPP_SALES_CREDIT_PVT dependencies on AS_SALESFORCE_V

Line 2712: FROM as_salesforce_v

2708: IS
2709:
2710: CURSOR C_Salesforce_Id_Exists (c_Salesforce_Id NUMBER) IS
2711: SELECT 'X'
2712: FROM as_salesforce_v
2713: WHERE salesforce_id = c_Salesforce_Id;
2714:
2715: l_val VARCHAR2(1);
2716: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 2776: FROM as_salesforce_v

2772: IS
2773:
2774: CURSOR C_PERSON_ID_Exists(c_PERSON_ID NUMBER) IS
2775: SELECT 'X'
2776: FROM as_salesforce_v
2777: WHERE EMPLOYEE_PERSON_ID = c_PERSON_ID;
2778:
2779: l_val VARCHAR2(1);
2780: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 2912: FROM as_salesforce_v

2908: IS
2909:
2910: CURSOR C_PARTNER_CUSTOMER_ID_Exists(c_PARTNER_CUSTOMER_ID NUMBER) IS
2911: SELECT 'X'
2912: FROM as_salesforce_v
2913: WHERE PARTNER_CUSTOMER_ID = c_PARTNER_CUSTOMER_ID;
2914:
2915: l_val VARCHAR2(1);
2916: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 2968: FROM as_salesforce_v

2964: IS
2965:
2966: CURSOR C_PARTNER_ADDRESS_ID_Exists(c_PARTNER_ADDRESS_ID NUMBER) IS
2967: SELECT 'X'
2968: FROM as_salesforce_v
2969: WHERE PARTNER_ADDRESS_ID = c_PARTNER_ADDRESS_ID;
2970:
2971: l_val VARCHAR2(1);
2972: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 3116: FROM as_salesforce_v

3112:
3113: CURSOR C_Salesforce_Partner_Exists (X_Salesforce_Id NUMBER,
3114: X_Partner_Customer_Id NUMBER) IS
3115: SELECT 'X'
3116: FROM as_salesforce_v
3117: WHERE ((type = 'PARTNER' and partner_customer_id = X_Partner_Customer_Id)
3118: or (type = 'PARTY' and partner_contact_id = X_Partner_Customer_Id))
3119: AND salesforce_id = X_Salesforce_Id;
3120: