APPS.QOT_DEFAULT_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 1600: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns_vl j

1596: AND jrgm.resource_id = x_resource_id;
1597:
1598: Cursor C_salesrep (X_User_Id Number) IS
1599: SELECT j.resource_id
1600: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns_vl j
1601: WHERE j.user_id = X_User_Id
1602: AND j.resource_id = srp.resource_id
1603: AND nvl(srp.status,'A') = 'A'
1604: AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)