APPS.AS_OPP_COPY_PVT dependencies on AS_LEADS_ALL

Line 86: FROM AS_LEADS_ALL

82: l_insert BOOLEAN;
83:
84: CURSOR c_customer(c_lead_id NUMBER) IS
85: SELECT customer_id
86: FROM AS_LEADS_ALL
87: WHERE lead_id = c_lead_id;
88:
89: CURSOR c_header(c_lead_id NUMBER) IS
90: SELECT *

Line 91: FROM AS_LEADS_ALL

87: WHERE lead_id = c_lead_id;
88:
89: CURSOR c_header(c_lead_id NUMBER) IS
90: SELECT *
91: FROM AS_LEADS_ALL
92: WHERE lead_id = c_lead_id;
93:
94: -- If create sales team for sales credit flag is set to 'N', return
95: -- all records from AS_ACCESSES_ALL for that lead_id but if the flag

Line 854: UPDATE AS_LEADS_ALL

850: END IF; -- p_copy_sales_credits
851:
852: -- Update Header with forecast amount since create_opp_header
853: -- defaults it to null
854: UPDATE AS_LEADS_ALL
855: SET TOTAL_REVENUE_OPP_FORECAST_AMT = l_TOT_REVENUE_OPP_FORECAST_AMT
856: WHERE lead_id = l_Header_rec.lead_id;
857:
858: