APPS.ASO_QUOTE_HEADERS_PVT dependencies on JTF_RS_SRP_VL

Line 358: SELECT resource_id FROM JTF_RS_SRP_VL

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

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

13732: l_api_version_number CONSTANT NUMBER := 1.0;
13733:
13734: Cursor C_salesrep (X_User_Id NUMBER) IS
13735: SELECT j.resource_id
13736: /* FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j */ --Commented Code Yogeshwar (MOAC)
13737: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns j --New Code Yogeshwar (MOAC)
13738: WHERE j.user_id = X_User_Id
13739: AND j.resource_id = srp.resource_id
13740: AND srp.status = 'A'