APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 2264: FROM jtf_rs_role_relations

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

Line 2275: FROM jtf_rs_role_relations

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

Line 2288: jtf_rs_role_relations jrrr

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

Line 2302: jtf_rs_role_relations jrrr

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

Line 2317: jtf_rs_role_relations jrrr

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

Line 2332: jtf_rs_role_relations jrrr

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

Line 4199: FROM jtf_rs_role_relations

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

Line 4210: FROM jtf_rs_role_relations

4206: CURSOR c_related_role_dates_sec(
4207: l_resource_id IN NUMBER )
4208: IS
4209: SELECT min(start_date_active)
4210: FROM jtf_rs_role_relations
4211: WHERE role_resource_type = 'RS_INDIVIDUAL'
4212: AND role_resource_id = l_resource_id
4213: AND nvl(delete_flag, 'N') <> 'Y'
4214: AND end_date_active is null;

Line 4223: jtf_rs_role_relations jrrr

4219: IS
4220: SELECT min(jrrr.start_date_active),
4221: max(jrrr.end_date_active)
4222: FROM jtf_rs_group_members jrgm,
4223: jtf_rs_role_relations jrrr
4224: WHERE jrgm.group_member_id = jrrr.role_resource_id
4225: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
4226: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4227: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 4237: jtf_rs_role_relations jrrr

4233: l_resource_id IN NUMBER )
4234: IS
4235: SELECT min(jrrr.start_date_active)
4236: FROM jtf_rs_group_members jrgm,
4237: jtf_rs_role_relations jrrr
4238: WHERE jrgm.group_member_id = jrrr.role_resource_id
4239: AND jrrr.role_resource_type = 'RS_GROUP_MEMBER'
4240: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4241: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 4252: jtf_rs_role_relations jrrr

4248: IS
4249: SELECT min(jrrr.start_date_active),
4250: max(jrrr.end_date_active)
4251: FROM jtf_rs_team_members jrtm,
4252: jtf_rs_role_relations jrrr
4253: WHERE jrtm.team_member_id = jrrr.role_resource_id
4254: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4255: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4256: AND nvl(jrtm.delete_flag, 'N') <> 'Y'

Line 4267: jtf_rs_role_relations jrrr

4263: l_resource_id IN NUMBER )
4264: IS
4265: SELECT min(jrrr.start_date_active)
4266: FROM jtf_rs_team_members jrtm,
4267: jtf_rs_role_relations jrrr
4268: WHERE jrtm.team_member_id = jrrr.role_resource_id
4269: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
4270: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
4271: AND nvl(jrtm.delete_flag, 'N') <> 'Y'