eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 2287: FROM jtf_rs_group_members jrgm,

2283: l_resource_id IN NUMBER )
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'

Line 2301: FROM jtf_rs_group_members jrgm,

2297: CURSOR c_grp_mbr_role_dates_sec(
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'

Line 4222: FROM jtf_rs_group_members jrgm,

4218: l_resource_id IN NUMBER )
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'

Line 4236: FROM jtf_rs_group_members jrgm,

4232: CURSOR c_grp_mbr_role_dates_sec(
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'