DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 4455: from jtf_rs_resource_extns

4451:
4452: -- 9/23/02: we're using the next cursor
4453: CURSOR c_getResourceInfo_orig IS
4454: select resource_id
4455: from jtf_rs_resource_extns
4456: where user_id = l_user_id;
4457:
4458: -- 9/23/02: new cursor to check for salesrep
4459: Cursor c_getResourceInfo IS

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)