DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on JTF_RS_GROUP_USAGES

Line 3939: jtf_rs_group_usages usg

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