DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on AS_SF_PTR_V

Line 24: -- 08-30-00 FFANG Use AS_SF_PTR_V instead of pv_partners_v when validating

20: -- 08-21-00 FFANG Add: set default currency code
21: -- 08-22-00 FFANG Remove: Validate_Status_DecisionDate
22: -- 08-23-00 FFANG Add Set_opp_default_values to update_opp_header
23: -- 08-24-00 FFANG Modify OTHERS exception hanlder calling arguments.
24: -- 08-30-00 FFANG Use AS_SF_PTR_V instead of pv_partners_v when validating
25: -- incumbent_partner_party_id and
26: -- incumbent_partner_resource_id
27: -- 09-08-00 FFANG For bug 1397389, checking profile
28: -- AS_CUSTOMER_ADDRESS_REQUIRED to see if address_id is

Line 4560: FROM as_sf_ptr_v

4556: )
4557: IS
4558: CURSOR C_INC_PRTN_PARTY_ID_Exist (c_inc_parn_party_id NUMBER) IS
4559: SELECT 'X'
4560: FROM as_sf_ptr_v
4561: WHERE partner_customer_id = c_inc_parn_party_id;
4562: -- FROM pv_partners_v
4563: -- WHERE partner_id = c_inc_parn_party_id;
4564: l_val VARCHAR2(1);

Line 5170: FROM as_sf_ptr_v

5166: )
5167: IS
5168: CURSOR C_RESOURCE_ID_Exists (c_INC_PARTNER_RESOURCE_ID VARCHAR2) IS
5169: SELECT 'X'
5170: FROM as_sf_ptr_v
5171: WHERE SALESFORCE_ID = c_INC_PARTNER_RESOURCE_ID;
5172: --FROM jtf_rs_resource_extns
5173: --WHERE RESOURCE_ID = c_INC_PARTNER_RESOURCE_ID;
5174: l_val VARCHAR2(1);