DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on AS_SALES_LEAD_OPPORTUNITY

Line 2261: SELECT * FROM as_sales_lead_opportunity

2257: HAVING (sum(sc.credit_percent) <> 100
2258: OR sum(sc.credit_amount) <> max(ll.total_amount));
2259:
2260: CURSOR c_lead_opp_links(p_lead_id NUMBER) IS
2261: SELECT * FROM as_sales_lead_opportunity
2262: WHERE opportunity_id = p_lead_id;
2263:
2264: CURSOR c_get_access_id IS
2265: SELECT AS_ACCESSES_S.NEXTVAL