APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 2591: FROM jtf_rs_resource_extns

2587: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
2588:
2589: CURSOR C_Get_Person(C_Resource_Id NUMBER) IS
2590: SELECT source_id
2591: FROM jtf_rs_resource_extns
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

Line 3136: FROM jtf_rs_resource_extns

3132: AND acc.owner_flag = 'Y';
3133:
3134: CURSOR C_Get_Person(C_Resource_Id NUMBER) IS
3135: SELECT source_id
3136: FROM jtf_rs_resource_extns
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