DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on AS_OPPORTUNITIES_V

Line 743: FROM AS_OPPORTUNITIES_V

739:
740:
741: CURSOR c_campaign_id(c_LEAD_ID NUMBER) IS
742: SELECT SOURCE_PROMOTION_ID
743: FROM AS_OPPORTUNITIES_V
744: WHERE LEAD_ID = c_LEAD_ID;
745:
746: CURSOR c_offer_id(c_LEAD_ID NUMBER) IS
747: SELECT OFFER_ID

Line 748: FROM AS_OPPORTUNITIES_V

744: WHERE LEAD_ID = c_LEAD_ID;
745:
746: CURSOR c_offer_id(c_LEAD_ID NUMBER) IS
747: SELECT OFFER_ID
748: FROM AS_OPPORTUNITIES_V
749: WHERE LEAD_ID = c_LEAD_ID;
750:
751: CURSOR c_valid_group(p_salesforce_id NUMBER, p_sales_group_id NUMBER) is
752: select 'Y'