APPS.QOT_DEFAULT_PVT dependencies on JTF_RS_SALESREPS_MO_V

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)

Line 1737: FROM JTF_RS_SALESREPS_MO_V

1733: AND SYSDATE BETWEEN NVL(start_date_active,sysdate) AND NVL(end_date_active, SYSDATE);
1734:
1735: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS
1736: SELECT 'Y'
1737: FROM JTF_RS_SALESREPS_MO_V
1738: WHERE resource_id = l_res_id
1739: AND NVL(status,'A') = 'A'
1740: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
1741: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);

Line 1745: FROM JTF_RS_SALESREPS_MO_V

1741: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
1742:
1743: CURSOR C_Get_Res_From_Srep (l_Srep VARCHAR2) IS
1744: SELECT Resource_Id
1745: FROM JTF_RS_SALESREPS_MO_V
1746: WHERE salesrep_number = l_Srep
1747: AND NVL(status,'A') = 'A'
1748: AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
1749: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);