APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 2265: FROM jtf_rs_role_relations

2261: l_resource_id IN NUMBER )
2262: IS
2263: SELECT min(start_date_active),
2264: max(end_date_active)
2265: FROM jtf_rs_role_relations
2266: WHERE role_resource_type = 'RS_INDIVIDUAL'
2267: AND role_resource_id = l_resource_id
2268: AND nvl(delete_flag, 'N') <> 'Y'
2269: AND end_date_active is not null;

Line 2276: FROM jtf_rs_role_relations

2272: CURSOR c_related_role_dates_sec(
2273: l_resource_id IN NUMBER )
2274: IS
2275: SELECT min(start_date_active)
2276: FROM jtf_rs_role_relations
2277: WHERE role_resource_type = 'RS_INDIVIDUAL'
2278: AND role_resource_id = l_resource_id
2279: AND nvl(delete_flag, 'N') <> 'Y'
2280: AND end_date_active is null;

Line 2289: jtf_rs_role_relations jrrr

2285: IS
2286: SELECT min(jrrr.start_date_active),
2287: max(jrrr.end_date_active)
2288: FROM jtf_rs_group_members jrgm,
2289: jtf_rs_role_relations jrrr
2290: WHERE jrgm.group_member_id = jrrr.role_resource_id
2291: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
2292: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
2293: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 2303: jtf_rs_role_relations jrrr

2299: l_resource_id IN NUMBER )
2300: IS
2301: SELECT min(jrrr.start_date_active)
2302: FROM jtf_rs_group_members jrgm,
2303: jtf_rs_role_relations jrrr
2304: WHERE jrgm.group_member_id = jrrr.role_resource_id
2305: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
2306: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
2307: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 2318: jtf_rs_role_relations jrrr

2314: IS
2315: SELECT min(jrrr.start_date_active),
2316: max(jrrr.end_date_active)
2317: FROM jtf_rs_team_members jrtm,
2318: jtf_rs_role_relations jrrr
2319: WHERE jrtm.team_member_id = jrrr.role_resource_id
2320: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
2321: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
2322: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 2333: jtf_rs_role_relations jrrr

2329: l_resource_id IN NUMBER )
2330: IS
2331: SELECT min(jrrr.start_date_active)
2332: FROM jtf_rs_team_members jrtm,
2333: jtf_rs_role_relations jrrr
2334: WHERE jrtm.team_member_id = jrrr.role_resource_id
2335: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
2336: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
2337: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 4190: FROM jtf_rs_role_relations

4186: l_resource_id IN NUMBER )
4187: IS
4188: SELECT min(start_date_active),
4189: max(end_date_active)
4190: FROM jtf_rs_role_relations
4191: WHERE role_resource_type = 'RS_INDIVIDUAL'
4192: AND role_resource_id = l_resource_id
4193: AND nvl(delete_flag, 'N') <> 'Y'
4194: AND end_date_active is not null;

Line 4201: FROM jtf_rs_role_relations

4197: CURSOR c_related_role_dates_sec(
4198: l_resource_id IN NUMBER )
4199: IS
4200: SELECT min(start_date_active)
4201: FROM jtf_rs_role_relations
4202: WHERE role_resource_type = 'RS_INDIVIDUAL'
4203: AND role_resource_id = l_resource_id
4204: AND nvl(delete_flag, 'N') <> 'Y'
4205: AND end_date_active is null;

Line 4214: jtf_rs_role_relations jrrr

4210: IS
4211: SELECT min(jrrr.start_date_active),
4212: max(jrrr.end_date_active)
4213: FROM jtf_rs_group_members jrgm,
4214: jtf_rs_role_relations jrrr
4215: WHERE jrgm.group_member_id = jrrr.role_resource_id
4216: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
4217: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4218: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 4228: jtf_rs_role_relations jrrr

4224: l_resource_id IN NUMBER )
4225: IS
4226: SELECT min(jrrr.start_date_active)
4227: FROM jtf_rs_group_members jrgm,
4228: jtf_rs_role_relations jrrr
4229: WHERE jrgm.group_member_id = jrrr.role_resource_id
4230: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
4231: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4232: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 4243: jtf_rs_role_relations jrrr

4239: IS
4240: SELECT min(jrrr.start_date_active),
4241: max(jrrr.end_date_active)
4242: FROM jtf_rs_team_members jrtm,
4243: jtf_rs_role_relations jrrr
4244: WHERE jrtm.team_member_id = jrrr.role_resource_id
4245: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4246: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4247: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 4258: jtf_rs_role_relations jrrr

4254: l_resource_id IN NUMBER )
4255: IS
4256: SELECT min(jrrr.start_date_active)
4257: FROM jtf_rs_team_members jrtm,
4258: jtf_rs_role_relations jrrr
4259: WHERE jrtm.team_member_id = jrrr.role_resource_id
4260: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4261: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4262: AND nvl(jrtm.delete_flag, 'N') <> 'Y'