DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on AS_SALESFORCE_V

Line 678: from as_salesforce_v

674: l_default_address_profile VARCHAR2(1) := FND_PROFILE.VALUE ('AS_OPP_DEFAULT_ADDRESS');
675:
676: CURSOR get_person_id_csr(c_salesforce_id NUMBER) is
677: select employee_person_id
678: from as_salesforce_v
679: where salesforce_id = c_salesforce_id;
680:
681: /* ffang 091100 for bug 1401095
682: CURSOR c_salesgroup_id(p_resource_id number) IS

Line 1462: from as_salesforce_v

1458: ( p_status_profile = 'FORECASTED' and st.OPP_OPEN_STATUS_FLAG <> 'Y') );
1459:
1460: CURSOR get_person_id_csr(c_salesforce_id NUMBER) is
1461: select employee_person_id
1462: from as_salesforce_v
1463: where salesforce_id = c_salesforce_id;
1464:
1465: CURSOR c_sales_credit_amount (p_lead_id as_leads_all.lead_id%type) IS
1466: Select sales_credit_id, credit_type_id,credit_amount