DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on JTF_RS_SRP_VL

Line 4461: FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j

4457:
4458: -- 9/23/02: new cursor to check for salesrep
4459: Cursor c_getResourceInfo IS
4460: SELECT j.resource_id
4461: FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j
4462: WHERE j.user_id = l_user_id
4463: AND j.resource_id = srp.resource_id
4464: AND srp.status = 'A'
4465: AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)