APPS.PA_PROJECT_REQUEST_PVT dependencies on AS_LEADS_ALL

Line 514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;

510: -- added for Bug Fix: 4537865
511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;
512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;
513:
514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;
515: l_lead_description AS_LEADS_ALL.description%TYPE;
516: l_request_type_meaning FND_LOOKUPS.meaning%TYPE;
517:
518: -- Cursor to get the source lead_id for the passed in project request.

Line 515: l_lead_description AS_LEADS_ALL.description%TYPE;

511: l_person_role_type_tab PA_PLSQL_DATATYPES.Char250TabTyp;
512: l_key_member_tab PA_PLSQL_DATATYPES.Char250TabTyp;
513:
514: l_lead_number AS_LEADS_ALL.lead_number%TYPE;
515: l_lead_description AS_LEADS_ALL.description%TYPE;
516: l_request_type_meaning FND_LOOKUPS.meaning%TYPE;
517:
518: -- Cursor to get the source lead_id for the passed in project request.
519:

Line 534: FROM as_leads_all l, as_forecast_prob_all_vl p

530: -- 2418549: Should not default quick entry is the probability is disabled.
531: CURSOR cur_probability (p_lead_id NUMBER ) IS
532: SELECT
533: l.win_probability
534: FROM as_leads_all l, as_forecast_prob_all_vl p
535: WHERE l.lead_id = p_lead_id
536: AND l.win_probability = p.probability_value
537: AND (p.end_date_active IS NULL OR p.end_date_active >= SYSDATE);
538:

Line 597: FROM as_leads_all

593:
594: -- Cursor to get lead number and description for an opportunity
595: CURSOR cur_get_lead_info (p_lead_id NUMBER) IS
596: SELECT lead_number, description
597: FROM as_leads_all
598: WHERE lead_id = p_lead_id;
599:
600: BEGIN
601: x_return_status := FND_API.G_RET_STS_SUCCESS;