APPS.AS_OPP_SALES_CREDIT_PVT dependencies on AS_LEADS

Line 173: from as_leads

169: IS
170:
171: CURSOR lead_customer( p_lead_id NUMBER) IS
172: select customer_id, address_id
173: from as_leads
174: where lead_id = p_lead_id;
175:
176: CURSOR C_Person_Id(p_resource_id NUMBER) IS
177: SELECT source_id

Line 192: FROM AS_LEADS

188:
189: -- solin, for bug 1554330
190: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
191: SELECT FREEZE_FLAG
192: FROM AS_LEADS
193: WHERE LEAD_ID = c_LEAD_ID;
194: /*
195: Modified for bug# 4168544.
196: Change the select clause so that it returns team_leader_flag,last_update_date,access_id

Line 516: From as_leads_all lead, as_statuses_vl status

512: Select lead.win_probability, status.win_loss_indicator,
513: status.forecast_rollup_flag
514: Into l_win_probability, l_win_loss_indicator,
515: l_forecast_rollup_flag
516: From as_leads_all lead, as_statuses_vl status
517: Where lead_id = l_sales_credit_rec.LEAD_ID
518: And lead.status = status.status_code(+);
519:
520: l_temp_bool := Apply_Forecast_Defaults(l_win_probability,

Line 891: FROM AS_LEADS

887:
888: -- solin, for bug 1554330
889: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
890: SELECT FREEZE_FLAG
891: FROM AS_LEADS
892: WHERE LEAD_ID = c_LEAD_ID;
893:
894: CURSOR lead_customer( p_lead_id NUMBER) IS
895: select customer_id, address_id

Line 896: from as_leads

892: WHERE LEAD_ID = c_LEAD_ID;
893:
894: CURSOR lead_customer( p_lead_id NUMBER) IS
895: select customer_id, address_id
896: from as_leads
897: where lead_id = p_lead_id;
898: /*
899: Modified for bug# 4168544.
900: Change the select clause so that it returns team_leader_flag,last_update_date,access_id

Line 1270: From as_leads_all lead, as_statuses_vl status

1266: Select lead.win_probability, status.win_loss_indicator,
1267: status.forecast_rollup_flag
1268: Into l_win_probability, l_win_loss_indicator,
1269: l_forecast_rollup_flag
1270: From as_leads_all lead, as_statuses_vl status
1271: Where lead_id = l_sales_credit_rec.LEAD_ID
1272: And lead.status = status.status_code(+);
1273:
1274: IF l_sales_credit_rec.CREDIT_TYPE_ID = l_forecast_credit_type_id THEN

Line 1700: FROM AS_LEADS

1696:
1697: -- solin, for bug 1554330
1698: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
1699: SELECT FREEZE_FLAG
1700: FROM AS_LEADS
1701: WHERE LEAD_ID = c_LEAD_ID;
1702:
1703: l_api_name CONSTANT VARCHAR2(30) := 'modify_sales_credits';
1704: l_api_version_number CONSTANT NUMBER := 2.0;

Line 2226: FROM AS_LEADS

2222: IS
2223: -- solin, for bug 1554330
2224: CURSOR c_get_opp_freeze_flag(c_LEAD_ID NUMBER) IS
2225: SELECT FREEZE_FLAG
2226: FROM AS_LEADS
2227: WHERE LEAD_ID = c_LEAD_ID;
2228:
2229: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_credits';
2230: l_api_version_number CONSTANT NUMBER := 2.0;

Line 2583: FROM as_leads

2579: IS
2580:
2581: CURSOR C_Lead_Id_Exists (c_Lead_Id NUMBER) IS
2582: SELECT 'X'
2583: FROM as_leads
2584: WHERE lead_id = c_Lead_Id;
2585:
2586: l_val VARCHAR2(1);
2587: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);