APPS.QOT_DEFAULT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

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 1731: FROM JTF_RS_RESOURCE_EXTNS

1727: IS
1728:
1729: CURSOR C_Get_Creator_Res (l_user_id NUMBER) IS
1730: SELECT resource_id
1731: FROM JTF_RS_RESOURCE_EXTNS
1732: WHERE user_id = l_user_id
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