APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on AS_STATUSES_B

Line 2596: FROM as_statuses_b

2592: WHERE resource_id = c_resource_id;
2593:
2594: CURSOR C_Get_Open_Status_Flag(C_Status_Code VARCHAR2) IS
2595: SELECT opp_open_status_flag
2596: FROM as_statuses_b
2597: WHERE status_code = c_status_code
2598: AND lead_flag = 'Y';
2599:
2600: -- Below two cursors added for bug 7654339

Line 3141: FROM as_statuses_b sta, as_sales_leads lead

3137: WHERE resource_id = c_resource_id;
3138:
3139: CURSOR C_Get_Open_Status_Flag(c_sales_lead_id NUMBER) IS
3140: SELECT lead.status_code, sta.opp_open_status_flag
3141: FROM as_statuses_b sta, as_sales_leads lead
3142: WHERE lead.sales_lead_id = c_sales_lead_id
3143: AND lead.status_code = sta.status_code
3144: AND sta.lead_flag = 'Y';
3145: