APPS.ASO_QUOTE_HEADERS_PVT dependencies on JTF_RS_SRP_VL

Line 357: SELECT resource_id FROM JTF_RS_SRP_VL

353: WHERE price_list_id = c_price_list_id;
354:
355:
356: CURSOR c_resource IS
357: SELECT resource_id FROM JTF_RS_SRP_VL
358: WHERE person_id = p_qte_header_rec.employee_person_id;
359:
360: -- Change START
361: -- Release 12 MOAC Changes : Bug 4500739

Line 12665: /* FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j */ --Commented Code Yogeshwar (MOAC)

12661: l_api_version_number CONSTANT NUMBER := 1.0;
12662:
12663: Cursor C_salesrep (X_User_Id NUMBER) IS
12664: SELECT j.resource_id
12665: /* FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j */ --Commented Code Yogeshwar (MOAC)
12666: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns j --New Code Yogeshwar (MOAC)
12667: WHERE j.user_id = X_User_Id
12668: AND j.resource_id = srp.resource_id
12669: AND srp.status = 'A'