DBA Data[Home] [Help]

APPS.IBE_QUOTE_MISC_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 4323: from jtf_rs_resource_extns

4319:
4320: -- 9/23/02: we're using the next cursor
4321: CURSOR c_getResourceInfo_orig IS
4322: select resource_id
4323: from jtf_rs_resource_extns
4324: where user_id = l_user_id;
4325:
4326: -- 9/23/02: new cursor to check for salesrep
4327: Cursor c_getResourceInfo IS

Line 4329: FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j

4325:
4326: -- 9/23/02: new cursor to check for salesrep
4327: Cursor c_getResourceInfo IS
4328: SELECT j.resource_id
4329: FROM jtf_rs_srp_vl srp, jtf_rs_resource_extns j
4330: WHERE j.user_id = l_user_id
4331: AND j.resource_id = srp.resource_id
4332: AND srp.status = 'A'
4333: AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)