APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_SALESREPS

Line 2347: FROM jtf_rs_salesreps

2343: l_resource_id IN NUMBER )
2344: IS
2345: SELECT min(start_date_active),
2346: max(end_date_active)
2347: FROM jtf_rs_salesreps
2348: WHERE resource_id = l_resource_id
2349: AND end_date_active is not null;
2350:
2351:

Line 2356: FROM jtf_rs_salesreps

2352: CURSOR c_salesrep_dates_sec(
2353: l_resource_id IN NUMBER )
2354: IS
2355: SELECT min(start_date_active)
2356: FROM jtf_rs_salesreps
2357: WHERE resource_id = l_resource_id
2358: AND end_date_active is null;
2359:
2360: CURSOR c_validate_user_id(

Line 4282: FROM jtf_rs_salesreps

4278: l_resource_id IN NUMBER )
4279: IS
4280: SELECT min(start_date_active),
4281: max(end_date_active)
4282: FROM jtf_rs_salesreps
4283: WHERE resource_id = l_resource_id
4284: AND end_date_active is not null;
4285:
4286:

Line 4291: FROM jtf_rs_salesreps

4287: CURSOR c_salesrep_dates_sec(
4288: l_resource_id IN NUMBER )
4289: IS
4290: SELECT min(start_date_active)
4291: FROM jtf_rs_salesreps
4292: WHERE resource_id = l_resource_id
4293: AND end_date_active is null;
4294:
4295: CURSOR c_validate_user_id(