APPS.QOT_DEFAULT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 1586: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns_vl j

1582: AND jrgm.resource_id = x_resource_id;
1583:
1584: Cursor C_salesrep (X_User_Id Number) IS
1585: SELECT j.resource_id
1586: FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns_vl j
1587: WHERE j.user_id = X_User_Id
1588: AND j.resource_id = srp.resource_id
1589: AND nvl(srp.status,'A') = 'A'
1590: AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)

Line 1717: FROM JTF_RS_RESOURCE_EXTNS

1713: IS
1714:
1715: CURSOR C_Get_Creator_Res (l_user_id NUMBER) IS
1716: SELECT resource_id
1717: FROM JTF_RS_RESOURCE_EXTNS
1718: WHERE user_id = l_user_id
1719: AND SYSDATE BETWEEN NVL(start_date_active,sysdate) AND NVL(end_date_active, SYSDATE);
1720:
1721: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS