2584: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
2585:
2586: CURSOR C_Get_Person(C_Resource_Id NUMBER) IS
2587: SELECT source_id
2588: FROM jtf_rs_resource_extns
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
3078: AND acc.owner_flag = 'Y';
3079:
3080: CURSOR C_Get_Person(C_Resource_Id NUMBER) IS
3081: SELECT source_id
3082: FROM jtf_rs_resource_extns
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