APPS.AS_OPP_LINE_PVT dependencies on AS_LEADS

Line 53: UPDATE as_leads_all

49: FETCH C_renue_opp_forst_tot into l_tot_revenue_opp_forecast_amt;
50: CLOSE C_renue_opp_forst_tot;
51: -- End Added for ASNB
52:
53: UPDATE as_leads_all
54: SET total_amount = nvl(l_line_total, 0),
55: TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_revenue_opp_forecast_amt, -- Added for ASNB
56: last_update_date = SYSDATE,
57: last_updated_by = FND_GLOBAL.USER_ID,

Line 173: From as_leads_all lead, as_statuses_vl status

169: Select lead.win_probability, status.win_loss_indicator,
170: status.forecast_rollup_flag
171: Into l_win_probability, l_win_loss_indicator,
172: l_forecast_rollup_flag
173: From as_leads_all lead, as_statuses_vl status
174: Where lead_id = p_lead_id
175: And lead.status = status.status_code(+);
176: IF l_line_amount_old <> 0 THEN
177: FOR sc_rec In C_sales_credits(p_lead_line_id) LOOP

Line 727: FROM AS_LEADS

723:
724: -- solin, for bug 1554330
725: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
726: SELECT FREEZE_FLAG
727: FROM AS_LEADS
728: WHERE LEAD_ID = c_LEAD_ID;
729:
730: CURSOR c_decision_date(c_lead_id NUMBER) IS
731: select decision_date

Line 732: from as_leads_all

728: WHERE LEAD_ID = c_LEAD_ID;
729:
730: CURSOR c_decision_date(c_lead_id NUMBER) IS
731: select decision_date
732: from as_leads_all
733: where lead_id = c_lead_id;
734:
735: CURSOR c_lead_org_id(p_lead_id NUMBER) IS
736: select org_id

Line 737: from as_leads_all

733: where lead_id = c_lead_id;
734:
735: CURSOR c_lead_org_id(p_lead_id NUMBER) IS
736: select org_id
737: from as_leads_all
738: where lead_id = p_lead_id;
739:
740:
741: CURSOR c_campaign_id(c_LEAD_ID NUMBER) IS

Line 1484: FROM AS_LEADS

1480:
1481: -- solin, for bug 1554330
1482: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
1483: SELECT FREEZE_FLAG
1484: FROM AS_LEADS
1485: WHERE LEAD_ID = c_LEAD_ID;
1486:
1487: CURSOR c_decision_date(c_lead_id NUMBER) IS
1488: select decision_date

Line 1489: from as_leads_all

1485: WHERE LEAD_ID = c_LEAD_ID;
1486:
1487: CURSOR c_decision_date(c_lead_id NUMBER) IS
1488: select decision_date
1489: from as_leads_all
1490: where lead_id = c_lead_id;
1491:
1492: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_lines';
1493: l_api_version_number CONSTANT NUMBER := 2.0;

Line 2015: FROM AS_LEADS

2011:
2012: -- solin, for bug 1554330
2013: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
2014: SELECT FREEZE_FLAG
2015: FROM AS_LEADS
2016: WHERE LEAD_ID = c_LEAD_ID;
2017:
2018: l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_lines';
2019: l_api_version_number CONSTANT NUMBER := 2.0;

Line 2481: FROM as_leads

2477: IS
2478:
2479: CURSOR C_Lead_Id_Exists (c_Lead_Id NUMBER) IS
2480: SELECT 'X'
2481: FROM as_leads
2482: WHERE lead_id = c_Lead_Id;
2483:
2484: l_val VARCHAR2(1);
2485: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);