APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on AS_STATUSES_B

Line 2593: FROM as_statuses_b

2589: WHERE resource_id = c_resource_id;
2590:
2591: CURSOR C_Get_Open_Status_Flag(C_Status_Code VARCHAR2) IS
2592: SELECT opp_open_status_flag
2593: FROM as_statuses_b
2594: WHERE status_code = c_status_code
2595: AND lead_flag = 'Y';
2596: BEGIN
2597: -- Standard Start of API savepoint

Line 3087: FROM as_statuses_b sta, as_sales_leads lead

3083: WHERE resource_id = c_resource_id;
3084:
3085: CURSOR C_Get_Open_Status_Flag(c_sales_lead_id NUMBER) IS
3086: SELECT lead.status_code, sta.opp_open_status_flag
3087: FROM as_statuses_b sta, as_sales_leads lead
3088: WHERE lead.sales_lead_id = c_sales_lead_id
3089: AND lead.status_code = sta.status_code
3090: AND sta.lead_flag = 'Y';
3091: