DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_RS_GROUP_USAGES

Line 3941: jtf_rs_group_usages usg

3937:
3938: IF ( p_group_type = 'RS_GROUP' ) THEN
3939: SELECT grp.group_name INTO x_group_name
3940: FROM jtf_rs_groups_vl grp,
3941: jtf_rs_group_usages usg
3942: WHERE grp.group_id = p_owner_group_id
3943: AND grp.group_id = usg.group_id
3944: AND usg.usage = 'SUPPORT'
3945: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE)