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 2288: FROM jtf_rs_group_members jrgm,

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

Line 2302: FROM jtf_rs_group_members jrgm,

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

Line 4213: FROM jtf_rs_group_members jrgm,

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

Line 4227: FROM jtf_rs_group_members jrgm,

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