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 4559: FROM as_sf_ptr_v

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

Line 5169: FROM as_sf_ptr_v

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