APPS.ASO_QUOTE_HEADERS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

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'

Line 13737: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns j --New Code Yogeshwar (MOAC)

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'
13741: AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)