DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_SALESREPS

Line 2348: FROM jtf_rs_salesreps

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

Line 2357: FROM jtf_rs_salesreps

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

Line 4273: FROM jtf_rs_salesreps

4269: l_resource_id IN NUMBER )
4270: IS
4271: SELECT min(start_date_active),
4272: max(end_date_active)
4273: FROM jtf_rs_salesreps
4274: WHERE resource_id = l_resource_id
4275: AND end_date_active is not null;
4276:
4277:

Line 4282: FROM jtf_rs_salesreps

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